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: Tue, 30 Aug 2005 17:13:13 -0700
Message-ID: <bf463805083017131dd5ca10@mail.gmail.com>


Yes, they are rather similar aren't they?

I hadn't looked at them very closely.

On 8/30/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Thanks, but it looks like that one does the same thing as the one you
> referred me to yesterday (
> http://www.ixora.com.au/scripts/sql/9.0/rolling_back.sql), and in fact
> that script looks suspiciously similar to the script on ixora. I think
> somebody may have done some borrowing :-)
>
> -----Original Message-----
> *From:* Jared Still [mailto:jkstill_at_gmail.com]
> *Sent:* Tuesday, August 30, 2005 4:55 PM
> *To:* Allen, Brandon
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: How to identify rollback in progress?
>
> 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?
> > >
> >
>
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 30 2005 - 19:15:31 CDT

Original text of this message

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