单项选择题
To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?()
A. RESUMABLE_SPACE_TIME
B. RESUMABLE_SPACE
C. RESUMABLE_TIME
D. RESUMABLE_TIMEOUT
E. TIME_RESUMABLE
相关考题
-
单项选择题
WhentuningAutomaticPGAMemoryManagement,whichofthefollowingviewswillprovidetheinformationspecified?()
A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management -
多项选择题
AutomaticPGAMemoryManagementeliminatestheneedtomanuallyconfigurewhichofthefollowinginitializationparameters?()
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
