RE: Deadlocks

The absolute joy of working with Oracle is that there shall always be questions
for the rest of my life.
I would answer that we care because we questioned; therefore, any answers are gems for our notebooks;
However, I don't have an answer for you at this time.

Brad

-----Original Message-----
From: blair_at_pjm.com [mailto:blair_at_pjm.com] Sent: Thursday, April 27, 2000 9: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