数据库锁表解决方法

1.第一步

SELECT dob.OBJECT_NAME Table_Name,
       lo.SESSION_ID || ', ' || vss.SERIAL# 删除号,
       lo.locked_mode,
       lo.SESSION_ID,
       vss.SERIAL#,
       vss.action Action,
       vss.osuser OSUSER,
       vss.LOGON_TIME,
       vss.process AP_PID,
       VPS.SPID DB_PID,
       vss.*
  From v$locked_object lo, dba_objects dob, v$session vss, V$PROCESS VPS
 Where lo.OBJECT_ID = dob.OBJECT_ID
   and lo.SESSION_ID = vss.SID
   AND VSS.paddr = VPS.addr
 order by 2, 3, DOB.object_name

第二步：

alter system kill session '16,15439'; --sid, serial#