Paul-- Look for UBA-BLK/FIL/REC values in the V$transaction and dump those blocks for the transaction id.. XID is USN.SLOT#.WRAP#. -Gopal On Tue, Mar 10, 2015 at 8:21 AM, Paul Harrison <cure@xxxxxxxxxxxxx> wrote: > Hi All, > > > > How does one find the undo block number associated with a transaction? I > want to dump the undo block to see the contents? > > > > > > Below is the block number associated with the data block but not sure how > to find the undo block number for this transaction. Is the “Uba” of the > Transaction table the undo block number? > > > > select > > 2 dbms_rowid.rowid_relative_fno(rowid) File#, > > dbms_rowid.rowid_block_number(rowid) Block# > > 4 from t1 > > 5 ; > > > > FILE# BLOCK# > > ---------- ---------- > > 1 93569 > > 1 93569 > > 1 93569 > > 1 93569 > > > > > > Thanks, > > Paul >