RE: DEAD LOCK ???

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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of BN
> Sent: Monday, November 22, 2004 10:51 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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

Other related posts: