單項選擇題

You have included the following parameter setting in your server parameter file：       PGA_AGGREGATE_TARGET = 800M       
SORT_AREA_SIZE = 100M      
 HASH_AREA_SIZE = 100M       
BITMAP_MERGE_AREA_SIZE = 100M       
CREATE_BITMAP_AREA_SIZE = 100M  
Which statement is true？（）  

A. All the *_AREA_SIZE parameters are ignored.
B. The Automatic PGA Memory Management feature cannot be disabled.
C. The total Program Global Area （PGA） memory cannot be manually increased above 800M.
D. The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.

題目列表

你可能感興趣的試題

多項選擇題

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.
微信掃碼免費搜題