XPost: comp.databases.oracle.server   
   From: a@abc.com   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)