EBS R12的Concurrent Request ID和数据库Session ID的关联

ORACLE EBS的Request ID和后台数据库Session通过apps.fnd_concurrent_requests.oracle_process_id字段和

v$process.spid字段关联。

下面的SQL可以根据Request ID找到对应的Session信息:

select *  from v$session
where paddr in
   (select addr  from v$process  where spid = 
        (select b.oracle_process_id  from apps.fnd_concurrent_requests b
          where b.request_id = &req_number)
   ) ; 

或者进一步找到正在运行的SQL: 

select  *  from  v$sql  where  sql_id = （上面v$sessoin中查询出的sql_id）; 

或

select sql_text  from v$sqltext_with_newlines
where hash_value in
(select SQL_HASH_VALUE  from v$session  where paddr in
    (select addr  from v$process  where spid = 
         (select b.oracle_process_id  from apps.fnd_concurrent_requests b
            where b.request_id = &req_number
         )
    )
)  order by piece;  

本文转自ITPUB博客tolywang的博客，原文链接：EBS R12的Concurrent Request ID和数据库Session ID的关联，如需转载请自行联系原博主。