๐ป Programming/Oracle 11g
[์ค๋ผํด/Oracle] ํน์ ์ฌ์ฉ์ ์์ ์ ํ ์ด๋ธ ๋ณ ์ฌ์ฉ๋ ํ์ธ ์ฟผ๋ฆฌ
์ผ์ด์น
2016. 6. 11. 21:11
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