--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