Concurrent Manager and Program Frequently Using Queries
Long Running Query Copy 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')