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

Home -> Community -> Usenet -> c.d.o.server -> Statspack and Enqueue wait times

Statspack and Enqueue wait times

From: JK_Yahoo <JKMalpani_at_Yahoo.com>
Date: 24 Jun 2003 11:07:31 -0700
Message-ID: <7a58b2f6.0306241007.5608970b@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 Tue Jun 24 2003 - 13:07:31 CDT

Original text of this message

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