ora-technology

SQL script Long Running Requests set lines 130 column start_time format a15 column USER_CONCURRENT_PROGRAM_NAME format a40 select b.REQUEST_ID, a.USER_CONCURRENT_PROGRAM_NAME, b.phase_code, (sysdate - b.actual_start_date) * 24 "running", to_char(b.request_date, 'mm/dd/yyyy hh24:mi') "request_date", to_char(b.actual_start_date, 'mm/dd/yyyy hh24:mi') "start_time" from APPS.FND_CONCURRENT_PROGRAMS_VL a, APPS.FND_CONCURRENT_REQUESTS b where a.CONCURRENT_PROGRAM_ID = b.CONCURRENT_PROGRAM_ID and a.APPLICATION_ID = b.PROGRAM_APPLICATION_ID and b.STATUS_CODE = 'R' and b.PHASE_CODE = 'R' and ((sysdate - b.actual_start_date) * 24) > 4 and a.CONCURRENT_PROGRAM_ID NOT IN(36887,43393,38121,42789,31556);