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



Last updated on November 28th, 2015 at 12:45 pm

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 queue_type = ‘NORMAL_QUEUE’
order by 1
/

set pagesize 132
set linesize 90
col COMPONENT_NAME form a50
col COMPONENT_STATUS form a15
col COMPONENT_TYPE form a25
col STARTUP_MODE form a10
col CONTAINER_TYPE form a5
col INBOUND_AGENT_NAME form a20
col OUTBOUND_AGENT_NAME form a20
col CORRELATION_ID form a30
col MAX_IDLE_TIME form 9999999
rem
select
COMPONENT_NAME,
COMPONENT_STATUS,
COMPONENT_TYPE,
STARTUP_MODE,
CONTAINER_TYPE,
INBOUND_AGENT_NAME,
OUTBOUND_AGENT_NAME,
CORRELATION_ID,
MAX_IDLE_TIME
from FND_SVC_COMPONENTS
order by COMPONENT_NAME
/


Leave a Reply