Listing long running concurrent programs.
– This displays concurrent programs running for one hour or longer within last 24 hours.
– Bobby A.
– 28-Mar-06
– long_running_con_prg.sql
Concurrent programs running for one hour or longer within last 24 hours
idbasolutions.com Apr 2008
set linesize 110
column PROGRAM format a37
column REQUESTOR format a15
select REQUEST_ID,REQUESTOR,
to_char(ACTUAL_START_DATE,’hh24:mi dd-mon-yy’) started,
to_char(ACTUAL_COMPLETION_DATE,’hh24:mi dd-mon-yy’) completed,
round((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*24) duration,
PROGRAM
from FND_CONC_REQ_SUMMARY_V,dual
where PHASE_CODE=’C’
and to_date(ACTUAL_COMPLETION_DATE) between to_date(sysdate-1) and to_date(SYSDATE)
and round((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*24) > 0
order by 5 desc
/