XPost: comp.databases.oracle.server   
   From: a@abc.com   
      
   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"  wrote in message news:2nes9tF51mbU1@uni-berlin.de...   
   >   
   > "harry"  wrote in message   
   > news:vgpQc.128$jZ1.1667187@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.   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)