Dump 叶子节点:
----- begin tree dump
branch: 0x1031b23 16980771 (0: nrow: 106, level: 2)
branch: 0x10556b0 17127088 (-1: nrow: 414, level: 1)
leaf: 0x1031b24 16980772 (-1: nrow: 363 rrow: 363)
0x1031b24 16进制转换为10机制 16980772
对其运用前面所介绍过的dbms_utility里的存储过程获得其文件号和数据块号,并对该数据块进行转储,其内容如下所示。可以
select dbms_utility.data_block_address_file(16980772), dbms_utility.data_block_address_block(16980772) from dual;
SQL> select dbms_utility.data_block_address_file(16980772), dbms_utility.data_block_address_block(16980772) from dual;
DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(16980772) DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(16980772)
---------------------------------------------- -----------------------------------------------
4 203556
select value f