Re: Objects in KEEP pool question

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 10 Jan 2007 09:56:57 -0700
Message-Id: <20070110165621.777E0595070@turing.freelists.org>

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

Received on Wed Jan 10 2007 - 10:56:57 CST