To find the dba_segment for schema's in the database

SQL> select owner,sum(bytes)/1024/1024 MB from dba_segments group by owner order by MB;