A、 SORT_AREA_SIZE
B、 HASH_AREA_SIZE
C、 BITMAP_MERGE_AREA_SIZE
D、 CREATE_BITMAP_AREA_SIZE
E、 PGA_AGGREGATE_TARGET
更多“Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（） ”相关的问题
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
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
A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO. B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas. C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management. D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
A、 Automatic PGA Memory Management B、 Automatic SGA Memory Management C、 Automatic Shared Memory Management D、 Automatic Memory Management E、 Manual SGA Memory Management F、 None of the above
A、A. Automatic PGA Memory Management B、B. Automatic SGA Memory Management C、C. Automatic Shared Memory Management D、D. Automatic Memory Management E、E. Manual SGA Memory Management F、F. None of the above
A、 Automatic PGA Memory Management B、 Automatic SGA Memory Management C、 Automatic Shared Memory Management D、 Automatic Memory Management E、 Manual SGA Memory Management F、 None of the above
A、 20% SGA 80% PGA B、 25% SGA 75% PGA C、 50% SGA 50% PGA D、 75% SGA 25% PGA E、 80% SGA 20% PGA
A、 Set MEMORY_TARGET to zero B、 Set the STATISTICS_LEVEL parameter to BASIC C、 Set the WORKAREA_SIZE_POLICY parameter to MANUAL D、 Set the PGA_AGGREGATE_TARGET parameter to nonzero value
A、 You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file. B、 Oracle can reallocate memory between the SGA and PGA automatically as needed. C、 To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file. D、 You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
客服
TOP
查看正确答案
