|Oracle® Database Administrator's Guide
11g Release 2 (11.2)
Part Number E17120-11
|PDF · Mobi · ePub|
SYSAUX tablespace was installed as an auxiliary tablespace to the
SYSTEM tablespace when you created your database. Some database components that formerly created and used separate tablespaces now occupy the
SYSAUX tablespace becomes unavailable, core database functionality will remain operational. The database features that use the
SYSAUX tablespace could fail, or function with limited capability.
The list of registered occupants of the
SYSAUX tablespace are discussed in "About the SYSAUX Tablespace". These components can use the
SYSAUX tablespace, and their installation provides the means of establishing their occupancy of the
You can monitor the occupants of the
SYSAUX tablespace using the
V$SYSAUX_OCCUPANTS view. This view lists the following information about the occupants of the
Name of the occupant
Current space usage
View information is maintained by the occupants.
See Also:Oracle Database Reference for a detailed description of the
You will have an option at component install time to specify that you do not want the component to reside in
SYSAUX. Also, if you later decide that the component should be relocated to a designated tablespace, you can use the move procedure for that component, as specified in the
V$SYSAUX_OCCUPANTS view, to perform the move.
The move procedure also lets you move a component from another tablespace into the
SYSAUX tablespace is occupied by several database components, and its total size is governed by the space consumed by those components. The space consumed by the components, in turn, depends on which features or functionality are being used and on the nature of the database workload.
The largest portion of the
SYSAUX tablespace is occupied by the Automatic Workload Repository (AWR). The space consumed by the AWR is determined by several factors, including the number of active sessions in the system at any given time, the snapshot interval, and the historical data retention period. A typical system with an average of 10 concurrent active sessions may require approximately 200 to 300 MB of space for its AWR data.
The following table provides guidelines on sizing the
SYSAUX tablespace based on the system configuration and expected load.
|Number of CPUs||2||8||32|
|Number of concurrently active sessions||10||20||100|
|Number of user objects: tables and indexes||500||5,000||50,000|
||500 MB||2 GB||5 GB|
You can control the size of the AWR by changing the snapshot interval and historical data retention period. For more information on managing the AWR snapshot interval and retention period, see Oracle Database Performance Tuning Guide.
Another major occupant of the
SYSAUX tablespace is the embedded Oracle Enterprise Manager repository. This repository is used by Oracle Enterprise Manager Database Control to store its metadata. The size of this repository depends on database activity and on configuration-related information stored in the repository.
Other database components in the
SYSAUX tablespace will grow in size only if their associated features (for example, Oracle Text and Oracle Streams) are in use. If the features are not used, then these components do not have any significant effect on the size of the