Oracle EBS R12 监控concurrent 正在执行的sql

Oracle EBS R12 监控concurrent 正在执行的sql

--监控concurrent 正在执行的sql
  SELECT A.SID, A.SERIAL#, B.SQL_TEXT
    FROM V$SESSION A, V$SQLTEXT B
   WHERE A.SQL_ADDRESS = B.ADDRESS AND A.SID = :P_SID
ORDER BY B.PIECE;

--刘轶鹤转

http://www.cnblogs.com/quanweiru/p/4869697.html