If the auditing feature is enabled, this procedure will physically delete records from the table based on the value of the KeepInterval setting.
Refer to the following table for information about the settings associated with the PAUDIT_CLEANUP procedure:
Setting Description: Should the procedure attempt PAUDIT records cleanup. | |
Namespace | database.cleanup.auditing |
Setting Name | Enabled |
Default Setting | 1 (true) |
Type | Boolean |
Setting Description: The oldest audit records to keep in PAUDIT. | |
Namespace | database.cleanup.auditing |
Setting Name | KeepInterval |
Default Setting | 30d |
Type | Interval |
DAMON (Data Monitor) Procedures
USESSION_CLEAR_LOGICAL_DELETES Procedure
CLEANUP_LOGICAL_DELETES Procedure
USER_DEFINED_BACKGROUND Procedure
Legal Notices
Copyright © 1999, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, September 30, 2016