kill session

select * fromv$Session

where USERNAME='NBS_COMMON'

 

select session_idfrom v$locked_object

 

SELECTsid, serial#, username, osuserFROM v$session wheresid = SESSION_DI

 

alter systemkill session sid,serial#

 

altersystemkillsession'701,5' immediate–强制立即释放会话