Re: Statspack and Enqueue wait times

If your sessions are waiting on the Enqueue event, then they are waiting for locks to be released before they can continue. So you'll have to revisit the application and see if you can reduce the lock contention.

HTH,
Brian

JK_Yahoo wrote:
>
> IN follow-up of a performance issue, we received a statspack report,
> which has "enqueue" as the FIRST top-5 wait event
>
> Time duration : 2 hours
> Enqueue : 62,000 / WaitTime ( CS )15,000,000 / Total % 74%
>
> Similar situation for a similar DB for anotehr application for another
> client.
>
> Referring to :
> http://otn.oracle.com/oramag/oracle/03-jan/o13expert.html
> initrans and maxtrans is set to 1 and 255 respectively.
>
> Any suggestions on how the wait-time on enqueue be reduced to minimal
> or negligible.
>
> Your responses are appreciated.
>
> Thanks,
> JK

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"