查看当前session的SQL

SELECT a.sid || '.' || a.serial#,
       a.username,
       a.terminal,
       a.program,
       s.sql_text
  FROM v$session a, v$sqlarea s
 WHERE a.sql_address = s.address(+)
   AND a.sql_hash_value = s.hash_value(+)
 ORDER BY a.username, a.sid;
SELECT *
  FROM v$session t, v$sqltext tt
 WHERE t.sql_id = tt.sql_id
   AND t.sid = 334.79;