db_space_usage_schema_size.sql

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Author       : Sameer S Choudhari
-- Description  : Find the schema size (GB)
-- Call Syntax  : @db_space_usage_schema_size.sql
-- Last Modified: 17/03/2015
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET LINES 220 PAGES 49999
COLUMN owner FORMAT a30
COLUMN owner FORMAT a30
SELECT owner,
       SUM(bytes)/1024/1024/1024 AS size_gb
FROM dba_segments
WHERE owner=upper('&owner')
GROUP BY
  owner
ORDER BY size_gb DESC;