多项选择题
A. Advisor Central
B. Global Attributes
C. Resource Monitors
D. Memory Parameters
E. Database Usage Statistics
F. All Initialization Parameters
G. Automatic Workload Repository
单项选择题 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?()
单项选择题 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? ()