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
