My Oracle Support Banner

New Feature DBMS_AUDIT_MGMT To Manage And Purge Audit Information (Doc ID 731908.1)

Last updated on MAY 13, 2024

Applies to:

Oracle Audit Vault - Version 10.2.3 to 10.2.3
Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.1.0.6 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Purpose

This document briefly introduces the new DBMS_AUDIT_MGMT package that is used by Audit Vault to manage and purge audit data. It is intended to provide references to the relevant patches and documentation.

Scope

Update: this document is no longer actively maintained since version 10.2 now entered the Extended support period, all current versions in Premier Support have the dbms_audit_mgmt package natively.

The requirement for the introduction of this package came from Audit Vault. Its features include the purge of audit records and can be used to move the audit tables AUD$ and FGA_LOG$ to another tablespace. It can also be used to purge OS audit files including XML files. The Audit Trail Cleanup functionality was made available with patchsets 10.2.0.5 and 11.1.0.7,  this means 10.2.0.5 and 11.1.0.7 databases do not need additional patches to become a source of an Audit Vault. The package is documented in the Audit Vault 10.2.3 Admin Guide and for all the versions older than 11.2.0.1 it is supported to be used ONLY when the database is a source for Audit Vault. As of Oracle RDBMS 11.2.0.1 the package can be used by anyone regardless of whether Audit Vault is being used or not. Oracle will not be supporting the DBMS_AUDIT_MGMT in versions 9.2.0.x or 10.1.0.x

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.