题目内容
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?()
查看答案
搜索结果不匹配?点我反馈