enqueue in statspack

From: Alfonso León <aleon68_at_gmail.com>
Date: Thu, 20 Oct 2005 10:03:13 -0500
Message-ID: <83a585ac0510200803n35520557jfe66e643040e727f@mail.gmail.com>

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
--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 20 2005 - 10:05:59 CDT