select l.table_name,s.segment_name,s.segment_type,sum(s.bytes)/1024/1024/1024
from dba_segments s,dba_lobs l
where s.segment_name=l.segment_name
and s.segment_name in ('SYS_LOB00000xxxxxxx06$$','SYS_LOB0000xxxxxxx00005$$')
group by l.table_name,s.segment_name,s.segment_type
order by 4 desc
;