Saturday, September 20, 2008

Seesion Information of a Concurrent Request

This query can give you sid and serial# that can be used to kill a concurrent request.

SELECT fcr.concurrent_program_id
, fcr.oracle_process_id
, fcr.oracle_session_id
, fcr.os_process_id
, vs.sid
, vs.serial#
FROM apps.fnd_concurrent_requests fcr
, v$process vp
, v$session vs
WHERE fcr.request_id= 44479533
AND fcr.oracle_process_id = vp.spid
AND vs.paddr = vp.addr

No comments:

Post a Comment