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

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

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

A.
Execute the DBMS_STATS.GATHER_SYSTEM_STATES procedure with appropriate values

B.
Set the instance parameters PGA_AGGREGATE_TARGET and
WORKAREA_SIZE_POLICY to appropriate values.

C.
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.

D.
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.

Explanation:
The automatic SQL execution memory management feature is enabled by setting the parameter WORKAREA_SIZE_POLICY to AUTO and by specifying a size of PGA_AGGREGATE_TARGET in the initialization file.



Leave a Reply 0

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