Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> enq: TX - index contention

enq: TX - index contention

From: Stalin <stalinsk_at_gmail.com>
Date: Mon, 21 Mar 2005 18:47:38 -0800
Message-ID: <c5363d3a050321184730e8b7d2@mail.gmail.com> 





We have been doing application load testing lately and I found enq TX
index contention being the top contender among other waits. The table
with 5 indexes, all it's index columns gets updated via an update for
every id in that table by no. of concurrent users defined by the load
testing scripts. 10046 trace had lot's of similar lines with varrying
p2 and p3 values.



WAIT #1: nam='enq: TX - index contention' ela= 3001942 p1=1415053316
p2=65547 p3=816



How can i overcome this wait without amending application behavior.



Is this caused by index splits ? 



Thanks


Stalin



10g(10.1.0.3)/solaris

--
http://www.freelists.org/webpage/oracle-l


Received on Mon Mar 21 2005 - 21:51:13 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US