Re: enqueue in statspack

From: amit poddar <amit.poddar@xxxxxxxx>
To: aleon68@xxxxxxxxx
Date: Thu, 20 Oct 2005 11:23:19 -0400

Check v$enqueue_stat

Check Oracle documentation for the column descriptions

amit

Alfonso León wrote:

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


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

References:

enqueue in statspack
From: Alfonso León

Re: enqueue in statspack

Other related posts: