OracleStorage

Size of one schema

Total segment size in GB for the schema you enter.

Tested on 12c, 19c · verified Sep 2026

1SET VERIFY OFF2SELECT SUM (bytes)/1024/1024/1024 AS GB FROM dba_segments WHERE owner = UPPER('&schema_name');

Save it as ora-schema-size.sql and run it with SQL> @ora-schema-size.

Open in denrepoRelated tool: Data Pump command builder

More Oracle scripts: Storage

• Datafile usage with a bar graphEvery datafile with its size, used space, max size and a ten-character usage bar (X = used, - = free). Free_MB is the largest free extent in the…
• Database size three ways: allocated, used and totalAllocated datafile size, space actually used by segments, and the overall footprint including temp files, online redo logs and control files. All in…
• Database size summary: total, used and freeOne line with the database name and its total size (datafiles, temp files and redo logs), used space and free space, rounded to whole GB.
• Tablespace usageUsed and free space in GB against the maximum each tablespace can autoextend to, with its type (permanent, temporary or undo), fullest first.
• Datafiles with size and autoextend limitsEvery datafile, its current size, whether it can grow, and how far. Files with AUTOEXTEND NO in a busy tablespace are the ones that page you at night.
• Top 20 largest segmentsThe biggest tables, indexes, LOBs and partitions in the database.