Introduction
By default, the DPA cleaning and purging process runs nightly from 10:00 PM to 3:59 AM. During this time, data is purged based on parameters outlined in the Knowledge Base article: DPA repository: Data retention policy.
To adjust the timing, you can modify three database instance-level options: CLEAN_START_HOUR and CLEAN_END_HOUR, as well as CLEAN_INTERVAL_DAYS. If you manage multiple instances, you'll need to access the Advanced Options section in the GUI for each instance to make these changes individually.
Script to Make Mass Changes
A simpler approach is to use the attached script to update the COND table in DPA. This example modifies the start and end hours to 8:00 PM and 10:00 PM for all instances. If you want to apply the changes to only a specific subset of instances, include a WHERE clause in the UPDATE statement.