From: boston103@hotmail.com   
      
   Hello Nick,   
      
      
   "NicK"  wrote in message   
   news:bs0op0$hsh8@news-dxb.emirates.net.ae...   
   > Hey VC!   
   >   
   > If you check out the Oracle press materials on Oracle 9i, it explicitly   
   > states that dead-locks are checked for and prevented.   
      
   Well,  Oracle misled you.  I can post a sample scenario where Oracle 9i   
   dead-locks  during primary key updates with unindexed foreign keys (if you   
   are interested).   
      
      
   VC   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)