← Space Management
Oracle · Space Management

How to check space used per schema in Oracle

Check space used per schema (owner) in Oracle, ranked by size, from DBA_SEGMENTS.

Tested on11g12c19c21c23ai26ai

Space consumed by each schema owner, ranked, so you can see which application owns the growth.

SELECT owner,
       ROUND(SUM(bytes)/1024/1024/1024, 2) AS gb,
       COUNT(*)                            AS segments
FROM   dba_segments
GROUP  BY owner
ORDER  BY SUM(bytes) DESC;
spaceschema-sizedba_segments