add

About Me

My photo
Oracle Apps - Techno Functional consultant

Tuesday, August 2

SQL Query to list running concurrent requests

SELECT sess.sid,
sess.serial#,
oracle_process_id OS_PROCESS_ID,
fusr.description user_name,
fcp.user_concurrent_program_name progName,
TO_CHAR (actual_Start_date, 'DD-MON-YYYY HH24:MI:SS') StartDate,
request_id RequestId,
(SYSDATE - actual_start_date) * 24 * 60 * 60 ETime
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs_tl fcp,
fnd_user fusr,
v$session sess
WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
AND fcr.program_application_id = fcp.application_id
AND fcp.language = 'US'
AND fcr.phase_code = 'R'
AND fcr.status_code = 'R'
AND fcr.requested_by = fusr.user_id
AND fcr.oracle_session_id = sess.audsid(+)
ORDER BY 5 DESC

No comments: