Inside the Oracle
dbms_shared_pool
execute
dbms_shared_pool.keep('SYS.DICTIONARY_OBJ_OWNER','P')
execute
dbms_shared_pool.keep('SYS.DICTIONARY_OBJ_NAME','P')
execute
dbms_shared_pool.keep('SYS.PLITBLM','P')
execute
dbms_shared_pool.keep('SYS.DBMS_STANDARD','P')
The simple
act of pinning a package, procedure or
function using the Oracle dbms_shared_pool
package will call it into memory.
The Oracle dbms_shared_pool package may have
to be created in earlier releases of Oracle.
The dbms_shared_pool package is built using
the dbmspool.sql and prvtpool.plb scripts
located in (UNIX) $ORACLE_HOME/rdbms/admin
or (NT) x:\orant\rdbms\admin (where x: is
the home drive for the install).
Description of the DBMS_SHARED_POOL package:
PROCEDURE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
THRESHOLD_SIZE NUMBER IN
PROCEDURE DBMS_SHARED_POOL.KEEP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
FLAG CHAR IN DEFAULT
PROCEDURE DBMS_SHARED_POOL.PURGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
FLAG CHAR IN DEFAULT
HEAPS NUMBER IN DEFAULT
PROCEDURE DBMS_SHARED_POOL.SIZES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MINSIZE NUMBER IN
PROCEDURE DBMS_SHARED_POOL.UNKEEP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
FLAG CHAR IN DEFAULT
|
|
