RE: Deadlocks

Thank you Stephane. his is exactly the type of info i needed. But I have another question. Isn't the kind of deadlock that generates a trace dump a Dictionary deadlock. What about enqueue deadlocks that dont generate an error. Do I have to worry about them in any way?

..tom

> -----Original Message-----
> From: paquette stephane [SMTP:stephane_paquette_at_yahoo.com]
> Sent: Thursday, April 27, 2000 7:13 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Deadlocks
>
> You can see locks in Enterprise Manager Lock Manager.
> If having a deadlock, Oracle will resolve it
> automatically and will generate a trace file in udump,
> do a grep deadlock *.trc in the udump directory.
>
>
> --- Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk> a
> ecrit:
> > Tom,
> > Which monitoring tool are you using?
> > TIA
> > Aleem
> >
> >
> > -----Original Message-----
> > From: blair_at_pjm.com [mailto:blair_at_pjm.com]
> > Sent: 26 April, 2000 9:56 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Deadlocks
> >
> > 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).
> >
>
> > ATTACHMENT part 2 application/ms-tnef
>
>
> =====
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online and get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.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
Received on Thu Apr 27 2000 - 10:30:26 CDT