My Oracle Support Banner

BPM 12c purge job is taking longer than expected to complete (Doc ID 2219575.1)

Last updated on MARCH 06, 2019

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 customer's database team has experienced performance issues when attempting to run the purge scripts.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)



 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.