22 May 2011

How To Find Out On Which Instance FNDSM Is Currently Running

How To Find Out On Which Instance FNDSM Is Currently Running?

Execute below Query :-

SELECT concurrent_queue_name, p.node_name, db_instance
  FROM fnd_concurrent_processes p, fnd_concurrent_queues q, fnd_cp_services s
 WHERE     p.queue_application_id = q.application_id
       AND p.concurrent_queue_id = q.concurrent_queue_id
       AND q.manager_type = s.service_id
       AND p.process_status_code = 'A';

Output:-

CONCURRENT_QUEUE_NAME NODE_NAME DB_INSTANCE
INVTMRPM LITHIUM UAT
INVTMRPM LITHIUM UAT
FNDSM_LITHIUM LITHIUM UAT
FNDICM LITHIUM UAT
INVTMRPM LITHIUM UAT
XDP_APPL_SVC LITHIUM
WFWSSVC LITHIUM
FNDCPOPP LITHIUM
WFALSNRSVC LITHIUM
WFMLRSVC LITHIUM
XDP_CTRL_SVC LITHIUM
XDP_Q_ORDER_SVC LITHIUM
XDP_Q_FA_SVC LITHIUM
XDP_Q_FE_READY_SVC LITHIUM
XDP_Q_EVENT_SVC LITHIUM
XDP_Q_IN_MSG_SVC LITHIUM
XDP_Q_TIMER_SVC LITHIUM
XDP_SMIT_SVC LITHIUM
FNDOPP10999 LITHIUM
FNDCRM LITHIUM UAT
XDP_MANAGER LITHIUM UAT
STANDARD2 LITHIUM UAT
STANDARD2 LITHIUM UAT
STANDARD2 LITHIUM UAT
STANDARD LITHIUM UAT
STANDARD LITHIUM UAT
STANDARD LITHIUM UAT
STANDARD LITHIUM UAT
STANDARD LITHIUM UAT
STANDARD LITHIUM UAT
REPORTS_lithium_7015 LITHIUM
XDP_Q_WI_SVC LITHIUM

No comments: