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