Saturday, September 3, 2011

SYSAUX tablespace usage details.


v$sysaux_occupants view provides sysaux tablespace usage and schema details.

select  SCHEMA_NAME ,OCCUPANT_NAME ,SPACE_USAGE_KBYTES from v$sysaux_occupants