RE: Interpreting USED_UREC from V$TRANSACTION
Date: Fri, 6 Jul 2012 11:12:29 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B30649BF83D0A7_at_mail02.mba.xifin.com>
Script to Monitor SMON Rollback Progress [ID 1352046.1] I would be curious to see what the output looks like for 10min interval.
Michael Dinh
Disparity Breaks Automation (DBA)
Confidence comes not from always being right but from not fearing to be wrong - Peter T Mcintyre
Great minds discuss ideas; average minds discuss events; small minds discuss people - Eleanor Roosevelt
When any rule or formula becomes a substitute for thought rather than an aid to thinking, it is dangerous and should be discarded -Thomas William Phelps
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of GG
Sent: Friday, July 06, 2012 11:02 AM
To: Dave.Herring_at_acxiom.com
Cc: Oracle-L (oracle-l_at_freelists.org)
Subject: Re: Interpreting USED_UREC from V$TRANSACTION
W dniu 2012-07-06 19:20, Herring Dave - dherri pisze:
> Folks,
> I'm monitoring a VERY large rollback operation and could use some help in understanding conflicting values for USED_UREC in V$TRANSACTION.
>
> This is for 11.2.0.3 on RHEL 5.6. The transaction was a DROP COLUMN against a 1.3 TB table which I believe ran out of undo after 50+ hrs. The SQL was generated from a data modeling tool and even after warning about runtimes they wanted the command run exactly as generated.
>
> Now that the DROP COLUMN command has been rolling back for 5 days, I'm getting pretty confused on what V$TRANSACTION is telling me, specifically USED_UREC. Periodically over the last few days I've been querying this view and the values decreased way below zero and are now back about 800 million. In all cases each check a little later showed the values were decreasing so I knew it was still rolling back:
>
Hi,
try with this still great script :
http://www.ixora.com.au/scripts/sql/9.0/rolling_back.sql
but If You are still not in last loop this maybe missleading :( .
Regards
GregG
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 06 2012 - 13:12:29 CDT