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@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 Wed Apr 07 2004 - 19:15:48 CDT