Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: enqueue in statspack

Re: enqueue in statspack

From: amit poddar <amit.poddar_at_yale.edu>
Date: Thu, 20 Oct 2005 11:23:19 -0400
Message-ID: <4357B667.3090901@yale.edu>


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
Received on Thu Oct 20 2005 - 10:32:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US