Purge Recent User Requests

Use the Purge Recent User Requests scheduled process to improve performance.

When to Use

See Delete Records That Contain Data About Actions.

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.

Parameters

See Delete Records That Contain Data About Actions.