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
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: enqueue in statspack
- From: David Sharples
- Re: enqueue in statspack
- From: amit poddar
Other related posts:
- Re: enqueue in statspack
- From: David Sharples
- Re: enqueue in statspack
- From: amit poddar