Re: db buffer keep etc

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Sat, 09 Mar 2002 07:54:59 GMT
Message-ID: <3c89bf35.4464457@news-vip.optusnet.com.au>

>
>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.
>

and don't forget that "loading a table in keep pool" doesn't mean that the ENTIRE table will live there!

All it means is that ANY blocks from that table that MAY be requested WILL be in this area of the pool and subjected to its management characteristics.

Together with any other blocks from any other tables "loaded" into this pool.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Sat Mar 09 2002 - 01:54:59 CST