Oracle Alert: 監控常用 Concurrent Managers
監控 Oracle ERP 系統常用 Concurrent Managers 是否正常運作
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | SELECT fcq.concurrent_queue_name, fcq.user_concurrent_queue_name, --fcq.target_node, fcq.max_processes, fcq.running_processes, enabled_flag, TO_CHAR(SYSDATE, 'yyyy/mm/dd hh24:mi') send_time INTO &con_qname, &user_qname, &max_proc, &run_proc, &status, &send_time FROM fnd_concurrent_queues_vl fcq WHERE fcq.concurrent_queue_name IN ('FNDICM', 'FNDSM_ERPTEST', 'FNDSM_ERPPROD', 'INVMGR', 'RCVOLTM', 'STANDARD') AND (fcq.running_processes = 0 OR fcq.max_processes > fcq.running_processes+2 OR fcq.enabled_flag <> 'Y') |