The number of entries in MQOWP keeps growing after a restart of the Automation Engine and reaches above 1 million or more.
A rebuild of the indexes or reorganization of the MQ tables does not lead to improvement.
Procedure to determine if you suffer from this issue:
1. In the WP logs:
- Find the WP with role O (OWP)
The problem is likely on the database side.
First, rebuild the indexes of the MQ1OWP or MQ2OWP, depending on which one is active. (Or just in case rebuild indexes for both.)
Since all used fields are indexed, this should speed up the query significantly.
If the OWP does not go down (fast enough), ask you DBA to investigate and optimize the so-called 'execution plan' of the following statement:
SELECT * FROM (SELECT * FROM MQ1OWP WHERE MQOWP_SchedTime<=:A0001 ORDER BY MQOWP_Priority, MQOWP_SchedTime, MQOWP_PK) WHERE rownum <= ?
Once the statement is optimized the issue should go away quickly.