【多选题】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...
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.
【单选题】In your running instance, some of the initialization parameters are set as shown below: SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET...
A.
The STATISTICS_LEVEL initialization parameter is set to BASIC
B.
The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
C.
The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
D.
The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
E.
The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
【简答题】Fill in the blanks with the following words. Change the forms where necessary. Being able to clearly _______ a differing perspective should be central to your business plan. Her presence _______ an ai...