enqueue in statspack

  • From: Alfonso León <aleon68@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Oct 2005 10:03:13 -0500

Hello:
I have a question about enqueues, we have oracle 9.2.0.6 on a HP UX..
here is a extract on an statspack report

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                  % Total
Event                                       Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
enqueue                                      4,515 10,582 36.10

but on the enqueue details there is no indication of a significant wait.

                                                                      
         Avg Wt         Wait
Eq     Requests    Succ Gets Failed Gets       Waits   Time (ms)     Time (s)
--        ------------       ------------    -----------           
----------- ------------- ------------
TX      435,219      435,219           0                  154       
156.29           24
SQ        7,062        7,062           0                    760       
  3.69            3
CU        6,743        6,743           0                        1     
   10.00            0
HW          770          770           0                         1    
      .00            0
               -------------------------------------------------------------

so how can i know what was the DB waiting for

TIA
--
Alfonso Leon
--
//www.freelists.org/webpage/oracle-l

Other related posts: