clob 컬럼을 포함한 테이블의 크기 구하기

clob 컬럼을 포함한 테이블의 크기 구하기

select owner ,segment_name table_name ,        max(bytes)/1024/1024||' MB' table_size,        sum(nvl(lbytes,0))/1024/1024||' MB' lob_size,        (max(bytes)+sum(nvl(lbytes,0)))/1024/1024||' MB' total_size,        (max(bytes)+sum(nvl(lbytes,0)))/1024/1024 as num from ( select a.owner,a.segment_name,a.bytes,c.bytes lbytes  from dba_segments a , dba_lobs b , dba_segments c where a.owner in ('EBIZSLI', 'ECYBER', 'GCYBER')   and a.segment_name = 'SECUI_SIGN_LOG'   and a.segment_type = 'TABLE'   and a.segment_name = b.table_name(+)   and a.owner = b.owner(+)   and b.owner = c.owner(+)   and b.segment_name = c.segment_name(+)   ) group by    owner, segment_name order by to_number(num) desc; ;