What must you do to enable Automated SQL Execution Memory Management?

What must you do to enable Automated SQL Execution Memory Management?

What must you do to enable Automated SQL Execution Memory Management?

A.
Unset the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE,
CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and
SORT_AREA_RETAINED_SIZE.

B.
Set the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE,
CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and
SORT_AREA_RETAINED_SIZE all to AUTO.

C.
Set the instance parameter PGA_AGGREGATE_TARGET and
WORKAREA_SIZE_POLICY to appropriate values.

D.
Execute the DBMS_STATS.GATHER_SYSTEM_STATS procedure with appropriate
values



Leave a Reply 0

Your email address will not be published. Required fields are marked *