Re: Oracle Keep Pool

From: joel garry <>
Date: Wed, 25 Nov 2009 14:13:45 -0800 (PST)
Message-ID: <>

On Nov 25, 12:55 pm, Charles Hooper <> wrote:

> This thread starts out describing memory limits on 32 bit Windows and
> eventually switches to a discussion of the DEFAULT, KEEP, and RECYCLE
> pool - including a test case I provided a couple years ago (might be
> interesting to re-run the test case again to see if there are faults
> in the test case).

Thanks, I had completely forgotten about that.

> In this thread, after prompting by Jonathan Lewis, I noticed that the
> number of blocks cached by the test table and index gradually
> decreased (when checked every 60 seconds) once the query completed
> (the database instance was otherwise idle) - might be interesting to
> see if the same behavior is present when the objects are located in
> the KEEP pool:

My compliments to the chef! :-)

Yes, this Oracle thing has gotten quite amazing. All we have to do is figure out how to explain to people that rule of thumbs (especially percentages of what to KEEP) are a mistake, as a rule of thumb.


-- is bogus.
Received on Wed Nov 25 2009 - 16:13:45 CST

Original text of this message