Oracle Schema Disk Usage

Login to oracle using sqlplus and user: system

For example:

$sqlplus system/_Password_

Then run this query:

SQL> select sum(s.bytes)/1024/1024/1024 as size_in_gb, s.owner from dba_segments s group by s.owner order by size_in_gb desc;