Re: Benefits of Keep Pool

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 08 Mar 2004 13:24:56 -0800
Message-ID: <1078781064.413856@yasure>

NetComrade wrote:

> 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

Are you referring to the use of DBMS_SHARED_POOL.KEEP?

If so documentation can be found at http://tahiti.oracle.com.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Mar 08 2004 - 15:24:56 CST