469,936 Members | 2,487 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,936 developers. It's quick & easy.

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

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
Jul 19 '05 #1
2 27038

"harry" <a@abc.com> wrote in message
news:vg*******************@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.
Jul 19 '05 #2
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" <al**@erols.com> wrote in message news:2n***********@uni-berlin.de...

"harry" <a@abc.com> wrote in message
news:vg*******************@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.

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Adam Ruth | last post: by
6 posts views Thread by bdj | last post: by
reply views Thread by basmgokul | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.