Sysaux tablespace and it's object
#################Check whats occupying SYSAUX tablespace########################
SQL> --Check whats occupying SYSAUX tablespace:
SQL> --Occupent occupying space in sysaux tablespac
SQL>
SQL> set pages 333 lines 222
SQL> select occupant_name,occupant_desc,space_usage_kbytes from v$sysaux_occupants;
Thanks & Regards
Nikhil Kumar.
Also you can use below script to get the details of occupants from sysaux tablespace.
ReplyDelete{ORACLE_HOME}/rdbms/admin/utlsyxsz.sql
Thanks & Regards
Nikhil Kumar.