select *
fromv$Session
where USERNAME='NBS_COMMON'
select session_id
from v$locked_object
SELECT
sid, serial#, username, osuser
FROM v$session where
sid =
SESSION_DI
alter system
kill session
sid,serial#
altersystemkillsession'701,5'
immediate–强制立即释放会话