Calls
-
PROCEDURE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD(threshold_sizeIN 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(nameIN VARCHAR2,flagIN 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(minsizeIN NUMBER); Displays objects and cursors in the shared pool that exceed minsize kilobytes in size.
-
PROCEDURE DBMS_SHARED_POOL.UNKEEP(nameIN VARCHAR2,flagIN 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.