My Oracle Support Banner

Parameter DEFAULT_CLEANUP_INTERVAL of DBMS_AUDIT_MGMT.INIT_CLEANUP procedure (Doc ID 1243324.1)

Last updated on JUNE 10, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5.0 and later
Information in this document applies to any platform.

Goal


The DBMS_AUDIT_MGMT package is included in the 10.2.0.5 (and higher) and 11.1.0.7 (and higher) releases of the database software and with Audit Vault from 10.2.0.3. This package provides subprograms to manage and cleanup audit trail records for database audit trails, operating system (OS) audit trails, and XML audit trails.

The DBMS_AUDIT_MGMT.INIT_CLEANUP procedure is used to intialise and set up the audit management infrastructure and a default cleanup interval for the audit trail records.This procedure takes two input parameters :

a. audit_trail_type --> The audit trail type for which the clean up operation needs to be initialized.
b. default_cleanup_interval --> The default time interval, in hours, after which the cleanup procedure should be called. The minimum value is 1 and the maximum is 999.

However, after initialising the audit set up using the DBMS_AUDIT_MGMT.INIT_CLEANUP procedure and specifying the default_cleanup_interval parameter, the DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL procedure is not automatically called for cleanup operation as per the default_cleanup_interval parameter.

Solution

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
Goal
Solution
References

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