Oracle EBS 查看请求执行情况

SELECT s.*
  FROM fnd_concurrent_requests r, v$session v, v$sql s
 WHERE r.oracle_session_id = v.audsid
   AND v.sql_id = s.sql_id
   AND r.request_id = 726027;

 rac 查询

SELECT s.*
  FROM fnd_concurrent_requests r, gv$session v, gv$sql s
 WHERE r.oracle_session_id = v.audsid
   AND v.sql_id = s.sql_id
   AND r.request_id = 726027;

 

gv$开头视图是rac全局的，v$开头是本节点的

gv$session比v$session多一个字段而已： INST_ID