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.
正确答案:C
答案解析:有
微信扫一扫手机做题