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 -> Re: Pinning and Flushing (in the SGA)

Re: Pinning and Flushing (in the SGA)

From: Chandra Pabba <chandra_pabba_at_sabre.com>
Date: Tue, 03 Aug 1999 13:17:02 -0400
Message-ID: <37A7240E.E15C38FD@sabre.com>


Hi Graham,

Yes, the packages will remain in the shared pool, even after the flush.

THanks

Chandra

Graham C Thornton wrote:

> Here's a quickie.....
>
> If I pin a package in the pool with DBMS_SHARED_POOL.KEEP....
>
> will that package stay in the pool during an shared pool flush??
>
> Thanks in advance.
>
> Graham
>
> --
> Empowerment - delegating the responsibility but not the authority.
> -------------------------------
>
> Opinions expressed do not necessarily reflect those of Abbott Laboratories.
Received on Tue Aug 03 1999 - 12:17:02 CDT

Original text of this message

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