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

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.com> wrote in message news:2nes9tF51mbU1_at_uni-berlin.de...
>
> "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 - 09:12:35 CDT