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