Hi James,
as per steve's earlier reply to this thread.. you
might be facing "hang like" situations .. for which
steve suggested taking 2 systemstate dumps from 2 diff
sessions. And you are right that these might not
always throw out ora-600 or trace files
Thx
Deepak
PS: and steve also suggested using another
undocumented "event=" command for 816 .. what was it
!@@#@!! guess what .. i just experienced event=brain
fart scope DriveHome;
- James Howerton <jhowerton_at_uabmc.edu> wrote:
> 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).
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 Mon Oct 22 2001 - 20:07:45 CDT