Re: Objects in KEEP pool question
- From: "Yavor Ivanov" <Yavor_Ivanov@xxxxxxxx>
- To: binhpham15@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 10 Jan 2007 17:46:44 +0200
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@xxxxxxxxxxx> 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? --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
