oracle之报错:ORA-00054: 资源正忙，要求指定 NOWAIT

SQL> drop table cux_function;

drop table cux_function

ORA-00054: 资源正忙, 但指定以 NOWAIT 方式获取资源, 或者超时失效
=========================================================

解决方法如下：

=========================================================

SQL> select session_id from v$locked_object;

SESSION_ID
----------
379

SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 6342;

SID SERIAL# USERNAME OSUSER
---------- ---------- ------------------------------ ------------------------------
369 6342 SCOTT LILWEN

SQL> ALTER SYSTEM KILL SESSION '379,6342';

System altered

SQL> conn apps/apps@test05
Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
Connected as apps

SQL> drop table cux_function;

Table dropped