Re: Objects in KEEP pool question

---

From:  Wolfgang Breitling <breitliw@centrexcc.com>
Reply-To:  breitliw@centrexcc.com
To:  Yavor_Ivanov@stemo.bg
CC:  binhpham15@hotmail.com,oracle-l@freelists.org
Subject:  Re: Objects in KEEP pool question
Date:  Wed, 10 Jan 2007 09:56:57 -0700
>At 08:46 AM 1/10/2007, Yavor Ivanov wrote:
>>         All pools of cache (default, keep, recycle, nK) use
>>absolutely the same algorithms. You can make one big KEEP pool and
>>put big full-scaned tables in it and one small RECYCLE pool and put
>>important/lookup tables in it. The name of the pool is just to
>>explain it's idea. The behaviour (once a block is in the pool) is
>>the same for all.
>
>Not quite the same behaviour. There are subtle differences between
>the pools in how Oracle decides which blocks to age out. Steve Adams
>has information about that. Search the archives or his website for
>details. But the pools are completely separate. And once you
>assigned a segment to a particular pool it has to go into that pool
>and can't "overflow" into another pool.
>
>
>Regards
>
>Wolfgang Breitling
>Centrex Consulting Corporation
>www.centrexcc.com
>
>
>
>______________________________________________________________________
>This email has been scanned by the MessageLabs Email Security
>System.
>For more information please visit http://www.messagelabs.com/email
>______________________________________________________________________
>--
>http://www.freelists.org/webpage/oracle-l
>
>