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.
--
Regards,
Yavor Ivanov
Senior Database Expert
Stemo Ltd
On Tue, 09 Jan 2007 22:26:22 +0200, Binh Pham <binhpham15_at_hotmail.com> wrote:
> If the KEEP pool is not large enough, whap happens to the blocks from objects
> that are supposed to go to the KEEP pool when KEEP pool is full? Does Oracle
> flush out existing blocks in the KEEP pool for the new blocks or the overflows
> go to the DEFAULT pool?
>
>
> Dave vs. Carl: The Insignificant Championship Series. Who will win? -- http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 10 2007 - 09:46:44 CST
