查询oracle大字段所占空间大小的sql

select a.owner,a.table_name,a.column_name,b.segment_name,ROUND(b.BYTES / 1024 / 1024) ss from dba_lobs a,dba_segments b where a.segment_name = b.segment_name and a.owner = '用户名' order by ss desc

查询oracle的索引所占空间大小的sql

select a.owner,dba_segments b where a.index_name = b.segment_name and a.owner = '用户名' order by ss desc