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).
Received on Fri Oct 19 2001 - 11:53:24 CDT