Occupants usage in sysaux tablespace - Oracle Database Script. SELECT occupant_name, occupant_desc, space_usage_kbytes FROM v$sysaux_occupants;
SELECT occupant_name, occupant_desc, space_usage_kbytes FROM v$sysaux_occupants;