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') /
Friday, September 6, 2013
Concurrent Manager Status using SQL
The below query show all the concurrent managers status using SQL instead of logging front-end.
NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL
Error: adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress. INST_TOP/adm...
-
I got a task to estimate RMAN backup size. How much 3days RMAN backup occupy? How long it will take to complete? Is the backup siz...
-
I got the below issue while Cloning ORACLE HOME from source to target. I have copied the binaries from source and initiated adcfclone. It ...
-
We have received an alert in the morning that the Primary Database is out of Sync. Primary and Standby are with difference of 9 archives. ...