PL/SQL Packages DBMS_SHARED_POOL

Display the size of objects in the shared pool, and mark them for keeping or unkeeping in order to reduce memory fragmentation.

Subprocedures:

SIZES  Show objects in the shared pool that are larger than the specified size 

KEEP   Keep an object in the shared pool 

UNKEEP Unkeeps the named object 

ABORTED_REQUEST_THRESHOLD 
       Set the aborted request threshold for the shared pool

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

Related Commands:

init.ora

Related Packages:



© Copyright SS64.com 1999-2013
Some rights reserved