Purge scripts running very slowly due to queries against the BPM_AUDIT_QUERY table
(Doc ID 2579516.1)
Last updated on JUNE 06, 2022
Applies to:Oracle Business Process Management Suite - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
The purge scripts may take 3-4 hours to delete a single instance when there are millions of rows in the BPM_AUDIT_QUERY table. After gathering an AWR report on the database the longest running queries noticed use the FLOW_ID column in the where clause:
DELETE FROM BPM_AUDIT_QUERY WHERE FLOW_ID = :B1
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document