Re: event= to capture deadlock debug info

From: James Howerton <jhowerton_at_uabmc.edu>
Date: Mon, 22 Oct 2001 15:13:55 -0700
Message-ID: <F001.003B1C2C.20011022150517@fatcity.com>

Hi Deepak,

Thanks for the info. The situation may not be a deadlock. I checked the alert log, no entries when the lock occured. Also no trace file was generated. On Friday we were unable to simulate the lock condition (proved the database was pretty indestructable). At this point I'm not sure what may have caused the situation. I guess I'll have to wait until it happens again and get the users to wait until I can gather more info befor I fix it.

...JIM... >>> deepakthapliyal_at_yahoo.com 10/19/01 1:02:35 PM >>> Hi James,

setting an event at init/session level would basically dump the error state into an trc file. ora-60 or deadlock by defualt writes a message in alert file and also dumps a large trace in udump.

so why do you want to explicitly set this event? The default behaviour mimicks the same anyways.

hth
Deepak

• James Howerton <jhowerton_at_uabmc.edu> wrote:
  > DBA's
  >
  > Does anyone know of an event= to set to capture a
  > deadlock condition?
  >
  > On two occasions now a user's session has locked up
  > due to a network problem or three finger salute or
  > who knows what(???) blocking other users from adding
  > records to the system. I have to get it fixed
  > quickly to get them working again so I don't have
  > time to study everything in the locked state before
  > killing the offending users session. It has only
  > happened twice, once at night and once on a
  > holliday. I don't have all of my toys at home to get
  > a quick look.
  >
  > TIA
  >
  > ...JIM...
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: James Howerton
  > INET: jhowerton_at_uabmc.edu
  >
  > 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).
  

  ---

Do You Yahoo!?
Make a great connection at Yahoo! Personals. http://personals.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Deepak Thapliyal
  INET: deepakthapliyal_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
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
  INET: jhowerton_at_uabmc.edu

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 Mon Oct 22 2001 - 17:13:55 CDT