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; 


原文件地址 ： http://blog.itpub.net/207/viewspace-1023112/