Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Tuesday, August 2, 2011

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:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect