Re: Benefits of Keep Pool

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 10 Mar 2004 20:22:59 +1100
Message-ID: <404ede7a$0$3952$afc38c87@news.optusnet.com.au>

"NetComrade" <netcomrade_at_karlson.dmitriev.net> wrote in message news:slrnc4plad.4h5.netcomrade_at_karlson.dmitriev.net...
> Hi,
>
> What are the benefits of the Keep Pool in an OLTP environment?
> The table is going to be cached anyway, if accessed frequently.
> Will it help any latch contention?
>
> oracle 8.1.7.4/solaris 2.7
>

By virtue of the fact that defining a new buffer pool requires that you allocate it some latches, and that to do so you might end up increasing the total number of latches allocated to the buffer cache, it is possible that latch contention issues might be helped by having separate pools -though fundamentally, merely re-distrubuting the same number of latches between different pools isn't going to help at all.

But the real idea is that you have a separate area of the buffer cache from which a table cannot be dislodged by a huge full table scan, because those full table scans will be busy flushing out their own area of the buffer cache, namely the recycle pool.

Regards
HJR Received on Wed Mar 10 2004 - 03:22:59 CST