garden2.jpg

Concurrent requests and database session ID



– This script would list all currently running concurrent requests and associated database session info.
– Jul 2007
– Bobby A.
– map_conc_req_to_SID.sql

idbasolutions.com Apr 2008
set linesize 120
column SID format 99999
column status format a8
column osuser format a8
column username format a8
column COMMAND format 999999
column MACHINE format a6
column MODULE format a10
column SCHEMANAME format a5
column action format a8
column LOCKWAIT format a8
column action format a8

select fcr.request_id, s.sid ,p.spid os_pid, s.status, s.osuser,s.username,s.COMMAND,
s.MACHINE,s.MODULE,s.SERIAL#, s.SCHEMANAME, s.LOCKWAIT,s.action
from fnd_concurrent_requests fcr, v$session s , v$process p
WHERE s.paddr = p.addr
and fcr.phase_code = ‘R’
and fcr.os_process_id = s.process ;

Latest Blog Items

email

Thank you for your interest in idbasolutions.

Contact us using this email: contact.us@idbasolutions.com