Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_SHARED_POOL, 3 of 5
This procedure keeps an object in the shared pool. Once an object has been kept in the shared pool, it is not subject to aging out of the pool. This may be useful for frequently used large objects. When large objects are brought into the shared pool, several objects may need to be aged out to create a contiguous area large enough.
DBMS_SHARED_POOL.KEEP ( name VARCHAR2, flag CHAR DEFAULT 'P');
An exception is raised if the named object cannot be found.
There are two kinds of objects:
For example:
DBMS_SHARED_POOL.KEEP('scott.hispackage')
This keeps package HISPACKAGE
, owned by SCOTT
. The names for PL/SQL objects follow SQL rules for naming objects (i.e., delimited identifiers, multi-byte names, etc. are allowed). A cursor can be keeped by DBMS_SHARED_POOL
.KEEP
('0034CDFF
, 20348871
'). The complete hexadecimal address must be in the first 8 characters.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|