问题:
You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement:
SQL> SELECT name, value, isdefault 2 FROM v$parameter
3 WHERE name LIKE ’%size%’;
The output of this statement displays that the DB_CACHE_SIZE, SHARED_POOL_SIZE,
LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply?()
A . The SGA_TARGET initialization parameter cannot be set to a value less than 1G
B . The SGA_TARGET initialization parameter cannot be set to a value greater than 1G
C . The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA
D . The values of the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters cannot be set manually.
E . No minimum limits are imposed on the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters.
F . The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.
You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement:
SQL> SELECT name, value, isdefault 2 FROM v$parameter
3 WHERE name LIKE ’%size%’;
The output of this statement displays that the DB_CACHE_SIZE, SHARED_POOL_SIZE,
LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply?()
● 参考解析
本题暂无解析
相关内容
相关标签