← 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