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).
Received on Thu Apr 27 2000 - 08:04:20 CDT