OCP-1Z0-053-200题-63题-640
来源:互联网 发布:松下plc扩展编程手册 编辑:程序博客网 时间:2024/06/02 00:33
QUESTION 63
Examine the parameter setting in your database:
SQL> SHOW PARAMETER TARGET
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 808M
memory_target big integer 808M
pga_aggregate_target big integer 0
sga_target big integer 0
SQL> SHOW PARAMETE SGA_MAX_SIZE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 808M
Which statement is correct about the database?
A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET
are not set
B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and
SGA_TARGET are set
C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and
SGA_TARGET are set
D. Automatic memory management is enabled and, as perpolicy, 60% of the memory for System Global Area
(SGA) and 40% of the memory for Program Global Area (PGA)will be distributed at startup
Answer: D
同640题:http://blog.csdn.net/rlhua/article/details/12494633
Explanation/Reference:
Section: Managing Database Performance & Tuning
Not sure about the policy stuff, but it's the default behavior when memory_target and memory_max_target are
set, sga_max_target is always set automatically to the same value as memory_max_target
http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/memory.htm#47750
Configuring Automatic PGA Memory
When configuring a brand new instance, it is hard to know precisely the appropriate setting for
PGA_AGGREGATE_TARGET. You can determine this setting in three stages:
Make a first estimate for PGA_AGGREGATE_TARGET, based on a rule of thumb. By default, Oracle
uses
20% of the SGA size. However, this initial setting may be too low for a large DSS system.
Run a representative workload on the instance and monitor performance, using PGA statistics collected
by Oracle, to see whether the maximum PGA size is under-configured or over-configured.
Tune PGA_AGGREGATE_TARGET, using Oracle PGA advice statistics.
- OCP-1Z0-053-200题-63题-640
- OCP-1Z0-053-V12.02-640题
- OCP-1Z0-053-200题-200题-61
- OCP-1Z0-053-200题-1题-677
- OCP-1Z0-053-200题-4题-88
- OCP-1Z0-053-200题-2题-86
- OCP-1Z0-053-200题-3题-87
- OCP-1Z0-053-200题-5题-89
- OCP-1Z0-053-200题-6题-90
- OCP-1Z0-053-200题-7题-91
- OCP-1Z0-053-200题-8题-92
- OCP-1Z0-053-200题-9题-93
- OCP-1Z0-053-200题-10题-94
- OCP-1Z0-053-200题-11题-95
- OCP-1Z0-053-200题-12题-96
- OCP-1Z0-053-200题-13题-97
- OCP-1Z0-053-200题-14题-675
- OCP-1Z0-053-200题-15题-15
- Linux C编程——在指定位置输入指定长度的字符串
- iOS中单例的用法
- Ubuntu10.04下ffmpeg选项详解(中文补充)
- 2011-05-26 23:21 windows路径操作API函数
- 在后台控制一个a标签或者button(控件)的显示与否,或者禁用与否
- OCP-1Z0-053-200题-63题-640
- 字符串比较——最简单的方法(有点水)
- SQL Nexus Tool
- 堆和栈的区别——给初学者
- 正则表达式高级用法\1
- POJ 3422 Kaka's Matrix Travels
- 块设备驱动程序之一
- SpringMVC + spring3.1.1 + hibernate4.1.0 集成及常见问题总结
- freemarker 简单模板