Oracle: SYSAUX tablespace

Components

Several database components store data in the SYSAUX tablespace. These components can be queried from v$sysaux_occupants:

select
   occupant_name,
   occupant_desc,
   schema_name
from
   v$sysaux_occupants
order by
   occupant_name;

AO	Analytical Workspace Object Table	SYS
AUDIT_TABLES	DB audit tables	SYS
AUDSYS	AUDSYS schema objects	AUDSYS
AUTO_TASK	Automated Maintenance Tasks	SYS
EM	Enterprise Manager Repository	SYSMAN
EM_MONITORING_USER	Enterprise Manager Monitoring User	DBSNMP
EXPRESSION_FILTER	Expression Filter System	EXFSYS
JOB_SCHEDULER	Unified Job Scheduler	SYS
LOGMNR	LogMiner	SYSTEM
LOGSTDBY	Logical Standby	SYSTEM
ORDIM	Oracle Multimedia ORDSYS Components	ORDSYS
ORDIM/ORDDATA	Oracle Multimedia ORDDATA Components	ORDDATA
ORDIM/ORDPLUGINS	Oracle Multimedia ORDPLUGINS Components	ORDPLUGINS
ORDIM/SI_INFORMTN_SCHEMA	Oracle Multimedia SI_INFORMTN_SCHEMA Components	SI_INFORMTION_SCHEMA
PL/SCOPE	PL/SQL Identifier Collection	SYS
SDO	Oracle Spatial	MDSYS
SM/ADVISOR	Server Manageability - Advisor Framework	SYS
SM/AWR	Server Manageability - Automatic Workload Repository	SYS
SM/OPTSTAT	Server Manageability - Optimizer Statistics History	SYS
SM/OTHER	Server Manageability - Other Components	SYS
SMON_SCN_TIME	Transaction Layer - SCN to TIME mapping	SYS
SQL_MANAGEMENT_BASE	SQL Management Base Schema	SYS
STATSPACK	Statspack Repository	PERFSTAT
STREAMS	Oracle Streams	SYS
TEXT	Oracle Text	CTXSYS
TSM	Oracle Transparent Session Migration User	TSMSYS
ULTRASEARCH	Oracle Ultra Search	WKSYS
ULTRASEARCH_DEMO_USER	Oracle Ultra Search Demo User	WK_TEST
WM	Workspace Manager	WMSYS
XDB	XDB	XDB
XSAMD	OLAP Catalog	OLAPSYS
XSOQHIST	OLAP API History Tables	SYS