[Script]Check status of all the Concurrent Managers

最新推荐文章于 2021-04-05 13:30:23 发布

最新推荐文章于 2021-04-05 13:30:23 发布 · 95 阅读

文章标签：

#数据库

本文介绍了一种Oracle Apps DBA通过SQL脚本监控并发管理器运行状态的方法，该脚本可以列出各个并发管理器的目标进程数与实际运行进程数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Oracle Apps DBA可以从System Administrator >> Concurrent : Manager >> Administer里查看所有Concurrent Manager运行的状态,其实如果仅仅是查看的话，也可以通过下边这个脚本来查看.

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');

Sample Output:

Concurrent Manager's Name                      TARGET Processes ACTUAL Processes
---------------------------------------------- ---------------- ----------------
Service Manager: AQHERP                         1                1
Output Post Processor                           1                1
Workflow Document Web Services Service          1                1
WMS Task Archiving Manager                      2                2
Marketing Data Mining Manager                   5                5
Conflict Resolution Manager                     1                1
Internal Manager                                1                1
Scheduler/Prereleaser Manager                   1                1
Standard Manager                               10               10
PO Document Approval Manager                    3                3
Receiving Transaction Manager                   3                3
FastFormula Transaction Manager                 1                1
PA Streamline Manager                           1                1
Inventory Manager                               5                5
INV Remote Procedure Manager                    5                5
Workflow Agent Listener Service                 1                1
Workflow Mailer Service                         1                1
Transportation Manager                          10               10
C AQCART Service                                1                1
Session History Cleanup                         1                1
UWQ Worklist Items Release for Crashed session  1                1
SFM Controller Service                          1                1
SFM Order Queue Service                         1                1
SFM Work Item Queue Service                     1                1
SFM Fulfillment Actions Queue Service           1                1
SFM Fulfillment Element Ready Queue Service     1                1
SFM Event Manager Queue Service                 1                1
SFM Inbound Messages Queue Service              1                1
SFM Timer Queue Service                         1                1
SFM Application Monitoring Service              1                1
SFM SM Interface Test Service                   1                1
OAM Metrics Collection Manager                  1                1

32 rows selected.