OO execution queues and its impact.

Hi,

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 ))

Satya