select
username,
to_char(logon_time,'yyyy/mm/dd hh24:mi:ss') logon_time2,
osuser, machine, terminal, program,
sid, serial#,
status,
sql_address, sql_text
from v$session s, v$sqltext q
where type = 'USER'
and s.sql_address = q.address
order by logon_time2, s.sid, s.serial#, q.piece
username,
to_char(logon_time,'yyyy/mm/dd hh24:mi:ss') logon_time2,
osuser, machine, terminal, program,
sid, serial#,
status,
sql_address, sql_text
from v$session s, v$sqltext q
where type = 'USER'
and s.sql_address = q.address
order by logon_time2, s.sid, s.serial#, q.piece
比如客户端连接到服务器之后,执行了一系列的操作之后,从程序逻辑角度而言,程序应该关闭连接,而这个连接在以上查询中体现为INACTIVE状态,则可以说明程序中连接没有正确的关闭。