Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!easynet-quince!easynet.net!kibo.news.demon.net!news.demon.co.uk!demon!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: Following the rollback of a killed session Date: Fri, 12 Dec 2003 12:00:37 -0000 Lines: 45 Message-ID: References: <3fd0a2f7$0$28713$626a54ce@news.free.fr> NNTP-Posting-Host: jlcomp.demon.co.uk X-Trace: news.demon.co.uk 1071230437 27763 158.152.75.41 (12 Dec 2003 12:00:37 GMT) X-Complaints-To: abuse@demon.net NNTP-Posting-Date: Fri, 12 Dec 2003 12:00:37 +0000 (UTC) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Priority: 3 X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MSMail-Priority: Normal Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:249961 Mainly pmon (the process monitor), but any session that needs to use a block that has been modified by the killed session may tidy up that block before pmon gets to it. -- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html "Michel Cadot" wrote in message news:3fd0a2f7$0$28713$626a54ce@news.free.fr... > Hi, > > When a session executes a rollback statement, you can follow the rollback > by watching the used_blk column in v$transaction. > But when the session is killed, taddr in v$session is "set" to null and the row in the > v$transaction is deleted. > So, how can you follow the rollback executing for this session? > In addition, who executes this rollback? The server process (dedicated or > shared) or a background process? >