OO execution queues and its impact.
OO_EXECUTION_QUEUES is having some records with Assigned_Worker=EMPTY - is this an expected behavior? Also what is the meaning of STATUS codes in the table?
Where Assigned_Worker column is having the central worker id, those are having 300+ records as assigned. When I execute to identify for stale records with below queries on our central worker, mostly the count is 0 or some count appears for a while and when re-executed it goes 0 again. Below are the queries
SELECT COUNT(*) FROM OO_EXECUTION_QUEUES q WHERE q.ASSIGNED_WORKER = 'CENTRAL SERVER 1' AND q.STATUS = 4 AND (NOT EXISTS (SELECT qq.MSG_SEQ_ID FROM OO_EXECUTION_QUEUES qq WHERE (qq.EXEC_STATE_ID = q.EXEC_STATE_ID) AND qq.MSG_SEQ_ID > q.MSG_SEQ_ID ))