Re: Benefits of Keep Pool

From: <Kenneth>
Date: Mon, 08 Mar 2004 21:43:01 GMT
Message-ID: <404ce74a.3781417@news.inet.tele.dk>

On 08 Mar 2004 20:53:10 GMT, netcomrade_at_karlson.dmitriev.net (NetComrade) wrote:

>Hi,
>
>What are the benefits of the Keep Pool in an OLTP environment?

In a strict OLTP, probably none. In a mixed environment, placing certain of the OLTP-related tables in the keep pool will prevent them from being pushed out of the buffer cache by frequent and huge table scans from the DW-related parts.
>The table is going to be cached anyway, if accessed frequently.
>Will it help any latch contention?

A keep pool is not a mean of helping latch contention.

>
>oracle 8.1.7.4/solaris 2.7
>
Received on Mon Mar 08 2004 - 15:43:01 CST