OCP Oracle DBA in Montreal at Desjardins
Latest posts by Cyrille Modiano (see all)
- Renaming a RAC cluster - 27/09/2018
- Stop/Start all RAC databases at once - 26/09/2018
- RMAN Backup script - 08/11/2017
Description
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;