Re: enqueue in statspack

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