多项选择题
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（）
A. SORT_AREA_SIZE
B. HASH_AREA_SIZE
C. BITMAP_MERGE_AREA_SIZE
D. CREATE_BITMAP_AREA_SIZE
E. PGA_AGGREGATE_TARGET
点击查看答案
相关考题
-
单项选择题
InOracle11g，bydefaultwhichoneofthefollowingconditionsimplicitlyenablesAutomaticPGAMemoryManagement？（）
A. Setting a nonzero value for SGA_TARGET
B. Configuring Automatic Shared Memory Management
C. Configuring Automatic Memory Management
D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
E. None of the above -
单项选择题
You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?（）
A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
B. ALTER DISKGROUP dg1 UNDROP;
C. ALTER DISKGROUP dg1 UNDROP DISKS;
D. You cannot cancel the pending disk drops. -
多项选择题
UsingOracleEnterpriseManagertosetSGApoolvaluesmanually，forwhichofthefollowingpoolsdoesOracleEMofferadvicetosetthevalueappropriately？（）
A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE
