摘要:
[解决方法]1)通过查找已被锁定的数据库表以及相关的sid,serial#,spid;select object_name,s.sid,s.serial#,p.spid 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)在数据库中杀死Sessionalter system kill session 'sid,serial#'; --sid,serial#是上面查 阅读全文