How to find diskspace used of objects with Oracle

select owner, segment_name,sum(bytes/1024/1024) from dba_segments
group by owner, segment_name
order by sum(bytes/1024/1024) desc

If you only need the diskspace by owner :

select owner,sum(bytes/1024/1024) from dba_segments
group by owner
order by sum(bytes/1024/1024) desc

Source : https://community.oracle.com/thread/2364575?tstart=0


Published 19th Jun 2014 // #oracle




comments powered by Disqus