Re: table sizing

From: oracle <oracle_at_cse.fau.edu>
Date: 1997/04/06
Message-ID: <3348127D.4776@cse.fau.edu>#1/1

Mark McWilliams wrote:
>
> Does anyone have an SQL stmt, stored procedure, etc to calculate
> the estimated size of tables and indexes. I know the steps are
> in the DBA guide, but I don't want to recreate the wheel.
>
> Thanks,
> Mark McWilliams

here is he idea.

table size(actual) = (dba_segments.blocks - dba_tables.empty_blocks) * db_block_size

similarly for index. Do query on the dba_segments and dba_tables to get the data and fine it.

Hope it halps. Received on Sun Apr 06 1997 - 00:00:00 CST