oracle Session会话关闭

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