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/

ITPub博客

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

最新文章