At a high level, I think the various pools operate in pretty
much the same way - but there are some differences,
some of which may be affected by various hidden
parameters.
For example, Steve Adams has this note (dated Oct 2000)
on his website as one of several observations on the 'new'
LRU mechanism. Some details may have evolved since then, of course,
but it is a good indication of how the pools can be "the same, but
different".
<quote>
By default, the KEEP and RECYCLE buffer pools do not have a hot
region,
but this can be changed by setting the _db_percent_hot_keep and
_db_percent_hot_recycle parameters to non-zero values.
Otherwise, the RECYCLE buffer pool has exactly the same LRU
semantics as the DEFAULT buffer pool - it is only the name that
is different - and the KEEP buffer pool differs only in that
buffers
read for long table scans are cached just below the hot region
rather than at the LRU end and consistent read buffers are
immediately
frozen.
</quote>
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____England______January 21/23
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
-----Original Message-----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 03 January 2003 02:23
>2. The KEEP and RECYCLE Pools aren't really special in any sense: the
buffer
>algorithms are the same for these as for the DEFAULT pool - it is
just that
>these pools are named so that tables can be defaulted to load into
any one
>of them. By using this feature judiciously, you might be able to
avoid the
>problems of unneccesary buffering during FTS on tables smaller than
the
>threshhold without actually changing the undocumented parameter.
>
>Jonathan: Awaiting your expert comments on this new twist :)
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
