Re: Benefits of Keep Pool

From: Mark <simmons_mark_at_yahoo.com>
Date: 9 Mar 2004 11:59:35 -0800
Message-ID: <5366fb41.0403091159.2ee11f7e@posting.google.com>

I'm not sure about 8i, but under 9i I believe that objects are never placed on the LRU end of the chain with the keep pool. (seems that I've read that somewhere)

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

netcomrade_at_karlson.dmitriev.net (NetComrade) 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
Received on Tue Mar 09 2004 - 13:59:35 CST