Re: db buffer keep etc

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 8 Mar 2002 23:33:47 -0800
Message-ID: <a8aed4.0203082333.27749e31@posting.google.com>

u518615722_at_spawnkill.ip-mobilphone.net (Mike F) wrote in message news:<l.1015611114.1376586914@[64.94.198.252]>...
> Hi, folks
>
> I am learning how to use db_buffer (keep,recycle,default).
> How do I know how many space left in keep pool?

The Keep and recycle Pool space are given out thru the Default Pool.

The Parameters Buffer_Pool_Keep and Buffer_Pool_Recycle are used to set these values.

U Can use V$Buffer_Pool to see what is the size of each pool and How amy latches have been given to each pool.

>
> What will happen if I keep more table in the keep pool than keep pool can hold?
>

The Keep Pool just Retains u'r Data and does not use the LRU/Touch Mechanisam to age out the Blocks but if u'r Loading to many tables in the Keep Pool and it's size is less then the age out will come into play.

See these and other statistics in

V$Buffer_Pool_Keep.

> Thanks for your help.

HTH Regards,
Ganesh R Received on Sat Mar 09 2002 - 01:33:47 CST