Saturday, June 6, 2009

List the session details for a particular request

select r.request_id,
r.oracle_process_id spid,
r.oracle_session_id,s.inst_id,
r.os_process_id process,
s.sid,
s.serial#,
s.status,to_char(logon_time,'YYYYMMDD HH24:MI:SS') time,s.program,s.sql_address,
s.paddr
from apps.fnd_concurrent_requests r,
gv$session s
where r.request_id =31082866
and r.oracle_session_id = s.audsid(+);


select request_id,oracle_process_id,phase_code,status_code from
apps.fnd_concurrent_requests where status_code='R'
where request_id in(13477786,13477936,13477799);

No comments:

Post a Comment