Re: Interpreting USED_UREC from V$TRANSACTION
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 7 Jul 2012 12:23:29 +0100
Message-ID: <FBD69BB7FC934C79A33B933C5FDCC58F_at_Primary>
Date: Sat, 7 Jul 2012 12:23:29 +0100
Message-ID: <FBD69BB7FC934C79A33B933C5FDCC58F_at_Primary>
And I forgot to mention that you'd get a redo entry for each undo record applied - so you can cross check the stats to see if anything odd has happened there too.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all_postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
- Original Message ----- From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> To: <oracle-l_at_freelists.org> Sent: Saturday, July 07, 2012 12:21 PM Subject: Re: Interpreting USED_UREC from V$TRANSACTION
To answer the tracking question:
Unless 11.2.0.3 has changed from previous versions of Oracle, the number of redo entries will be one per column dropped per row affected - at about (210 + column size) bytes per redo entry, and checking "rollback changes - undo records applied" should tell you where you are and how far you have to go.
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jul 07 2012 - 06:23:29 CDT