Re: Shared pool

On 2 Feb 2006 00:47:56 -0800, "nonor" <noeltrk_at_ifrance.com> wrote:

>Hello Sybrand
>
>I post from google, thank you for answer, do you have some ref where I
>can found this in oracle doc, I must argue to my customer...
>
>Thank yu

Actually if you must argue you are the one to search tahiti.oracle.com

But here it is

http://oraclesvca2.oracle.com/docs/cd/B10501_01/server.920/a96524/c08memor.htm

Read 'Allocation and Reuse of Memory in the Shared Pool'

But one must question whether this will convince your customer. Customers usually don't understand Oracle.

Oh, BTW, I actually observed statements stay in the shared pool many times myself: for DAYS!!!

--
Sybrand Bakker, Senior Oracle DBA