关闭问题用户

查询用户信息：

 

select sid, serial#

from v$session

where username='xxxxxxx'

 

alter system kill session '$sid, $serial#'

 

 

确定当前工作的回滚段

select  a.name, b.xacts, c.sid, c.serial#, c.username, d.sql_text

from    v$rollname a, v$rollstat b, v$session c, v$sqltest d, v$transaction e

where          e.usn=b.usn

            and  b.usn=e.xidusn

            and  c.tadrr=e.addr

            and c.sql_address=d.address

            and c.sql_hash_value=d.hash_value

order by  a.name, c.sid, d.piece