SQL> conn / as sysdba; Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 Connected as SYS
SQL> select * from v$locked_object; 从结果中找到你锁住的那个表的session_id SQL> select sid,serial# from v$session where sid = 上一步找到的那个session_id; SQL> alter system kill 'sid,serial$' 这里面的sid,serial#就是上一步查出来的值
SQL> conn / as sysdba;
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as SYS
SQL> select * from v$locked_object;
从结果中找到你锁住的那个表的session_id
SQL> select sid,serial# from v$session where sid = 上一步找到的那个session_id;
SQL> alter system kill 'sid,serial$'
这里面的sid,serial#就是上一步查出来的值
没有在程序里面相应的对策??