SYSAUX
From Oracle FAQ
SYSAUX is the name of the compulsory tablespace, introduced in Oracle 10g, to support optional database components (called occupants) like AWR, Statspack, Oracle Streams, etc.
You can query v$sysaux_occupants, to get the list of SYSAUX occupants:
SQL> SELECT occupant_name, schema_name, space_usage_kbytes FROM v$sysaux_occupants; OCCUPANT_NAME SCHEMA_NAME SPACE_USAGE_KBYTES ------------------------- -------------------- ------------------ LOGMNR SYSTEM 6080 LOGSTDBY SYSTEM 896 STREAMS SYS 512 XDB XDB 49728 AO SYS 22400 XSOQHIST SYS 22400 XSAMD OLAPSYS 15936 SM/AWR SYS 77888 SM/ADVISOR SYS 11008 SM/OPTSTAT SYS 62080 SM/OTHER SYS 4864 STATSPACK PERFSTAT 0 ODM DMSYS 256 SDO MDSYS 33216 WM WMSYS 7040 ORDIM ORDSYS 512 ORDIM/PLUGINS ORDPLUGINS 0 ORDIM/SQLMM SI_INFORMTN_SCHEMA 0 EM SYSMAN 50560 TEXT CTXSYS 4736 ULTRASEARCH WKSYS 0 ULTRASEARCH_DEMO_USER WK_TEST 0 EXPRESSION_FILTER EXFSYS 3712 EM_MONITORING_USER DBSNMP 1600 TSM TSMSYS 256 JOB_SCHEDULER SYS 768 26 rows selected.
Also see[edit]
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
