|
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; 測試結(jié)果 OBJECT_NAME MACHINE SID SERIAL# -------------------------------------------------------------------------------- ---------------------------------------------------------------- ---------- ----------------------------------- STAT_SCHOOL WORKGROUP\20120508-0911 1729 15 2 關(guān)閉鎖定的表 alter system kill session 'sid, serial#'; 測試 alter system kill session '1729, 15'; |
|
|
