5-18
Copyright Ó Oracle Corporation, 1999. All rights reserved.
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