This procedure deletes records from the REFRDEL table based on the value of the KeepInterval setting. The default setting keeps the REFRDEL records from the last five days.
Refer to the following table for information about the settings associated with the REFRDEL_CLEANUP procedure:
REFRDEL_CLEANUP Settings
Setting Description: The oldest records to keep in the REFRDEL table. | ||
Namespace | database.cleanup.Refrdel | |
Setting Name | KeepInterval | |
Default Setting | 5d | |
Type | Interval | |
Setting Description: Identifies the maximum number of minutes before records are deleted from the REFRDEL table. | ||
Namespace | database.cleanup.Refrdel | |
Setting Name | DaysToDelete | |
Default Setting | 1 | |
Type | Numeric | |
Setting Description: Determines the number of minutes for each step interval. | ||
Namespace | database.cleanup.Refrdel | |
Setting Name | IntervalStep | |
Default Setting | 15 | |
Type | Numeric | |
Setting Description: Identifies the maximum number of rows to delete on each run. | ||
Namespace | database.cleanup.Refrdel | |
Setting Name | MaxRowsToDelete | |
Default Setting | 10,000 | |
Type | Numeric | |
Setting Description: Identifies the percentage of rows to delete per run. | ||
Namespace | database.cleanup.Refrdel | |
Setting Name | DeletePercentage | |
Default Setting | 10 (%) | |
Type | Numeric | |
Setting Description: Determines whether the procedure will delete all of the logically deleted records possible on each pass. | ||
Namesapce | database.cleanup.Refrdel | |
Setting Name | DeleteAll | |
Default Setting | 0 (false) | |
Type | Boolean | |
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, March 28, 2014
