Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> dbms_shared_pool.keep

dbms_shared_pool.keep

From: <haiwu.us_at_gmail.com>
Date: 13 Apr 2007 16:40:11 -0700
Message-ID: <1176507611.784698.83370@o5g2000hsb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US