SYSAUX tablespace objects

Latest posts by Cyrille Modiano (see all)


This script list all objects stored in the SYSAUX tablespace ordered by space used.

SYSAUX objects script

set lines 150 pages 100
col Object_Name FOR a30
col "Space Used (MB)" FORMAT 9999.99
col  Owner for a30
SELECT  occupant_name "OBJECT_NAME",
    space_usage_kbytes/1024 "Space Used (MB)",
    schema_name "Owner"
FROM v$sysaux_occupants
ORDER BY 2 desc;

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.