Contents
What Sysaux tablespace contains?
SYSAUX tablespace. 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.
How do I extend my SYSTEM tablespace?
and we said…
- alter tablespace table_space_name add datafile ‘/path/to/some/file. dbf’ size Xm; that will add a new file to the existing tablespace.
- alter database datafile ‘/path/to/some/existing/file. dbf’ resize Xm;
- alter database datafile ‘/path/to/some/existing/file. dbf’ autoextend on next Xm maxsize Ym;
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.
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 to create SYSAUX tablespace in create database?
With just one CREATE DATABASE command we can specify the SYSTEM tablespace, the TEMPORARY tablespace, the SYSAUX tablespace, the default UNDO tablespace, and the redo logs.
Is the SYSAUX tablespace stable in RDBMS?
Normally the SYSAUX tablespace is more or less stable so it would be smart to check what is eating the space in there. Connected as a DBA user, run the script $ {ORACLE_HOME}/rdbms/admin/utlsyxsz to get the current usage of the SYSAUX tablespace and see how it will grow when you change certain parameters for which you are asked to enter values.