Query to see workflow queues status

select
OWNER, NAME, ENQUEUE_ENABLED, DEQUEUE_ENABLED
from
DBA_QUEUES
where
NAME like 'WF%';

OWNER NAME ENQUEUE DEQUEUE
------------------------------ ------------------------------ ------- -------
APPLSYS WF_WS_JMS_IN YES YES
APPLSYS WF_INBOUND_QUEUE YES YES
APPLSYS WF_OUTBOUND_QUEUE YES YES
APPLSYS WF_IN YES YES
APPLSYS WF_DEFERRED_QUEUE_M YES YES
APPLSYS WF_SMTP_O_1_QUEUE YES YES
APPLSYS WF_ERROR YES YES
APPLSYS WF_OUT YES YES
APPLSYS WF_DEFERRED YES YES
APPLSYS WF_REPLAY_IN YES YES
APPLSYS WF_REPLAY_OUT YES YES
APPLSYS WF_JMS_IN YES YES
APPLSYS WF_JMS_OUT YES YES
APPLSYS WF_CONTROL YES YES
APPLSYS WF_NOTIFICATION_IN YES YES
APPLSYS WF_JAVA_DEFERRED YES YES
APPLSYS WF_JAVA_ERROR YES YES
APPLSYS WF_NOTIFICATION_OUT YES YES
APPLSYS WF_WS_JMS_OUT YES YES
APPLSYS WF_JMS_JMS_OUT YES YES
APPLSYS WF_WS_SAMPLE YES YES

21 rows selected.