Message-Id: <10599.115518@fatcity.com> From: "Diego Cutrone" Date: Thu, 24 Aug 2000 19:07:58 -0300 Subject: Enqueue waits 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
Hi,
 
    I've a instance = which has=20 some serious "enqueue waits"

EVENT TIME_WAITED AVERAGE_WAIT

enqueue 1345358 1345358.00

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

TY GETS WAITS

CF    =20 22     0
CI    =20 956     0
CU    =20 2024     0
DL    =20 21     0
DR    =20 22     0
DX    =20 29655     0
IS    =20 56     0
MR    =20 36     0
RT    =20 1     0
SQ    =20 27     0
SS    =20 1     0
ST    =20 403     1
TM    =20 7134     0
TS    =20 295     0
TX    =20 2710     0
US    =20 2868     0
   
Where should I start looking = ?
Can this be a side effect of some = other=20 wait?
And, what can I do about it?
 
Thanks.