Re: calculate sizing of a table

Posted by Roshan on Oct 08, 2018; 7:01am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/calculate-sizing-of-a-table-tp6824p6825.html

Should I sum these below

We need to know which Oracle table size we wish to query:-

-Do we want only the row space consumed?
( select avg_row_len*num_rows from dba_tables)
-Do we want to include allocated file space for the table?
(select . . . from dba_segments)
-Do we want to include un-used extent space?
(select . . . from dba_data_files, dba_extents . . )

Ref: https://community.oracle.com/thread/2620577