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来分赃
原文:http://blog.itpub.net/17013648/viewspace-1330593/