RE: Deadlocks

Hi Tom,

Monitoring 'enqueue deadlocks' is right, and not version dependent. There are plenty of other sorts of possible deadlocks, of which the library cache deadlocks are but one, but the other types are relatively rare and there is nothing you can monitor for them.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	blair_at_pjm.com [SMTP:blair_at_pjm.com]
Sent:	Friday, April 28, 2000 12:16 AM
To:	Multiple recipients of list ORACLE-L
Subject:	RE: Deadlocks

Thanks,

That site is interesting. It informed me that there is a difference between "library cache deadlocks" and "enqueue deadlocks". My tools is calling enqueue deadlocks - deadlocks. What is the difference? Should I care. Should I have the monitor not monitor this value?

..tom

> -----Original Message-----
> From: Norwood Bradly A [SMTP:Bradley.A.Norwood_at_m1.irscounsel.treas.gov]
> Sent: Wednesday, April 26, 2000 2:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Deadlocks
>
> Do a search on deadlock at Steve Adams' site for some
> answers..........http://www.ixora.com.au
>
> -----Original Message-----
> Sent: Wednesday, April 26, 2000 11:56 AM
> To: Multiple recipients of list ORACLE-L
>
>
> A monitoring tool that we use here is reporting that our database has a
> deadlock. We have not noticed it and there are no complaints.
>
> I challenged the company to tell me how they determine this. They are
> checking
> the v$sysstat for the value of "enqueue deadlocks" which in this case is 1.
>
> Is this correct? Is there a change from V7.x to 8.1.5 in how you would
> determine a deadlock condition?
>
> thanks,
>
> ..tom
>
>
>
>
> --
> Author:
> INET: blair_at_pjm.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Norwood Bradly A
> INET: Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Author: 
  INET: blair_at_pjm.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may