trouble with query in our database

[neosss]

out DB is Oracle 11g

we see 1 trouble query

SELECT *
  FROM (SELECT a.*, ROWNUM rnum
          FROM (SELECT RES.*
                  FROM ACT_RU_JOB RES
                 WHERE     (RETRIES_ > 0)
                       AND (DUEDATE_ IS NULL OR DUEDATE_ < :1)
                       AND (LOCK_OWNER_ IS NULL OR LOCK_EXP_TIME_ < :2)
                       AND (EXCLUSIVE_ = 1)
                       AND (PROCESS_INSTANCE_ID_ = :3)) a
         WHERE ROWNUM < :4)
WHERE rnum >= :5

it runs very slow.

how it fix?

[trademak]

Which version of Activiti are you using? With Activiti 5.17 we introduced a new async job executor which improves the job queries a lot.

Best regards,

[neosss]

we use 5.14 version of Activity.

ok. we'll try 5.17

thanks