Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> estimate table size and cache large table

estimate table size and cache large table

From: Richard Chen <qchen_at_snet.net>
Date: Wed, 23 Aug 2000 15:08:24 -0400
Message-ID: <39A42128.1A545B1D@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 Wed Aug 23 2000 - 14:08:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US