Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Statspack and Enqueue wait times
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 Tue Jun 24 2003 - 13:07:31 CDT