统计ORACLE schema下所有表大小包含clob,blob

select * from (SELECT OWNER,TABLE_NAME,SUM(dx) from (
SELECT owner,SEGMENT_NAME as table_name,SUM(BYTES)/1024/1024/1024 as dx FROM DBA_SEGMENTS WHERE (OWNER,SEGMENT_NAME) IN (
SELECT OWNER,TABLE_NAME FROM DBA_TABLES WHERE OWNER='&schema')
GROUP BY SEGMENT_NAME,owner
union ALL
select lob.owner,lob.table_name,sum(seg.bytes)/1024/1024/1024 as dx from dba_lobs lob,dba_segments seg 
where lob.segment_name=seg.segment_name and lob.OWNER='&schema' group by lob.owner,lob.table_name
) GROUP BY OWNER,TABLE_NAME ORDER  BY 3 DESC) where rownum <=10;