Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: size of a table
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
![]() |
![]() |