schema size in oracle

To calculate the actual size of the schema or user in oracle database use the query below.

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