M. and 9:51 A.M.,
resulting in a ???Snapshot too old??? error for three queries. To prevent these errors, the undo
tablespace should be either manually resized or allowed to autoextend.
SYSAUX Monitoring and Usage
The SYSAUX tablespace, introduced in Oracle 10g, is an auxiliary tablespace to the SYSTEM
tablespace, and it houses data for several components of the Oracle database that either required
their own tablespace or used the SYSTEM tablespace in previous releases of Oracle. These
components include the Enterprise Manager Repository, formerly in the tablespace OEM_
REPOSITORY, as well as LogMiner, Oracle Spatial, and Oracle Text, all of which formerly used
the SYSTEM tablespace for storing configuration information. The current occupants of the
SYSAUX tablespace can be identified by querying the V$SYSAUX_OCCUPANTS view:
SQL> select occupant_name, occupant_desc, space_usage_kbytes
2 from v$sysaux_occupants;
OCCUPANT_NAME OCCUPANT_DESC SPACE_USAGE_KBYTES
------------- ---------------------------------------- ------------------
LOGMNR LogMiner 7744
LOGSTDBY Logical Standby 960
SMON_SCN_TIME Transaction Layer - SCN to TIME mapping 3328
PL/SCOPE PL/SQL Identifier Collection 384
STREAMS Oracle Streams 1024
XDB XDB 98816
AO Analytical Workspace Object Table 38208
XSOQHIST OLAP API History Tables 38208
XSAMD OLAP Catalog 15936
SM/AWR Server Manageability - Automatic Workloa 131712
d Repository
SM/ADVISOR Server Manageability - Advisor Framework 13248
SM/OPTSTAT Server Manageability - Optimizer Statist 52672
ics History
SM/OTHER Server Manageability - Other Components 6016
STATSPACK Statspack Repository 0
SDO Oracle Spatial 47424
WM Workspace Manager 7296
ORDIM Oracle interMedia ORDSYS Components 11200
Chapter 6: Monitoring Space Usage 183
ORDIM/PLUGINS Oracle interMedia ORDPLUGINS Components 0
ORDIM/SQLMM Oracle interMedia SI_INFORMTN_SCHEMA Com 0
ponents
EM Enterprise Manager Repository 155200
TEXT Oracle Text 5568
ULTRASEARCH Oracle Ultra Search 7616
ULTRASEARCH_D Oracle Ultra Search Demo User 12288
EMO_USER
EXPRESSION_FI Expression Filter System 3968
LTER
EM_MONITORING Enterprise Manager Monitoring User 1536
_USER
TSM Oracle Transparent Session Migration User 256
SQL_MANAGEMEN SQL Management Base Schema 1728
T_BASE
AUTO_TASK Automated Maintenance Tasks 320
JOB_SCHEDULER Unified Job Scheduler 576
29 rows selected.
Pages:
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334