Query : 1
SELECT user_concurrent_program_name,
c.request_id,
s.sid,
p.spid,
s.process,
s.osuser,
s.username,
s.program,
s.status,
logon_time,
last_call_et
FROM v$session s,
v$process p,
apps.fnd_concurrent_requests c,
apps.fnd_concurrent_programs_tl ct
WHERE oracle_process_id=p.spid
AND s.paddr=p.addr
AND ct.concurrent_program_id=c.concurrent_program_id
AND request_id='&Request_Id';
Query : 2
SELECT sql_text,
lockwait
FROM v$session a, v$sql b
WHERE a.sql_address = b.address
AND a.sql_hash_value = b.hash_value
AND a.sid = '&SID';
No comments:
Post a Comment