1 查看表是否被锁定的方法: SELECT object_name, machine, s.sid, s.serial# FROM gv$locked_object l, dba_objects o, gv$session s WHERE l.object_id = o.object_id AND l.session_id = s.sid; 测试结果 OBJECT_NAME MACHINE SID SERIAL# -------------------------------------------------------------------------------- ---------------------------------------------------------------- ---------- ----------------------------------- STAT_SCHOOL WORKGROUP\20120508-0911 1729 15 2 关闭锁定的表 alter system kill session 'sid, serial#'; 测试 alter system kill session '1729, 15'; |
|
来自: 走墨 > 《java 个人总结》