Fw: "enq: TX - index contention" wait during RAC Benchmark ?

(copy to list)


Qs 1) How can the ?enq: TX - index contention? wait be reduced?
Qs 2) How to identify the index undergoing contention? Do v$session_wait.p1, p2 
identify the index/Object?



Vivek
 
Q2: do you have the excellent Oracle Wait Interface: A Practical Guide to 
Performance Diagnostics & Tuning 
http://www.amazon.com/Oracle-Wait-Interface-Performance-Diagnostics/dp/007222729X
 which would certainly help you at the moment (It helped me last year - belated 
thanks to the authors)
 
To simplify things you can also use statspack (level 7 IIRC) to find most 
'contentious' segments across the instance (or RAC). For more information about 
the wait itself see this thread: 
http://freelists-180.iquest.net/archives/oracle-l/03-2005/msg00778.html "enq: 
TX - index contention"
 
And don't forget the docs: 
http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10752/instance_tune.htm#18211
 - search for index contention.
 
Regards Nigel

Other related posts: