&nbsp;ORACLE EBS的Request和后台数据库Session通过apps.fnd_concurrent_requests.oracle_process_id字段和v$process.spid字段关联。[@more@]<br /> <br /> 下面的SQL可以根据Request ID找到对应的Session信息:-<br /> select *<br /> from v$session<br /> where paddr in<br /> (select addr<br /> from v$process<br /> where spid =<br /> (select b.oracle_process_id<br /> from apps.fnd_concurrent_requests b<br /> where b.request_id = &amp;req_number))<br /> <br /> 或者进一步找到正在运行的SQL:-<br /> select sql_text<br /> from v$sqltext_with_newlines<br /> where hash_value in<br /> (select SQL_HASH_VALUE<br /> from v$session<br /> where paddr in<br /> (select addr<br /> from v$process<br /> where spid =<br /> (select b.oracle_process_id<br /> from apps.fnd_concurrent_requests b<br /> where b.request_id = &amp;req_number)))<br /> order by piece;<br /> <br /> 朋友提供，较为准确：<br /> <div> SELECT&nbsp;ses.sid,&nbsp;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ses.serial#&nbsp;,&nbsp;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ses.sql_id&nbsp;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;v$session&nbsp;ses,&nbsp;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;v$process&nbsp;pro&nbsp;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;ses.paddr&nbsp;=&nbsp;pro.addr&nbsp;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND&nbsp;pro.spid&nbsp;IN&nbsp;(SELECT&nbsp;oracle_process_id&nbsp;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;fnd_concurrent_requests&nbsp;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;request_id&nbsp;=&nbsp;&lt;request_id&gt;);<br /> select&nbsp;sql_text&nbsp;from&nbsp;v$sqltext&nbsp;where&nbsp;sql_id='0kkhhb2w93cx0'&nbsp;order&nbsp;by&nbsp;piece </div> <br />