From oracle-l-bounce@freelists.org Tue Aug 30 18:57:19 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7UNvJpu019922 for ; Tue, 30 Aug 2005 18:57:19 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j7UNvEIP019910 for ; Tue, 30 Aug 2005 18:57:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9F51A1E7691; Tue, 30 Aug 2005 18:57:09 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19990-07; Tue, 30 Aug 2005 18:57:09 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 147031E7742; Tue, 30 Aug 2005 18:57:09 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=X1BuZH0rtajM565zserybybzIvVLdQ7KYvsyVgC2TNbDNOUAfAvuNQNpW/VzqbnjmklP1oDnph8fdNPlfXuq6Dww6aGmd4bNxvyYe8lu820pcmYvz641sv3Vb8osoFdwmSfpRq67qKoFRF2jvTJb7xGA9NLcIkVvcNgbCddQ9+Y= Message-ID: Date: Wed, 31 Aug 2005 00:55:20 +0100 From: Jared Still To: Brandon.Allen@oneneck.com Subject: Re: How to identify rollback in progress? Cc: oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_747_30695376.1125446120039" References: <04DDF147ED3A0D42B48A48A18D574C45023614E7@NT15.oneneck.corp> X-archive-position: 24782 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.4 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_747_30695376.1125446120039 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline It appears there is a script that may do what you want. I haven't tested it for accuracy. http://wisdomforce.com/dweb/resources/docs/complete_rollback_script.pdf --=20 Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On 8/29/05, Jared Still wrote: >=20 > http://www.ixora.com.au/scripts/rbs.htm >=20 > This seems to be as good as it gets. >=20 > I don't know if this improves in 10g. >=20 >=20 > On 8/29/05, Allen, Brandon wrote: > >=20 > > Anyone know of a quick way to identify any/all transactions currently= =20 > > being rolled back? I know I could look for decreasing used_ublk in=20 > > v$transaction, or increasing undo statistics in v$sesstat, but is there= =20 > > anywhere that a transaction is simply flagged as currently being rolled= =20 > > back, so you can quickly identify it w/o having to check for deltas? > >=20 > ------=_Part_747_30695376.1125446120039 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline It appears there is a script that may do what you want.

I haven't tested it for accuracy.

http://wisdomforce.com/dweb/resources/docs/complete_rollback_scrip= t.pdf


--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist



On 8/29/05, Jared Still <jkstill@gm= ail.com> wrote:
http://www.ixora.com.au= /scripts/rbs.htm

This seems to be as good as it gets.

I don't know if this improves in 10g.



On 8/29/05, Allen, Brandon <Bra= ndon.Allen@oneneck.com > wrote:
Anyone know of=20 a quick way to identify any/all transactions currently being roll= ed=20 back?  I know I could look for decreasing used_ublk in v$transaction, = or=20 increasing undo statistics in v$sesstat, but is there anywhere that a=20 transaction is simply flagged as currently being rolled back, so you can qu= ickly=20 identify it w/o having to check for deltas?
=


------=_Part_747_30695376.1125446120039-- -- http://www.freelists.org/webpage/oracle-l