Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: estimate table size and cache large table
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