We help IT Professionals succeed at work.

ORA-00054: resource busy and acquire with NOWAIT specified

mingichu
mingichu asked
on
Medium Priority
2,173 Views
Last Modified: 2012-06-21
Dear experts:

I was trying to run a PL/SQL anonymous block. It took too long because I forgot to put WHERE clause in the UPDATE statment.  So I killed the session in the middle.

Now I go back to check the table, truncate the table or drop the table, I got the error message:
ORA-00054: resource busy and acquire with NOWAIT specified

How can I solve it?

Thanks a lot!!
Comment
Watch Question

Commented:
connect with sys and execute the following query

ora816 SamSQL :> select a.sid,b.serial#,b.machine from v$access a,v$session b  where object='<Yor table name' and a.sid=b.sid;

       SID    SERIAL# MACHINE
---------- ---------- ----------------------------------------------------------------
        12        267 MANTRA\MS032000D0009


Now in the above example you can goto machine ms032000d0009
and ask the user to logout or kill session as

ora816 SamSQL :> alter system kill session '12,267';

System altered.

Now you can drop the table

Goodluck
Sameer

Author

Commented:
Thanks a lot!!
I learned a tip today!!!