SELECT FCQ.USER_CONCURRENT_QUEUE_NAME MANAGER_NAME,
FA.APPLICATION_NAME,
FCQS.MIN_PROCESSES,
FCQS.MAX_PROCESSES,
FCQS.SLEEP_SECONDS,
FCP.USER_CONCURRENT_PROGRAM_NAME CONCURRENT_PROGRAM_NAME,
DECODE(FCQC.INCLUDE_FLAG,'E','Exclude','I','Include',' ') "Include/Exclude"
FROM APPS.FND_CONCURRENT_QUEUES_VL FCQ,
APPS.FND_CONCURRENT_QUEUE_SIZE fcqs,
APPS.FND_CONCURRENT_QUEUE_CONTENT FCQC,
APPS.FND_CONCURRENT_PROGRAMS_VL FCP,
APPS.FND_APPLICATION_VL fa
WHERE 1=1
AND FCQ.CONCURRENT_QUEUE_ID =FCQC.CONCURRENT_QUEUE_ID
AND FCQS.CONCURRENT_QUEUE_ID =FCQC.CONCURRENT_QUEUE_ID
AND FA.APPLICATION_ID =Fcq.APPLICATION_ID
AND FCQC.TYPE_ID =FCP.CONCURRENT_PROGRAM_ID(+)
ORDER BY 1;
Thursday, September 11, 2014
Script to Get Concurrent Manager and Programs Associated with It
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment