Script to find schema size in Oracle

SELECT sum(bytes) / 1024 / 1024 / 1024 as "Size in GB"
  FROM dba_segments
 WHERE owner = UPPER('&schema_name');

Size in GB
----------
20,4860229