Purge Recent User Requests
Use the Purge Recent User Requests scheduled process to improve performance.
When to Use
Privileges Required
- Purge Orchestration Order Recent User Requests (DOO_PURGE_ORCHESTRATION_ORDER_RECENT_USER_REQUESTS_PRIV)
Specifications
Use these specifications when you run the scheduled process.
Specification | Description |
---|---|
Job Type | Scheduled or as needed. |
Frequency |
One time each day. If you have lots of users doing a lot of actions, you might need to run it more often. You can periodically use SQL to examine the DOO_ACTION_REQUESTS table. If you find that it frequently exceeds several thousand records, then consider running the scheduled process more than one time each day. |
Time of Day | Any time, but we recommend you run it when there's not a lot processing going on. For example, 2 AM. |
Duration | Depends on how many requests there are in the DOO_ACTION_REQUESTS table. |
Compatibility | We recommend that you run only one instance of this scheduled process at a time. |