Query to find the Concurrent manager Status

on
Run the below query to find Concurrent managers which is currently running: 
set pages 1000
set linesize 180
col "User_Concurrent_Queue_Name" format a50 heading 'Manager'
col "Running_Processes" for 9999 heading 'Target_Running'
col TARGET_NODE for a20
col "MAX_Processes" for 9999 heading 'Actual_Running'
SELECT user_concurrent_queue_name,
       target_node,
       max_processes,
       running_processes
FROM   fnd_concurrent_queues_vl
WHERE  running_processes = max_processes
       AND running_processes > 0;
Run the below query to find Concurrent managers which is currently not running: 
set pages 1000
set linesize 180
col "User_Concurrent_Queue_Name" format a50 heading 'Manager'
col "Running_Processes" for 9999 heading 'Target_Running'
col TARGET_NODE for a20
col "MAX_Processes" for 9999 heading 'Actual_Running'
SELECT user_concurrent_queue_name,
       target_node,
       max_processes,
       running_processes
FROM   fnd_concurrent_queues_vl
WHERE  running_processes = max_processes
       AND running_processes = 0;
Run the below query to find All the concurrent managers: 

set pages 1000
set linesize 180
col "User_Concurrent_Queue_Name" format a50 heading 'Manager'
col "Running_Processes" for 9999 heading 'Target_Running'
col TARGET_NODE for a20
col "MAX_Processes" for 9999 heading 'Actual_Running'
SELECT user_concurrent_queue_name,
       target_node,
       max_processes,
       running_processes
FROM   fnd_concurrent_queues_vl
WHERE  running_processes = max_processes;
Sample Output: 

Manager                         TARGET_NODE    Actual_Running Target_Running
------------------------------- -------------- -------------- --------------
Standard Manager                ORCLDBADEV01         40             40
Internal Manager                ORCLDBADEV01          1              1
Conflict Resolution Manager     ORCLDBADEV01          1              1
Scheduler/Prereleaser Manager   ORCLDBADEV01          1              1

Comments

Post a Comment