Querying the actual size of the DB table

1. Querying the actual size of the DB table (guaranteed Clob/blob/nclob LOB large segment)

Select round (SUM (bytes/1024/1024/1024), 2) | | ' G ' from dba_segments where owner= ' user ' and segment_name = ' table ' OR segment_name in (select Segment_name from Dba_lobs where T Able_name= ' table ' and owner= ' user ');

If not DBA users can use User_segments & User_lobs and do not need owner.

2. query table LOB Field

Select round (SUM (b.bytes/1024/1024), 2) | | ' M ' from Dba_lobs A, dba_segments b where a.segment_name = b.segment_name and A.owner = ' user ' and a.table_name = ' table ';

3. query table size without LOB fields

Select round (SUM (bytes/1024/1024/1024), 2) | | ' G ' from user_segments where segment_name = ' table ';

Querying the actual size of the DB table