Re: Pinning Packages Not Yet Loaded

It's probably worth checking that statement for each type of object in your specific version of Oracle. I think the v7 documentation used to state quite explicitly that KEEP could only keep objects that were already loaded; the same is not true for 8.1.5. (at least for sequences) - try the following test:

select name, kept from v$db_object_cache where type = 'SEQUENCE'

NAME                             KEP
-------------------------------- ---
IDGEN1$                          NO
OBJECT_GRANT              NO
AUDSES$                        NO
JOBSEQ                          YES

execute dbms_shared_pool.keep('JPS','Q');

PL/SQL procedure successfully completed.

select name, kept from v$db_object_cache where type = 'SEQUENCE';

NAME                             KEP
-------------------------------- ---
IDGEN1$                          NO
JPS                                 YES
OBJECT_GRANT              NO
AUDSES$                        NO
JOBSEQ                          YES

In this case, the KEEP call has apparently loaded the sequence before KEEPing it.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

ddf_dba_at_my-deja.com wrote in message <8jir3o$mp6$1_at_nnrp1.deja.com>...


>

>The assumption is in error  ("When you assume ...").  The

>DBMS_SHARED_POOL.KEEP function will pin objects already present in the

>shared SQL area but will NOT load them; if the object is not in the

>shared SQL area of the SGA DBMS_SHARED_POOL.KEEP will error out.

>