Monitoring and Adding Server Tablespace Space Usage

You can monitor and add server table space usage in Oracle Audit Vault Server.

Oracle Audit Vault Server contains the following tablespaces:

• SYSTEM

• SYSAUX

• TEMP

• USERS

• UNDOTBS1

By default, these tablespaces have one datafile.The tablespaces are locally managed with automatic segment space management.

You should monitor the space usage for the tablespace and create additional data files for storage as needed.

The Oracle Database Security Central console will monitor the space remaining in the SYSTEM, SYSAUX, and TEMP tablespaces. You will receive system alerts when the remaining space is low and additional datafiles need to be added.

To add a datafile to any of the above tablespaces:

1. Log in to the Audit Vault Server through SSH and switch to the root user.

   See Logging In to Oracle DBSecCentral Appliances Through SSH.

2. Switch to the oracle user.

   su - oracle

3. Connect as a super administrator user.

   sqlplus <superadmin>/<superadmin_password>

4. Run the following to add a 100MB datafile to the provided tablespace.

   execute avsys.datafile_management.add_datafile(<tablespace_name>);

Related Topics

• System Alerts

• Creating Data Files and Adding Data Files to a Tablespace

• Altering a SQL Profile

  See Also:

  • System Alerts for more information on how to receive notifications when tablespace is low in the Audit Vault Server.

  • Creating Data Files and Adding Data Files to a Tablespace in the Oracle Database Administrator's Guide for more information about the ALTER TABLESPACE SQL statement, which you can use to add more storage data files.

  • Altering a SQL Profile in the Oracle Database SQL Tuning Guide for more information about optimizing a tablespace.