Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to identify rollback in progress?

Re: How to identify rollback in progress?

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 31 Aug 2005 00:55:20 +0100
Message-ID: <bf46380508301655612bf984@mail.gmail.com>


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

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



On 8/29/05, Jared Still <jkstill_at_gmail.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 <Brandon.Allen_at_oneneck.com> wrote:
> >
> > Anyone know of a quick way to identify any/all transactions currently
> > being rolled back? I know I could look for decreasing used_ublk in
> > v$transaction, or increasing undo statistics in v$sesstat, but is there
> > anywhere that a transaction is simply flagged as currently being rolled
> > back, so you can quickly identify it w/o having to check for deltas?
> >
>
-- http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 30 2005 - 18:57:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US