Query to find the OPP Actual and Target Process
Query:
SELECT b.user_concurrent_queue_name "Concurrent Manager", b.target_node "Node", a.running_processes "Actual Processes", a.max_processes "Target Processes"
FROM apps.fnd_concurrent_queues a, apps.fnd_concurrent_queues_vl b
WHERE a.concurrent_queue_id = b.concurrent_queue_id
AND a.concurrent_queue_name = 'FNDCPOPP' ;
Post a Comment
Post a Comment