Re: Cache a table

Kalle wrote:

> Hi all,
>
> when you would cache a table. what are the general rules if the amount
> of memory isn't a problem...
>
> tia
> Kalle

The general rule is don't bother.

Well, OK... what I mean is that if you are talking about the 'CACHE' clause of the alter table statement, or create table, statement, don't bother. It is a pretty poor way of achieving better performance, and has long since been superceded by the multiple buffer pools feature (first introduced in Oracle 8.0).

And the rules of thumb for those multiple buffer pools are:

tables smaller than 10% of your default pool are candidates for housing in the keep pool

Tables bigger than 200% of your keep pool are candidates for housing in the recycle pool.

But those are only rules of thumb.

Regards
HJR

-- 
--------------------------------------------
See my brand new website, soon to be full of 
new articles: www.dizwell.com.
Nothing much there yet, but give it time!!
--------------------------------------------