Yes, they are rather similar aren't they? I hadn't looked at them very closely. On 8/30/05, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> 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@xxxxxxxxx] > *Sent:* Tuesday, August 30, 2005 4:55 PM > *To:* Allen, Brandon > *Cc:* oracle-l@xxxxxxxxxxxxx > *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@xxxxxxxxx> 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@xxxxxxxxxxx > 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