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.