XPost: comp.databases.oracle.server   
   From: alan@erols.com   
      
   "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)