OCP 1Z0 052 53

来源：互联网发布：从零开始学mt4编程编辑：程序博客网时间：2024/04/23 14:09

53. You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted? (Choose
two.)
A.The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
B.The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
C.The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
D.The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB
and 270 MB, respectively.
to DBA_ALERT_HISTORY.
D.The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but
not the threshold alerts related to instance metrics.
Answer: AD

A
经实验，与该题所述不一样

SQL> alter system set memory_target=700m;System altered.SQL> alter system set memory_max_target=600m;alter system set memory_max_target=600m

改使用pfile max设置为0

SQL> startup pfile='d:\pfile.ora'ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET

D 是对的，PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M
这两个值设置后，表示的是最小值，而不是固定值。500-270-90 是可供调节部分

0 0