强制杀掉锁定对象的session

1、查看锁定对象对应session

SELECT a.object_id, a.session_id, b.object_name, c.*
  FROM v$locked_object a, dba_objects b, v$session c
 WHERE a.object_id = b.object_id
   AND a.SESSION_ID = c.sid

2、查看对应session后台进程

 

select spid
  from v$process
 where addr = (select paddr from V_$SESSION t where sid = 96)

3、后台强制杀掉进程

 

kill -9 xxxx

或

alter system kill session ‘sid,serial#’;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28598517/viewspace-758193/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28598517/viewspace-758193/