Re: dbms_shared_pool.keep

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 Received on Fri Apr 13 2007 - 19:16:35 CDT