From ctrassens@yahoo.com Sat, 03 Nov 2001 07:56:40 -0800 From: Christian Trassens Date: Sat, 03 Nov 2001 07:56:40 -0800 Subject: Re: Dead locks Message-ID: MIME-Version: 1.0 Content-Type: text/plain - Yes, the stmts are rolled back. - You can look for them where the parameter user_dump_dest indicates. However you can receive two kinds of deadlocks. The ORA-60 ones or ORA-4020 ones. The first ones deals with enqueues and the second ones implies an library cache lock. Regards. --- "Tatireddy, Shrinivas (MED, Keane)" wrote: > Hi lists, > > If a dead lock occurs , will the statements be > rolledback by oracle ? > > will oracle do anything other than dumping trace? > > I tried. But both session never comeout. Just they > hung. > > Regards, > Srinivas > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Tatireddy, Shrinivas (MED, Keane) > INET: Shrinivas.Tatireddy@med.ge.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@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). ===== Eng. Christian Trassens Senior DBA Systems Engineer ctrassens@yahoo.com ctrassens@hotmail.com Phone : 541149816062 __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: ctrassens@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@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).