Monday, February 25, 2013

Check Session For Specific Request in EBS

Sqlplus apps/apps


Select request_id,oracle_process_id,phase_code,status_code from
apps.fnd_concurrent_requests where status_code='R'
where request_id in(Request_ID #1,Request_ID #2,Request_ID #3);


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(+);

Thank you
Osama Mustafa

No comments:

Post a Comment