Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help:dbms_shared_pool.keep
In the shared pool. It shouldn't get flushed if it is marked as kept.
<u518615722_at_spawnkill.ip-mobilphone.net> wrote in message
news:l.988217277.1495422363@[198.138.198.252]...
> Folks,
> If I run dbms_shared_pool.keep to pin a
> procedure, where did the oracle keep the
> procedure?
> in buffer_pool_keep or
> in large_pool_size or
> in shared_pool_reserved_size or
> in shared_pooL?
>
> If i run alter system flush shared_pool,
> will pinned procedure get flushed as well?
>
> Thanks
>
>
>
>
> --
> Sent by dbadba62 from hotmail in field com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Apr 26 2001 - 04:49:51 CDT