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" <[EMAIL PROTECTED]> 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... >>> [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praveen S 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).
