Hi Team,
We have Camunda 7 and have a Openshift cluster with 8 replica pods for Camunda Process Engine. We are doing load test, and after 1 hour or so our Oracle DB is getting high CPU usage and resource utilization. The below query is pointed out by DBA which is long running and causing slowness, This query keeps on running for longer duration. Can you guys suggest some tuning?
update ACT_RU_JOB
SET REV_ = :1 ,
LOCK_EXP_TIME_ = :2 ,
LOCK_OWNER_ = :3 ,
DUEDATE_ = :4 ,
PROCESS_INSTANCE_ID_ = :5 ,
EXCLUSIVE_ = :6
where ID_= :7
and REV_ = :8