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 -> pinning packages

pinning packages

From: <gwleung_at_pacbell.net>
Date: 1997/04/19
Message-ID: <3358F189.7999@pacbell.net>#1/1

I am running Oracle 7.1.6 and using dbms_shared_pool.keep to pin packages. My question is do I really need to compile the package (load into memory) before executing the dbms_shared_pool.keep procedure. By just pinning the package without loading it first, the v$db_object_cache.kept shows it is pinned. The only difference is the shared_memory value is smaller than if I compile the package first.

Grace Received on Sat Apr 19 1997 - 00:00:00 CDT

Original text of this message

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