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