1.先获取SID帮助-关于Oracle Applications–会话 SID : 1349
2.用plsqldev等软件根据SID查询所用sql查询语句
SELECT s.prev_sql_addr, s.sql_address FROM v$session s WHERE s.sid = 1349;

SELECT t.SQL_TEXT
  FROM v$sqltext_with_newlines t
 WHERE t.address = '000000025EDA2CB0'
 ORDER BY T.PIECE;