A. Setting a nonzero value for SGA_TARGET
B. Configuring Automatic Shared Memory Management
C. Configuring Automatic Memory Management
D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
E. None of the above
答案:(C)
解析:
A(X):是设置SGA里的各块内存是自动管理的
B(X):与A相同
C(正确):配置自动内存管理,则SGA和PGA都是自动管理的。
D(X):参考PGA_AGGREGATE_TARGET参数的说明,其实与SGA_MAX_SIZE无关