Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cache vs keep buffer pool
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<3d6a8c7c_at_dnews.tpgi.com.au>...
>
> The cache keyword is useless. Utterly, utterly useless.
And, I believe, now "deprecated"?
> Which means that nasty full scans on big tables cannot possibly flush your
> blocks from small, useful tables -provided you direct each sort of table to
> different pools.
Yup. In fact for large, seldom scanned tables I actually prefer to put them in RECYCLE. That way the scan will happen without shirting up KEEP or DEFAULT.
> If you are on 8.0 or above, there is practically no sense in setting
> 'CACHE'. The keep pool does it better, more reliably, and more effectively.
>
Unless you are in the buggy point release of 8.0 that needs the CACHE thing to be specified to send stuff to KEEP. DAMHIKT...
Cheers
Nuno Souto
nsouto_at_optushome.com.au
Received on Mon Aug 26 2002 - 23:34:39 CDT