用(1)select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID
查出数据库锁
找到(1)对应的sid,serial#
用alter system kill session 'sid,serial#'杀死对应session解锁;
用(1)select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID
查出数据库锁
找到(1)对应的sid,serial#
用alter system kill session 'sid,serial#'杀死对应session解锁;
转载于:https://my.oschina.net/u/437933/blog/144874