Query to find Actual Processes and Target Processes and Status of Concurrent Manager

Query To Check Concurrent Managers Status 

How to check Concurrent Manager Status 

 In oracle apps dba job below query will be helpful to work for oracle concurrent manager.

By using this query you can find status of concurrent manager, Actual Processes and Target Processes etc.

So, as oracle apps dba you can use below query. 

 

SELECT fcqv.user_concurrent_queue_name "Concurrent Manager",
         fcq.TARGET_NODE "Node",
         fcq.running_processes "ACTUAL Processes",
         fcq.max_processes "TARGET Processes",
         DECODE (fcqv.control_code,
                 'D', 'Deactivating',
                    'E', 'Deactivated',
                         'N', 'Node unavai',
                              'A', 'Activating',
                                  'X', 'Terminated',
                                      'T', 'Terminating',
                                            'V', 'Verifying',
                                     'O', 'Suspending',
                              'P', 'Suspended',
                     'Q', 'Resuming',
                 'R', 'Restarting')
            status
    FROM apps.fnd_concurrent_queues fcq, apps.fnd_concurrent_queues_vl fcqv
   WHERE fcq.concurrent_queue_id = fcqv.concurrent_queue_id
         AND fcq.running_processes = fcq.max_processes
ORDER BY fcq.max_processes DESC;

 

  You can find me on Fiverr & LinkedIn