Sunday, April 29, 2012

Analyzing The Queries Through Concurrent Program Request ID (Performance Testing)



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