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

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)