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

"harry" <a_at_abc.com> wrote in message
news: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
>
>

If you do not have FKs indexed, you will get a table lock instead of a row lock. Received on Thu Aug 05 2004 - 08:51:00 CDT