ORA-00054: resource busy... - what on Earth?

From: harry <a_at_abc.com>
Date: Thu, 05 Aug 2004 11:57:15 GMT
Message-ID: <vgpQc.128$jZ1.1667187_at_news-text.cableinet.net>

Using Oracle 8i, when I issue * (seems to be random number of times) number of update statements my app hangs while waiting to execute the next update statement.

If I try then to drop any table I get -

    DROP TABLE project CASCADE CONSTRAINTS

               *
    ERROR at line 1:
    ORA-00054: resource busy and acquire with NOWAIT specified

I have to restart the server to clear this!

It appears my UPDATE statments are locking tables, absolutely no idea why - is there something I should be specifying/setting somewhere to prevent this?

thanks

harry Received on Thu Aug 05 2004 - 13:57:15 CEST