LOBS Queries
-- Display LOB Info
set lines 200 pages 30
column owner format a10
column tablespace_name format a25
column segment_name format a30
column segment_type format a20
column column_name format a30
column table_name format a30
select b.owner, b.segment_name, segment_type, b.tablespace_name , bytes, a.table_name, a.column_name, logging, compression, securefile
from dba_segments b, dba_lobs a
where a.segment_name=b.segment_name
and a.owner=b.owner
--and a.table_name='TAB1'
and b.bytes > 20000000000 -- 20GB
order by b.bytes desc