494.Which statement about Automatic Memory Management with Oracle 11g is true?
A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.
B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
Answer: B
哪一项关于Oracle 11g的自动内存管理是正确的?
A错误,即使设置了SGA_TARGET或PGA_AGGREGATE_ TARGET参数,也可以再指定MEMORY_TARGET。
B正确,动态控制SGA和PGA。
C错误,启用AMM,只要设置MEMORY_TARGET为非零值即可。
D错误,MEMORY_TARGET是SGA和PGA大小的下限值的和。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2124422/
,如需转载,请注明出处,否则将追究法律责任。