摘要:
ORA-00054: 资源正忙, 但指定以 NOWAIT 方式获取资源, 或者超时失效解决方法如下:=========================================================SQL> select session_id from v$locked_object;1.查找出已被锁定的数据库表及相关的sid、serial#及spidselect object_name as 对象名称,s.sid,s.serial#,p.spid as 系统进程号from v$locked_object l , dba_objects o , v$session s , 阅读全文