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 -> Re: estimate table size and cache large table

Re: estimate table size and cache large table

From: Mark G <markag_at_wonderstats.com>
Date: Wed, 23 Aug 2000 15:28:33 -0400
Message-ID: <F4155D9F9AA4D111B9990020AFBA52D53FA2B8@class06.ip061.sfi-software.com>

Try this:

Analyze the table:

ANALYZE TABLE MYTABLE ESTIMATE STATISTICS; Then query DBA_TABLES:

Select NUM_ROWS * AVG_ROW_LEN SIZEINBYTES FROM DBA_TABLES;

that should give you a **rough** size of the table in bytes.

"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 Wed Aug 23 2000 - 14:28:33 CDT

Original text of this message

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