多项选择题

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？（）

A. Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.
B. Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.
C. Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.
D. Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.
E. Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool component to the desired size by reallocating the additional memory from the auto-tuned memory components.
F. Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.

点击查看答案

上一题目录下一题

相关考题

单项选择题

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？（）

A. MMAN
B. PMON
C. MMON
D. MMNL

多项选择题

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？（）

A. The SGA_TARGET initialization parameter cannot be set to a value less than 1G
B. The SGA_TARGET initialization parameter cannot be set to a value greater than 1G
C. The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA
D. The values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.
E. No minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters.
F. The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.

单项选择题

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.