Tag Archives: SQL to check the AQ setup and Workflow Agent Listener/WF Java Deferred Agent Listeners are running

SQL to check the AQ setup and Workflow Agent Listener/WF Java Deferred Agent Listeners are running

SQL to check the AQ setup and Workflow Agent Listener/WF Java Deferred Agent Listeners are running set echo on set timing on set feedback on set pagesize 132 set linesize 100 col name form a30 col queue_table form a30 col enqueue_enabled form a7 col dequeue_enabled form a7 col retention form a20 — select name, queue_table, enqueue_enabled, dequeue_enabled, retention from dba_queues where owner = ‘APPLSYS’ and … Continue reading SQL to check the AQ setup and Workflow Agent Listener/WF Java Deferred Agent Listeners are running »