Concurrent Manager and Program Frequently Using Queries
Long Running Query SELECT fcr.request_id,fcr.parent_request_id, ftp.user_concurrent_program_name , fcu.user_name,fcu.description User_Detail, fcr.phase_code phase, floor(((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60)/3600)|| ' Hrs ' || floor((((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60) - floor(((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60)/3600)*3600)/60)|| ' Mins ' || round((((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60) - floor(((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60)/3600)*3600 - (floor((((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60) - floor(((SYSDATE-FCR.ACTUAL_START_DATE)*24*60*60)/3600)*3600)/60)*60) ))|| ' Secs ' "RUNNING_SINCE", to_char(FCR.requested_start_date, ' DAY DD-MON-YY HH:MI AM') REQUESTED_START_DATE, to_char(FCR.actual_start_date, ' DAY DD-MON-YY HH:MI AM') ACTUAL_START_DATE , floor(((FCR.ACTUAL_START_DATE-FCR.request_date)*24*60*60)/3600)|| ' Hrs ' || floor((((FCR.ACTUAL_START_DATE-FCR.request