单项选择题
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 have included the following parameter settings in your SPFILE: SGA_MAX_SIZE=8G SGA_TARGET=6G DB_CACHE_SIZE=2G SHARED_POOL_SIZE=1G LOG_BUFFER=64M DB_KEEP_CACHE_SIZE=960M Which statement is true if you modify the SGA_TARGET initialization parameter?()
多项选择题 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?()