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
© Copyright SS64.com 1999-2013
Some rights reserved