Enqueue waits

From: Diego Cutrone <dcutrone_at_afip.gov.ar>
Date: Thu, 24 Aug 2000 19:07:58 -0300
Message-Id: <10599.115518@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_04E6_01C00DFE.9DB960C0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,=20

I've a instance which has some serious "enqueue waits" EVENT TIME_WAITED AVERAGE_WAIT=20 enqueue 1345358 1345358.00=20

here's an output from x_$ksqst. (sorry about the format) TY GETS WAITS=20

CF     22     0=20
CI     956     0=20
CU     2024     0=20
DL     21     0=20
DR     22     0=20
DX     29655     0=20
IS     56     0=20
MR     36     0=20
RT     1     0=20
SQ     27     0=20
SS     1     0=20
ST     403     1=20
TM     7134     0=20
TS     295     0=20
TX     2710     0=20
US     2868     0=20

=20
Where should I start looking ?
Can this be a side effect of some other wait? And, what can I do about it?

Thanks.

------=_NextPart_000_04E6_01C00DFE.9DB960C0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.2106.6"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>Hi, </FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>    I've a instance =
which has=20
some serious "enqueue waits"</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2><FONT face=3D"Courier New" size=3D2>
<P>EVENT TIME_WAITED AVERAGE_WAIT </P>
<P>enqueue 1345358 1345358.00 </FONT></FONT></P></DIV>
<DIV> </DIV>
<DIV><FONT color=3D#000000 size=3D2>    here's an output =
from=20
x_$ksqst. (sorry about the format)</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2><FONT face=3D"Courier New" size=3D2>
<P>TY GETS WAITS </P>
<DIV><FONT color=3D#000000 face=3DArial>CF    =20
22     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>CI    =20
956     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>CU    =20
2024     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>DL    =20
21     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>DR    =20
22     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>DX    =20
29655     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>IS    =20
56     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>MR    =20
36     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>RT    =20
1     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>SQ    =20
27     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>SS    =20
1     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>ST    =20
403     1 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>TM    =20
7134     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>TS    =20
295     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>TX    =20
2710     0 </FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial>US    =20
2868     0 </FONT></FONT></FONT><FONT = color=3D#000000=20
face=3DArial></FONT></DIV></DIV>
<DIV><FONT color=3D#000000 size=3D2>    </FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>Where should I start looking =
?</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>Can this be a side effect of some =
other=20

wait?</FONT></DIV>


<DIV><FONT size=3D2>And, what can I do about it?</FONT></DIV>

<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Thanks.</FONT></DIV></BODY></HTML>
Received on Thu Aug 24 2000 - 17:07:58 CDT