Tuning the Shared Pool
Reserved Space
Diagnostic tools for tuning:
•
The V$SHARED_POOL _RESERVED dictionary view
•
The supplied package and procedure:
–
DBMS_SHARED_POOL
–
ABORTED_REQUEST_THRESHOLD
Guidelines: Set the SHARED_POOL_RESERVED_SIZE
parameter