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

"harry" <a (AT) abc (DOT) com> wrote

If you do not have FKs indexed, you will get a table lock instead of a row
lock.

Thanks for the replies so quickly, I don't have any FK's indexed at the
moment - this looks like the cause then?

I'm going to put indexes now on every single one of them & see if it makes a
difference!

thanks


"Alan" <alan (AT) erols (DOT) com> wrote