Re: Benefits of Keep Pool

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 12 Mar 2004 22:48:02 +1100
Message-ID: <4051a379$0$3958$afc38c87@news.optusnet.com.au>

"Mark" <simmons_mark_at_yahoo.com> wrote in message news:5366fb41.0403101205.3dfe291a_at_posting.google.com...
> Howard,
>
> I've used the KEEP pool for something just like this. We have a
> product that requires quick access via indexes for our GUI users,
> while at the same time there are full table/index scans going on in an
> optimization process in the background. Since we can't have the
> optimization flushing the GUI indexes from the pool, we put them in
> KEEP. We also don't want to put the optimization stuff into the
> RECYCLE pool because we need it to be cached too.
>
> The whole thing works really well.

Agreed. Proper use of the keep and recycle pools ought to be compulsory, and is an important part of a tuning strategy.

HJR Received on Fri Mar 12 2004 - 05:48:02 CST