Thursday, September 11, 2014

Script to Get Concurrent Manager and Programs Associated with It



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;

No comments:

Post a Comment