问题:
Your SPFILE contains the following parameter settings:
SGA_TARGET = 8G
DB_CACHE_SIZE = 4G
SHARED_POOL_SIZE = 2G
LARGE_POOL_SIZE = 512M
JAVA_POOL_SIZE = 512M
LOG_BUFFER = 100M
SGA_MAX_SIZE = 10G
You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G, but instead of specifying a value of 10G for the SGA_TARGET initialization parameter, you erroneously execute the following statement:
SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH;
What is the result of this statement?()
A . The database crashes.
B . The large pool releases 512M of memory.
C . The large pool retains 1G of allocated memory.
D . The large pool increases to 1,512M of memory.
Your SPFILE contains the following parameter settings:
SGA_TARGET = 8G
DB_CACHE_SIZE = 4G
SHARED_POOL_SIZE = 2G
LARGE_POOL_SIZE = 512M
JAVA_POOL_SIZE = 512M
LOG_BUFFER = 100M
SGA_MAX_SIZE = 10G
You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G, but instead of specifying a value of 10G for the SGA_TARGET initialization parameter, you erroneously execute the following statement:
SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH;
What is the result of this statement?()
● 参考解析
本题暂无解析