ORA-00054: resource busy and acquire with NOWAIT specified

Question

Hi, I killed a script that was in the middle of updating a table. Now when I rerun the script I am getting,

ORA-00054: resource busy and acquire with NOWAIT specified

I presume the table is locked?. How do I unlock the table?. Thanks in advance.

Answer 1

You'll have to wait. The session that was killed was in the middle of a transaction and updated lots of records. These records have to be rollbacked and some background process is taking care of that. In the meantime you cannot modify the records that were touched.

Regards, Rob.

Answer 2

When you killed the session, the session hangs around for a while in "KILLED" status while Oracle cleans up after it.

If you absolutely must, you can kill the OS process as well (look up V$SESSION.SPID), which would release any locks it was holding on to.

See this for more detailed info.