Oracle E-Business Suite: Concurrent Programs Under Queue - Sırada Bekleyen İşlemler, Concurrentlar

Concurrent Programs Under Queue:

The query given below can show us the queries that are on hold, waiting to be executed. There could be a condition on the number of concurrents waiting and in the end if this number is too much, a mail can be sent to the administrator to check if something is wrong.

select user_CONCURRENT_PROGRAM_NAME "PROGRAM NAME",concurrent_queue_name "QUEUE NAME", priority,decode(phase_code,'P','Pending') "PHASE",   
 decode(status_code,'A','Waiting','B','Resuming','C','Normal','D','Cancelled','E','Error','F',  
 'Scheduled','G','Warning','H','On Hold','I','Normal','M','No Manager','Q','Standby','R','Normal','S',  
 'Suspended','T','Terminating','U','Disabled','W','Paused','X','Terminated','Z','Waiting') "   
 NAME", status_code,count(*) from   
 fnd_concurrent_worker_requests   
 where phase_code='P' and hold_flag!='Y'   
 and requested_start_date<=sysdate  
 and concurrent_queue_name<> 'FNDCRM'  
 and concurrent_queue_name<> 'GEMSPS'  
 group by   
 user_CONCURRENT_PROGRAM_NAME,  
 concurrent_queue_name,priority,phase_code,status_code  
 order by count(*) desc;  

Referans:

1- http://dbavandana.blogspot.com.tr/2013/06/concurrent-manager-queries.html