Space taken by a schema in Oracle database

To estimate the space used by a schema, sum the bytes allocated to that schema’s segments in DBA_SEGMENTS. SELECT owner, ROUND(SUM(bytes) / 1024 / 1024 / 1024, 2) AS size_gb FROM dba_segments WHERE owner = ‘SCOTT’ GROUP BY owner; Use the schema name in uppercase unless it was created with quoted mixed-case identifiers. If you … Read more