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')
--and t.user_concurrent_queue_name like 'Out%'
ORDER BY b.max_processes DESC;
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')
--and t.user_concurrent_queue_name like 'Out%'
ORDER BY b.max_processes DESC;
No comments:
Post a Comment