Re: event= to capture deadlock debug info

From: Praveen S <pravsu_at_vsnl.com>
Date: Fri, 26 Oct 2001 11:43:02 -0700
Message-ID: <F001.003B5FAF.20011026114519@fatcity.com>

Hello,

I am facing a similar situation which occurs sometimes. We have some clients who either due to power or network problems drop their connections. The problem is that once this happens other clients also have problems in accessing the particular tables. There are no ORA-600 nor trace files. There are no locks either. The process is still listed as active. And after some time, sometimes about an hour, the process stops being shown and its back to business as usual.

I do need help on this urgently, please help.

We are using oracle 8.0.3 on NT.

TIA, Praveen.

PS. Please mail me offline as well.

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 23, 2001 4:35 AM

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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Praveen S
  INET: pravsu_at_vsnl.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).

Received on Fri Oct 26 2001 - 13:43:02 CDT