Re: estimate table size and cache large table

What version of Oracle are you using? The CACHE keyword is redundant in 8.1, for example, and it is of dubious benefit in 8, too, unless you are intending to use a keep buffer pool.

And personally, I found next to zero difference with 7.3, too.

Regards
HJR "Richard Chen" <qchen_at_snet.net> wrote in message news:39A42128.1A545B1D_at_snet.net...
> I am considering cacheing a full large table in RAM to speed up
> performance
> of complicated queries. Is there a simple way to estimate the size in
> bytes of
> a more or less static table? This way I can set the right server
> parameters.
>
> Also, how large a table have people cached in practice? Is it only
> limited by
> RAM available on the machine?
>
> Thanks
>
> Richard Chen
>
Received on Sun Aug 27 2000 - 03:04:03 CDT