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;
种瓜得瓜，种豆得豆；一份耕耘，一份收获
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;