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

  • September 29, 2016 | 13 views
  • Comments