摘要： 1.首先用这条语句查出带锁的的对象。 select object_name as 对象名称, s.sid, s.serial#, p.spid as 系统进程号 from v$locked_object l, dba_objects o, v$session s, v$process p where l.object_id = o.object_id and l.session_id = s.sid and s.paddr = p.addr;2.然后执行alter system kill session 'sid，serial#' immediate;这样就可以了当然这样操作完 阅读全文