home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,244 of 2,288   
   AnaCDent to Vissu   
   Re: row lock contention   
   07 Apr 04 17:15:48   
   
   From: anacedent@hotmail.com   
      
   Vissu wrote:   
   > Hi All,   
   >   
   > I am seeing the following wait times when i issue an update stmt with   
   > inner select:   
   >   
   > Elapsed times include waiting on following events:   
   >   Event waited on                             Times   Max. Wait  Total   
   > Waited   
   >   ----------------------------------------   Waited  ----------   
   > ------------   
   >   enq: TX - row lock contention                  62        3.00   
   > 185.78   
   > **************************************************************   
   *****************   
   >   
   > How can I fix this?. My dml_locks is set to 1000 and I am the only   
      
   Increase INITRANS on the object in question.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca