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 <[EMAIL PROTECTED]> 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... > > >>> [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
