单项选择题
A.The SGA_TARGET initialization parameter cannot be set to a value greater than 8G
B. The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G
C. The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G
D. The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M
E. The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M
多项选择题 You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration, you specify the following parameter settings in the SPFILE: SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE? ()
单项选择题 You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the 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?()