What is SYSAUX table space?

What is SYSAUX table space?

The SYSAUX tablespace provides storage of non-sys-related tables and indexes that traditionally were placed in the SYSTEM tablespace. For example, the tables and indexes that were previously owned by the system user can now be specified for a SYSAUX tablespace. Only the SYSAUX tablespace datafile location is specified.

How do I increase the size of my Sysaux tablespace in Oracle?

Solutions:

1. Reduce the amount of monitored objects in EM.
2. Resize the SYSAUX tablespace according to the recommendations in above table. ALTER DATABASE DATAFILE ‘/path/systemSID.dbf’ RESIZE 1000M;
3. Resize the SYSTEM tablespace. ALTER DATABASE DATAFILE ‘/path/sysauxSID.dbf’ RESIZE 1000M;

Can Sysaux tablespace taken offline?

You can make the SYSAUX tablespace offline. You cannot make the SYSTEM tablespace read only or temporary and you cannot take it offline. …

How do I clean up tablespace?

If the datafile name must remain the same do the following:

1. Create a new tablespace.
2. Move the segments to the new tablespace.
3. Resize the original datafile.
4. Move the segments back to the original tablespace.
5. Drop the new tablespace.

How big is the table space in SYSAUX?

Section 1 of the report discusses the sysaux tablespace components. The total sysaux tablespace size is shown. Part 1a shows the breakdown by schema owner. Not surprisingly, the sys user accounts for the majority of the space utilization in that tablespace. These days, it seems it is too common for the sysaux tablespace to grow very large.

Who are the registered occupants of the SYSAUX tablespace?

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 SYSAUX tablespace. You can monitor the occupants of the SYSAUX tablespace using the V$SYSAUX_OCCUPANTS view.

What does SYSAUX tablespace do in Oracle 11g?

The SYSAUX tablespace in Oracle Database 11g is an auxiliary tablespace to the SYSTEM tablespace. As an auxiliary tablespace, the SYSAUX tablespace is intended for storing LOB (large object) data such as graphics and videos, as well as information that is rarely accessed and thus better suited for this “secondary storage.”

How does the move procedure work in SYSAUX?

The move procedure also lets you move a component from another tablespace into the SYSAUX tablespace. The SYSAUX tablespace is occupied by a number of database components (see Table 2-3 ), and its total size is governed by the space consumed by those components.