请求正在运行的sql

--请求正在运行的sql
SELECT ses.INST_ID, ses.sid, ses.serial#, ses.sql_id ,ses.EVENT,ses.SQL_EXEC_ID
     FROM gv$session ses, gv$process pro 
 WHERE ses.paddr = pro.addr 
   AND ses.INST_ID = pro.INST_ID
   AND pro.spid IN (SELECT oracle_process_id 
                  FROM applsys.fnd_concurrent_requests 
                  WHERE request_id = &request_id);