Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> dbms_shared_pool.keep
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
Received on Fri Apr 13 2007 - 18:40:11 CDT