--登录Oracle
sqlplus / as sysdba
--查询锁信息
select t2.username,t2.sid,t2.serial# from v$locked_object t1,v$session t2 where t1.session_id=t2.sid and rownum
Oracle删除锁方法
本文导语: --登录Oracle sqlplus / as sysdba --查询锁信息 select t2.username,t2.sid,t2.serial# from v$locked_object t1,v$session t2 where t1.session_id=t2.sid and rownum
--登录Oracle
sqlplus / as sysdba
--查询锁信息
select t2.username,t2.sid,t2.serial# from v$locked_object t1,v$session t2 where t1.session_id=t2.sid and rownum