-- =======================================================================
--  Lista de Lobs - sql 
-- =======================================================================
select  distinct a.owner, a.table_name, a.column_name, c.data_type, a.segment_name,
        round(b.bytes / (1024*1024)) as "MB", a.securefile, a.compression
from    dba_lobs a, dba_segments b, dba_tab_columns c
where   a.segment_name = b.segment_name
and       a.column_name = c.column_name
and       a.owner = b.owner
and       b.owner = c.owner
--and     b.tablespace_name = 'TD_DBSVS_LOB'
order by "MB" desc


select a.owner, a.table_name, round(b.bytes / (1024*1024)) as "MB"
from dba_tables a, dba_segments b
where a.table_name = b.segment_name
and     a.owner = b.owner