Re: dbms_shared_pool.keep

On Apr 13, 7:16 pm, "Steve Howard" <stevedhow..._at_gmail.com> wrote:
> On Apr 13, 7:40 pm, haiwu..._at_gmail.com wrote:
>
>
>
> > I did the following:
> > SQL> exec SYS.DBMS_SHARED_POOL.KEEP('SYS.STANDARD','P');
>
> > PL/SQL procedure successfully completed.
>
> > SQL> select namespace, kept from v$db_object_cache where name like
> > 'DBMS_STANDARD%';
>
> > NAMESPACE KEP
> > ----------------------------------- ---
> > TABLE/PROCEDURE YES
> > BODY NO
>
> > It shows the package body is NOT kept. Is this expected behavior? This
> > is Oracle10g 10.1.0.4.2.
>
> > Thanks,
> > Hai
>
> Shouldn't your check query be for STANDARD%?
>
> SQL> exec SYS.DBMS_SHARED_POOL.KEEP('SYS.STANDARD','P');
>
> PL/SQL procedure successfully completed.
>
> SQL> select namespace, kept from v$db_object_cache where name like
> 'STANDARD%';
>
> NAMESPACE KEP
> ---------------------------- ---
> BODY YES
> TABLE/PROCEDURE YES
>
> SQL>
>
> HTH,
>
> Steve

Thanks Steve. My fault.

Yes it works with pining 'sys.standard' package. But it does not seem to be able to do the same thing for 'dbms_standard' package:

  1 select owner, namespace, kept,type from v$db_object_cache where name like
  2* 'DBMS_STANDARD%'

OWNER                NAMESPACE                    KEP TYPE
-------------------- ---------------------------- ---
----------------------------
SYS                  TABLE/PROCEDURE              YES PACKAGE
SYS                  BODY                         NO  NOT LOADED

I am also not sure when it says "NOT LOADED".

Any ideas?

Thanks,
Hai Received on Fri Apr 13 2007 - 20:07:21 CDT