RE: DEAD LOCK ???

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Mon, 22 Nov 2004 11:19:15 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9BF8@AABO-EXCHANGE02.bos.il.pqe>

Hmm...it looks like the info you've provided is incomplete.

Where did you get this? The output below looks like the output of a query, probably on V$LOCK. =20 The reason it looks incomplete is that while there is one "waiter" (sid 65), it doesn't appear to be blocked by anything. Note that there's only one line that shows a non-zero in the "REQUEST" column, which would indicate a waiting process. Further, it looks like sid 65 is waiting on a TX enqueue, where ID1=3D1730955 and ID2=3D547023, but there are no other sessions shown holding that enqueue. =20 So, why's 65 waiting, if no one else is blocking?

Bottom line, no, this doesn't look like a deadlock, but there's not enough info here to draw any real conclusions.

Please provide more detailed info as to your=20 situation, and how you arrived with the provided output. (The specific query executed would be helpful.)

-Mark

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of BN
> Sent: Monday, November 22, 2004 10:51 AM
> To: oracle-l_at_freelists.org
> Subject: DEAD LOCK ???

>=20
>=20

> Greetings,

>=20

> Is this a DEAD Lock? Why don't I see any error messages in=20
> the alert log.
> Oracle 8174 on HP UX.

>=20


> ADDR             KADDR              SID TY        ID1        ID2    =20

> LMODE    REQUEST      CTIME      BLOCK

> ---------------- ---------------- ----- -- ---------- ----------

> ---------- ---------- ---------- ----------

> 8000000100117958 8000000100117A98    65 TX     131135     738193     =20

>    6          0        926          0

> C00000003581EB38 C00000003581EB60    65 TM      35553          0     =20

>    3          0        926          0

> C00000003581DAD0 C00000003581DAF8    65 TM      79590          0     =20

>    3          0        926          0

> C000000033D60DC8 C000000033D60DE8    65 TX    1703955     547023     =20

>    0          4        920          0

> 8000000100117958 8000000100117A98   166 TX     458775     742661     =20

>    6          0       2285          0

> C000000035822ED0 C000000035822EF8   166 TM      35553          0     =20

>    3          0       2285          0

> C000000035819690 C0000000358196B8   166 TM      79582          0     =20

>    3          0       2284          0

>=20
>=20

> --=20
> Regards & Thanks
> BN
> --
> http://www.freelists.org/webpage/oracle-l
>=20

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 22 2004 - 10:20:29 CST