garden1.jpg

Concurrent programs running for one hour or longer


Long running Oracle Apps concurrent requests

– 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

Latest Blog Items

email

Thank you for your interest in idbasolutions.

Contact us using this email: contact.us@idbasolutions.com