Oracle E-Business Suite: Concurrent Requests Performance History - Concurrent Request'lerle ilgili İstatistik Performans Bilgisi

Query About Performance Statistics of Concurrent Requests:

This query gives us the count of  daily run concurrents. In addition to that their daily running duration, average running hours and pending hours are also shown. That's how we could diagnose if there had been wrong with the system. In case there was a problem, we could easily detect and investigate the problem on that day or period.

 SELECT TO_CHAR(TRUNC(ACTUAL_START_DATE),'DD-MON-YY DY') STARTDATE,  
 COUNT(*) COUNT, ROUND(SUM(ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE) * 24, 2) RUNNING_HOURS,  
 ROUND(AVG(ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE) * 24, 2) AVG_RUNNING_HOURS,  
 ROUND(SUM(ACTUAL_START_DATE - REQUESTED_START_DATE) * 24, 2) PENDING_HOURS,  
 ROUND(AVG(ACTUAL_START_DATE - REQUESTED_START_DATE) * 24, 2) AVG_PENDING_HOURS  
 FROM APPLSYS.FND_CONCURRENT_PROGRAMS P,APPLSYS.FND_CONCURRENT_REQUESTS R  
 WHERE R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID  
 AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID  
 AND R.STATUS_CODE IN ('C','G')  
 AND TRUNC(ACTUAL_COMPLETION_DATE) > TRUNC(SYSDATE-6)  
 AND TO_CHAR(TRUNC(ACTUAL_START_DATE),'DD-MON-YY DY') IS NOT NULL  
 GROUP BY TRUNC(ACTUAL_START_DATE)   
 ORDER BY TRUNC(ACTUAL_START_DATE) ASC;

Reference:

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