Oracle 查看当前会话所执行的语句以及会话相关信息

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;