Re: row lock contention
From: AnaCDent <anacedent_at_hotmail.com>
Date: Wed, 07 Apr 2004 17:15:48 -0700
Message-ID: <VQ0dc.2816$Vo.2583_at_fed1read03>
Date: Wed, 07 Apr 2004 17:15:48 -0700
Message-ID: <VQ0dc.2816$Vo.2583_at_fed1read03>
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. Received on Thu Apr 08 2004 - 02:15:48 CEST