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:
PAUDIT_CLEANUP Settings
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 |