Description
|
Concurrent
Manager Status using SQL
|
Date
|
9/27/2013
|
Category
|
Concurrent Manager
|
Detailed Description
|
The below query is used to get all the concurrent
manager status from back end. Most of the times we need to quickly check the
status of the CM.
|
Concurrent
Manager Status using SQL
|
select decode(CONCURRENT_QUEUE_NAME,
'FNDICM','Internal Manager',
'FNDCRM','Conflict Resolution Manager',
'AMSDMIN','Marketing Data Mining Manager',
'C_AQCT_SVC','C AQCART Service',
'FFTM','FastFormula Transaction Manager',
'FNDCPOPP','Output Post Processor',
'FNDSCH','Scheduler/Prereleaser Manager',
'FNDSM_AQHERP','Service Manager: AQHERP',
'FTE_TXN_MANAGER','Transportation Manager',
'IEU_SH_CS','Session History Cleanup',
'IEU_WL_CS',
'UWQ Worklist Items Release for Crashed session',
'INVMGR','Inventory Manager','
INVTMRPM','INV Remote Procedure Manager','OAMCOLMGR',
'OAM Metrics Collection Manager',
'PASMGR','PA Streamline Manager',
'PODAMGR','PO Document Approval Manager',
'RCVOLTM','Receiving Transaction Manager',
'STANDARD','Standard Manager',
'WFALSNRSVC','Workflow Agent Listener Service',
'WFMLRSVC','Workflow Mailer Service','WFWSSVC',
'Workflow Document Web Services Service',
'WMSTAMGR','WMS Task Archiving Manager',
'XDP_APPL_SVC','SFM Application Monitoring Service',
'XDP_CTRL_SVC',
'SFM Controller Service',
'XDP_Q_EVENT_SVC','SFM Event Manager Queue Service',
'XDP_Q_FA_SVC','SFM Fulfillment Actions Queue Service',
'XDP_Q_FE_READY_SVC','SFM Fulfillment Element Ready Queue Service',
'XDP_Q_IN_MSG_SVC','SFM Inbound Messages Queue Service',
'XDP_Q_ORDER_SVC',
'SFM Order Queue Service',
'XDP_Q_TIMER_SVC','SFM Timer Queue Service',
'XDP_Q_WI_SVC','SFM Work Item Queue Service',
'XDP_SMIT_SVC','SFM SM Interface Test Service') as "Concurrent Manager's Name",
max_processes as "TARGET Processes",
running_processes as "ACTUAL Processes"
from apps.fnd_concurrent_queues
where CONCURRENT_QUEUE_NAME
in ('FNDICM','FNDCRM','AMSDMIN','C_AQCT_SVC','FFTM','FNDCPOPP','FNDSCH','FNDSM_AQHERP','FTE_TXN_MANAGER','IEU_SH_CS','IEU_WL_CS','INVMGR','INVTMRPM',
'OAMCOLMGR','PASMGR','PODAMGR','RCVOLTM','STANDARD','WFALSNRSVC','WFMLRSVC','WFWSSVC','WMSTAMGR','XDP_APPL_SVC','XDP_CTRL_SVC','XDP_Q_EVENT_SVC',
'XDP_Q_FA_SVC','XDP_Q_FE_READY_SVC','XDP_Q_IN_MSG_SVC','XDP_Q_ORDER_SVC','XDP_Q_TIMER_SVC','XDP_Q_WI_SVC','XDP_SMIT_SVC')
order by max_processes
/
Execution
and Sample Output
|
Concurrent Manager's Name TARGET Processes ACTUAL Processes
---------------------------------------------- ---------------- ----------------
SFM Timer Queue Service 0 0
Marketing Data Mining Manager 0 0
SFM Event Manager Queue Service 0 0
SFM Fulfillment Element Ready Queue Service 0 0
SFM Fulfillment Actions Queue Service 0 0
SFM Work Item Queue Service 0 0
SFM Order Queue Service 0 0
SFM Controller Service 0 0
SFM SM Interface Test Service 0 0
SFM Application Monitoring Service 0 0
FastFormula Transaction Manager 0 0
Concurrent Manager's Name TARGET Processes ACTUAL Processes
---------------------------------------------- ---------------- ----------------
Transportation Manager 0 0
WMS Task Archiving Manager 0 0
C AQCART Service 0 0
SFM Inbound Messages Queue Service 0 0
UWQ Worklist Items Release for Crashed session 1 1
Session History Cleanup 1 1
Workflow Mailer Service 1 1
Workflow Agent Listener Service 1 1
1 1
Inventory Manager 1 1
PA Streamline Manager 1 1
Concurrent Manager's Name TARGET Processes ACTUAL Processes
---------------------------------------------- ---------------- ----------------
Scheduler/Prereleaser Manager 1 1
Conflict Resolution Manager 1 1
Internal Manager 1 1
Workflow Document Web Services Service 1 1
OAM Metrics Collection Manager 1 1
PO Document Approval Manager 2 2
Receiving Transaction Manager 3 3
Output Post Processor 10 10
Standard Manager 100 100
31 rows selected.
