This procedure deletes records from the PC_KEY_XREF and PC_PROCESS_STAT tables based on the KeepInterval parameter setting. The following table describes the settings associated with the CLEANUP_PCKEYXREF procedure.
CLEANUP_PCKEYXREF SETTINGS
Setting Description: The oldest records to keep in the PC_KEY_XREF and PC_PROCESS_STAT tables. Default is five days.
Namespace | database.cleanup.pckeyxref |
|---|---|
Setting Name | KeepInterval |
Default Setting | 5d |
Type | Interval |
Setting Description: Determines the maximum rows to delete after satisfying the KeepInterval parameter setting. Default is 10000 rows.
Namespace | database.cleanup.pckeyxref |
|---|---|
Setting Name | MaxRowsToDelete |
Default Setting | 100000 |
Type | Numeric |
Setting Description: Determines the commit interval of deleted records. Default is to issue a commit every 10000 rows.
Namespace | database.cleanup.pckeyxref |
|---|---|
Setting Name | DeleteBatchSize |
Default Setting | 10000 |
Type | Numeric |