The SPFILE for your database contains the following parameter settings: SGA_TARGET = 1000M DB_CACHE_SIZE = 512M SHARED_POOL_SIZE = 128M LOG_BUFFER = 10M DB_8K_CACHE_SIZE = 50M What is the total memory that can be distributed across the auto-tuned memory components?()
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?()
Which two statements are true regarding the SGA_TARGET initialization parameter()
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?()
By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?()