row lock contention

From: Vissu <vissuyk_at_yahoo.com>
Date: 6 Apr 2004 20:28:21 -0700
Message-ID: <2bedd6a7.0404061928.2ecfba2e@posting.google.com>

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 user. Could someone please offer some help

Vissu Received on Tue Apr 06 2004 - 22:28:21 CDT