彻底搞懂uba地址转换

SQL> update t set owner='killdb.com' where object_id=555;

已更新 1 行。

SQL> select xidusn,xidslot,xidsqn,ubablk,ubafil,ubarec,START_SCN from v$transaction;

    XIDUSN    XIDSLOT     XIDSQN     UBABLK     UBAFIL     UBAREC  START_SCN
---------- ---------- ---------- ---------- ---------- ---------- ----------
         6         15        916        366          3          6     968248

SQL>  select  dbms_rowid.rowid_block_number(rowid) blk# from t  where object_id=555;

      BLK#
----------
       491


SQL> select distinct dbms_rowid.rowid_relative_fno(rowid) file# from t;

     FILE#
----------
         5

alter system dump datafile 5 block 491;

Block header dump:  0x014001eb
 Object id on Block? Y
 seg/obj: 0x15a1d  csc: 0x00.ef4ce  itc: 3  flg: E  typ: 1 - DATA
     brn: 0  bdba: 0x14001e8 ver: 0x01 opc: 0
     inc: 0  exflg: 0

 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
0x01   0xffff.000.