Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!news1.google.com!Xl.tags.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local02.nntp.dca.giganews.com!nntp.bt.com!news.bt.com.POSTED!not-for-mail NNTP-Posting-Date: Fri, 23 Jan 2009 17:37:29 -0600 From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server References: <4978dca3$0$15296$426a74cc@news.free.fr> Subject: Re: Fast roll-back Date: Fri, 23 Jan 2009 23:37:30 -0000 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5512 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 X-RFC2646: Format=Flowed; Original Message-ID: Lines: 34 X-Usenet-Provider: http://www.giganews.com X-AuthenticatedUsername: NoAuthUser X-Trace: sv3-pP9byh9MugZ36FlsPNlQq+NkZ/f5+dL4tphq1kgLfSTTieVldQsHdj3gehmb5iadcBa4Z42AnRM28Kp!44J2wlKl/OsdnlheaUgaX501zqnTDzZj/n2DAHfpVSXrC847bwu7Do7UGoPvB+YmfWSsn91YCZM= X-Complaints-To: abuse@btinternet.com X-DMCA-Complaints-To: abuse@btinternet.com X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.39 Xref: news.cambrium.nl "Mladen Gogala" wrote in message news:gldfif$3en$1@ss408.t-com.hr... > On Fri, 23 Jan 2009 12:33:36 +0000, Jonathan Lewis wrote: > >> If the session is killed or the database is restarted (before the >> process commits its transaction) then smon handles the rollback. > > I am humbled. My mentioning of PMON was a honest mistake, caused > by the aforementioned root canal. > Mladen, I hadn't noticed that you'd said pmon instead of smon. I have a feeling that there was a time when pmon was the process that did the rollback if a user process crashed - but I don't recall when it could have changed. -- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html