（640）Examine the parameter setting in your database:

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 per policy,60%of the memory for System Global Area(SGA)

and 40%of the memory for Program Global Area(PGA)will be distributed at startup

答案：（D）

解析：

从Oracle11g开始，内存的管理SGA和PGA实现自动管理，只要设置MEMORY_TARGET参数就可以了，然后按照SGA和PGA的比例6、4来分赃

ITPub博客

Oracle 11G OCP 1Z0-053 640