Oracle in a Nutshell

Calls

PROCEDURE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD (threshold_size IN NUMBER);

Sets the maximum object size for which the shared pool will flush other objects to make room. If you attempt to load objects larger than threshold_size bytes, returns an ORA-04031 error if sufficient space is not available. New in Oracle8i.

PROCEDURE DBMS_SHARED_POOL.KEEP (name IN VARCHAR2, flag IN CHAR DEFAULT 'P');

Pins the object identified by name in the shared pool. The object’s type is identified by flag: ‘P’ or ‘p’ for package, procedure, or function; ‘C’ or ‘c’ for cursor (in Oracle8); ‘Q’ or ‘q’ for sequences; and ‘R’ or ‘r’ for triggers. Specifies any other character flag to pin a cursor identified by address and hash value (from V$SQLAREA) in name.

PROCEDURE DBMS_SHARED_POOL.SIZES (minsize IN NUMBER);

Displays objects and cursors in the shared pool that exceed minsize kilobytes in size.

PROCEDURE DBMS_SHARED_POOL.UNKEEP (name IN VARCHAR2, flag IN CHAR DEFAULT 'P');

Unpins the object of type flag and identified by name from the shared pool. Valid flag values are the same values as for DBMS_ SHARED_POOL.KEEP.