Re: size of a table

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Jul 2006 09:47:16 -0700
Message-ID: <1152204436.591766.300730@a14g2000cwb.googlegroups.com>

Prasath wrote:
> How do we find out the size of a table in bytes?

Allocated size or used size?

For allocated size query DBA_SEGMENTS which provides the segment size in blocks and bytes.

For used space within the allocation qeury DBA_TABLES after updating the statistics. You can multply the blocks value by the tablespace block size to get the number of bytes being used.

Or, you can take the dba_tables.avg_row_len X num_rows to get a calculated size of the data without Oracle overhead.

Do you want to include the cost of the indexes? See DBA_INDEXES and/or DBA_SEGMENTS once again.

HTH -- Mark D Powell -- Received on Thu Jul 06 2006 - 11:47:16 CDT