Parameter DEFAULT_CLEANUP_INTERVAL of DBMS_AUDIT_MGMT.INIT_CLEANUP procedure
(Doc ID 1243324.1)
Last updated on MAY 11, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.5.0 and later
Information in this document applies to any platform.
The DBMS_AUDIT_MGMT package is included in the 10.2.0.5 (and higher) and 22.214.171.124 (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.
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