Re: Statspack and Enqueue wait times

In the two hours windows, your wait time on enqueue was 15,000,000CS=150,000 seconds, almost 20 times the window's length. It's very likely that you have classic blocking/locking issues--I have got the rows you want to have already locked. You can query V$lock to see who the blockers are and what they are doing and who the blockees are and what they are trying to do. After you know the reason you might fix it by rewriting the application code.

HTH,
http://www.webyourcompany.com

JKMalpani_at_Yahoo.com (JK_Yahoo) wrote in message news:<7a58b2f6.0306241007.5608970b_at_posting.google.com>...
> 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
Received on Wed Jun 25 2003 - 20:17:43 CDT