Re: help:dbms_shared_pool.keep
From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Thu, 26 Apr 2001 10:49:51 +0100
Message-ID: <988278644.23661.0.nnrp-12.c30bdde2_at_news.demon.co.uk>
Date: Thu, 26 Apr 2001 10:49:51 +0100
Message-ID: <988278644.23661.0.nnrp-12.c30bdde2_at_news.demon.co.uk>
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_at_[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 - 11:49:51 CEST