Re: undo block number

  • From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
  • To: cure@xxxxxxxxxxxxx
  • Date: Tue, 10 Mar 2015 08:38:54 -0500

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
>

Other related posts: