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

  • From: "Rajeev Prabhakar" <rprabha01@xxxxxxxxx>
  • To: VIVEK_SHARMA@xxxxxxxxxxx
  • Date: Thu, 1 Mar 2007 08:56:50 -0500

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@xxxxxxxxxxx> <VIVEK_SHARMA@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2007