DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, September 29, 2016

Check the concurrent manager status from backend (database)

Check the concurrent manager status from backend (database) 



SELECT a.USER_CONCURRENT_QUEUE_NAME "  MANAGER_NAME" ,a.MAX_PROCESSES,a.RUNNING_PROCESSES,
sum(decode(b.PHASE_CODE,'R',decode(b.STATUS_CODE,'R',1,0),0)) Running_Normal,
sum(decode(b.PHASE_CODE,'P',decode(b.STATUS_CODE,'Q',1,0),0)) Pending_Standby,
sum(decode(b.PHASE_CODE,'P',decode(b.STATUS_CODE,'I',1,0),0)) Pending_Normal
FROM apps.FND_CONCURRENT_Q

No comments: