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;
Hi
ReplyDeletePlease 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.