[오라클/Oracle] 특정 사용자 소유의 테이블 별 사용량 확인 쿼리

select 

owner, segment_name, segment_type, sum(bytes)/1024/1024 as MB

from 

dba_segments

where

owner='{username in uppercase}' 

group by owner, segment_name, segment_type order by MB