ORA-00054: 资源正忙,要求指定 NOWAI
问题如下:
SQL> SQLPLUS
.....
SQL> conn sys/sys@192.168.15.8:1521/ORCL as sysdba
Connected to Oracle Database 11g Enterprise Edition Release
11.1.0.6.0
SQL> drop table student2;
drop table student2
ORA-00054:
资源正忙, 但指定以 NOWAIT 方式获取资源, 或者超时失效
=========================================================
解决方法如下:
=========================================================
SQL> select session_id from
v$locked_object;
SESSION_ID
----------
142
SQL> SELECT sid, serial#, username, osuser FROM
v$session where sid = 142;
SID SERIAL#
USERNAME
OSUSER
---------- ---------- ------------------------------
------------------------------
142
38
SCOTT
LILWEN
SQL> ALTER SYSTEM KILL SESSION '142,38';
System altered
SQL> conn sys/sys@192.168.15.8:1521/ORCL as sysdba
Connected to Oracle Database 11g Enterprise Edition Release
11.1.0.6.0
Connected as scott
SQL> drop table student2;
Table dropped
================参考资料=================================
http://blog.sina.com.cn/s/blog_54eeb5d90100ntgc.html