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

Vivek

On one of our production database(non-rac), we noticed the "*"enq: TX - index contention". We adjusted the *
*initrans **of the relevant indices and so far we haven't noticed contention on those indices.*

**
*HTH*
*Rajeev*

• Original Message -------- Subject: "enq: TX - index contention" wait during RAC Benchmark ? From: "VIVEK_SHARMA" <VIVEK_SHARMA_at_infosys.com> <VIVEK_SHARMA_at_infosys.com> To: oracle-l_at_freelists.org Date: 2/28/2007 7:24 AM

> Folks
>
>
>
> During internal 2 Node RAC Benchmark OLTP Nature Transaction Runs,
> following are the TOP Events from 2 Statspack.
>
> * *
>
> *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?*
>
>
>
> Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
>
> ~~~~~~~~ ---------- ------------------ -------- ---------
> -------------------
>
> Begin Snap: 124 28-Feb-07 17:53:32 99 32.3
>
> End Snap: 125 28-Feb-07 18:18:08 126 27.1
>
> Elapsed: 24.60 (mins)
>
>
>
> Top 5 Timed Events Avg
> %Total
>
> ~~~~~~~~~~~~~~~~~~
> wait Call
>
> Event Waits Time (s)
> (ms) Time
>
> ----------------------------------------- ------------ ----------- ------
> ------
>
> gc buffer busy 625,165 11,067
> 18 50.0
>
> enq: TX - index contention 70,130 3,954
> 56 17.8
>
> CPU time
> 2,197 9.9
>
> row cache lock 115,227 1,389
> 12 6.3
>
> gc current block 2-way 923,272 906
> 1 4.1
>
> -------------------------------------------------------------
>
>
>
> *Configuration*
>
> 10gR2
>
> Solaris 10
>
> Veritas CFS 5.0
>
> Banking Product
>
> Will Share Statspack etc with anybody
>
> Cheers
>
>

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