彻底搞懂uba地址转换

最新推荐文章于 2023-09-26 15:31:48 发布

scan724

最新推荐文章于 2023-09-26 15:31:48 发布

阅读量1.5k

点赞数

分类专栏： Oracle高级性能诊断

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/38798851

版权

Oracle高级性能诊断专栏收录该内容

35 篇文章 30 订阅 ¥39.90 ¥99.00

订阅专栏

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: 0x

了解本专栏