Way to success...

--"Running Away From Any PROBLEM Only Increases The DISTANCE From The SOLUTION"--.....--"Your Thoughts Create Your FUTURE"--.....--"EXCELLENCE is not ACT but a HABIT"--.....--"EXPECT nothing and APPRECIATE everything"--.....

Tuesday, December 22, 2015

Query to check status of Concurrent managers from backend database




SELECT   t.user_concurrent_queue_name AS "Concurrent Manager Name", 
         b.max_processes AS "Actual Processes", 
         b.running_processes AS "Target Processes", 
         b.concurrent_queue_name, b.cache_size,
         b.min_processes, b.target_processes, b.target_node, b.sleep_seconds, 
         b.diagnostic_level, b.manager_type, b.enabled_flag, t.description
    FROM fnd_concurrent_queues_tl t, fnd_concurrent_queues b
   WHERE b.application_id = t.application_id 
    AND b.concurrent_queue_id = t.concurrent_queue_id 
    AND b.enabled_flag = 'Y' 
    AND t.LANGUAGE = USERENV ('LANG')
ORDER BY b.max_processes DESC;

1 comment:

  1. Hi
    Please can you add the Running process here in the query so that it will be easy to find out how many are pending and in which manager.

    ReplyDelete