监控oracle连接状态SQL语句select s.username,s.osuser,s.program,s.MACHINE, s.sid, s.serial#, p.spid,
监控oracle连接状态SQL语句
select s.username,s.osuser,s.program,s.MACHINE, s.sid, s.serial#, p.spid, 'alter system kill session '||''''||trim(s.sid)||','||trim(s.serial#)||''';'from v$session s,v$process pwhere s.paddr = p.addr and s.username is not nullorder by s.username
?