/* title: “How to find diskspace used of objects with Oracle " date: 2014-06-19 tags: [oracle ] */

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