How to find out CLOB/LOB/BLOB Size in Oracle.


select  l.table_name ,s.segment_name, s.segment_type,sum(bytes)/1024/1024/1000
from dba_lobs l, dba_segments s
where s.segment_type = 'LOBSEGMENT'
and s.segment_name = l.segment_name
group by s.segment_name,s.segment_type,l.table_name ;