BPM 12c purge job is taking longer than expected to complete

(Doc ID 2219575.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Business Process Management Suite - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Goal

The autopurge job takes a lot of time to finish, even with few instances to purge.

It Seems the script spends a lot of time in the following task:

DELETE FROM BPM_AUDIT_QUERY WHERE COMPONENT_INSTANCE_ID IN (SELECT TPIC.CIKEY FROM TEMP_CUBE_INSTANCE TPIC)


This was identified after running the scripts from Doc ID 1563449.1
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms