Concurrent Managers activity
                                                 Last update (2011-03-05 15:37:31)
                                                                                                                   Date added (2008-02-18 13:44:03)

Summary
To check Concurrent Managers activity (Running managers)
SELECT * FROM 
(
SELECT   /*+ FIRST_ROWS */
fcqt.user_concurrent_queue_name, fcq.concurrent_queue_name, 
        fcq.target_node, fcq.running_processes actual, fcq.max_processes target, 
         DECODE (fcq.enabled_flag,'Y', 'Y','N', 'N',fcq.enabled_flag) ENABLED,
         SUM (DECODE (fcwr.phase_code, 'R', 1, 0)) running,
           SUM (DECODE (fcwr.phase_code, 'P', 1, 0))
         - SUM (DECODE (fcwr.hold_flag, 'Y', 1, 0))
         - SUM (DECODE (SIGN (fcwr.requested_start_date - SYSDATE), 1, 1, 0)) pending,
         SUM (DECODE (fcwr.hold_flag, 'Y', 1, 0)) hold,
         SUM (DECODE (SIGN (fcwr.requested_start_date - SYSDATE), 1, 1, 0)) sched,
         NVL (paused_jobs.paused_count, 0) paused, fcq.sleep_seconds, 
 fcq.application_id, fcq.concurrent_queue_id
    FROM apps.fnd_concurrent_worker_requests fcwr,
         applsys.fnd_concurrent_queues fcq,
         applsys.fnd_concurrent_queues_tl fcqt,
         (SELECT   fcp.concurrent_queue_id, COUNT (*) paused_count
              FROM applsys.fnd_concurrent_requests fcr, applsys.fnd_concurrent_processes fcp
             WHERE fcr.phase_code = 'R'
               AND fcr.status_code = 'W'                             -- Paused
               AND fcr.controlling_manager = fcp.concurrent_process_id
          GROUP BY fcp.concurrent_queue_id) paused_jobs
   WHERE fcwr.queue_application_id(+) = fcq.application_id
     AND fcwr.concurrent_queue_id(+) = fcq.concurrent_queue_id
     AND fcq.concurrent_queue_id = paused_jobs.concurrent_queue_id(+)
     AND fcq.application_id = fcqt.application_id
     AND fcq.concurrent_queue_id = fcqt.concurrent_queue_id
     AND fcqt.LANGUAGE = USERENV ('LANG')
     AND fcq.running_processes > 0
GROUP BY fcq.concurrent_queue_name, fcqt.user_concurrent_queue_name, fcq.application_id,
         fcq.concurrent_queue_id, fcq.target_node, fcq.max_processes, fcq.running_processes,
         fcq.sleep_seconds, fcq.cache_size,
         DECODE (fcq.enabled_flag,'Y', 'Y','N', 'N',fcq.enabled_flag),
         paused_jobs.paused_count
ORDER BY DECODE (fcq.enabled_flag,'Y', 'Y','N', 'N',fcq.enabled_flag) DESC,
         DECODE (fcq.concurrent_queue_name,'FNDICM', 'AAA','STANDARD', 'AAB','Your name', 'AAC',fcq.concurrent_queue_name)
) 
--WHERE user_concurrent_queue_name LIKE 'SFM%';
Reviews
Filters
Search