Re: Objects in KEEP pool question
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: Yavor_Ivanov@xxxxxxxx
- 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
______________________________________________________________________
--
//www.freelists.org/webpage/oracle-l
Other related posts:
