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 / PAUDITX 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 / PAUDITX.
Namespace | database.cleanup.auditing |
|---|---|
Setting Name | KeepInterval |
Default Setting | 30d |
Type | Interval |
Setting Description: Determines the minimum PAUDITX rows to delete after satisfying the KeepInterval parameter setting. This parameter is only applicable to an Oracle Database.
Namespace | database.cleanup.auditing |
|---|---|
Setting Name | PauditxDeleteAllThreshold |
Default Setting | 1,000,000 |
Type | Numeric |
Setting Description: Determines the maximum PAUDITX rows to delete after satisfying the KeepInterval parameter setting. This parameter is only applicable to an Oracle Database.
Namespace | database.cleanup.auditing |
|---|---|
Setting Name | PauditxMaxRowsToDelete |
Default Setting | 10,000,000 |
Type | Numeric |
Setting Description: Determines the percentage of PAUDITX rows to delete from PAUDITX, up to the maximum threshold, after satisfying the KeepInterval parameter setting. This parameter is only applicable to an Oracle Database.
Namespace | database.cleanup.auditing |
|---|---|
Setting Name | PauditxDeletePercentage |
Default Setting | 50 |
Type | Numeric |
Setting Description: Determines the commit interval of PAUDITX deleted records when the number of rows exceed value of PauditxDeleteAllThreshold parameter. This parameter is only applicable to an Oracle Database.
Namespace | database.cleanup.auditing |
|---|---|
Setting Name | PauditxBatchDelete |
Default Setting | 200,000 |
Type | Numeric |