In addition to the SYSTEM tablespace, a SYSAUX tablespace is added automatically to all new Oracle Database 11g databases that you create. The SYSAUX tablespace serves as an auxiliary tablespace to the SYSTEM tablespace.
Because it is the default tablespace for many Oracle features and products that previously required their own tablespaces, the SYSAUX tablespace reduces the number of tablespaces that Oracle requires; it also reduces the number of tablespaces that you must maintain. Other functionality or features that previously used the SYSTEM tablespace can now use the SYSAUX tablespace, thus reducing the load on the SYSTEM tablespace.
For more information about the SYSAUX tablespace, see "Creating the SYSAUX Tablespace" in the Oracle Database Administrator's Guide.
Many of the attributes of the SYSAUX tablespace are set automatically and cannot be modified. For example, the SYSAUX tablespace is automatically set to use automatic segment space management. For more information, see "Specifying Segment Space Management in Locally Managed Tablespaces" in the Oracle Database Administrator's Guide.
However, you can use the SYSAUX Tablespace page to specify the location of the datafile, the default size of the SYSAUX tablespace, and its autoextend attributes. For more information about setting these attributes, see the chapter "Managing Tablespaces" in the Oracle Database Administrator's Guide.
Note: If you specify an existing data file for the SYSAUX tablespace, then you must select Reuse Existing File Name. Otherwise, the Database Upgrade Assistant alerts you to the fact that the file already exists and returns you to the SYSAUX Tablespace page.
Overview of the Database Upgrade Assistant
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.