Session会话关闭

--session会话删除select 'alter system kill session '''||sid||','||serial#||''';'from v$sessionwhereusername = 'DEUSER'--查询用户session情况select ss.sid,se.serial#,se.command,ss.value CPU ,se.username,se.programfrom v$sesstat ss, v$session sewhere ss.statistic# in(select statistic#from v$statnamewhere name = 'CPU used by this session')and se.sid=ss.sidand ss.sid>6 and username='DEUSER'order by ss.sid