This procedure removes logically deleted rows based on the value of the KeepInterval setting. Records in the database can be marked as deleted (logically deleted) by setting the DELETE_SESSION_ID column to a non-null value. By default, records that were deleted more than 5 days ago will be deleted by this procedure.
Notes:
- The CLEANUP_LOGICAL_DELETES procedure will not delete records whose DELETE_SESSION_ID column is set to a negative value.
- This procedure will not delete records older than the earliest user session in USESSION, as determined by the minimum value in the login_date column.
Refer to the following table for information about the settings associated with the CLEANUP_LOGICAL_DELETES procedure:
CLEANUP_LOGICAL_DELETES Settings
Setting Description: The oldest logically deleted records to keep in tables. | |
---|---|
Namespace | database.cleanup.LogicalDelete |
Setting Name | KeepInterval |
Default Setting | 5d |
Type | Interval |
Setting Description: Determines whether the procedure will delete all of the logically deleted records possible on each pass. | |
Namespace | database.cleanup.LogicalDelete |
Setting Name | DeleteAll |
Default Setting | 0 (false) |
Type | Boolean |
Setting Description: Maximum rows to delete on each pass. | |
Namespace | database.cleanup.LogicalDelete |
Setting Name | MaxRowsToDelete |
Default Setting | 10,000 |
Type | Numeric |