ORA-00054: Resource busy, requirement to specify nowai

The problem is as follows:

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:
The resource is busy, but it is specified to get the resource in Nowait mode, or the timeout expires.
========================================================== ========================

The solution is as follows:

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

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 '2017, 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

 

===================== Reference Materials ================================== ==============

Http://blog.sina.com.cn/s/blog_54eeb5d90100ntgc.html