Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page