Dump 分支块

最新推荐文章于 2023-02-13 10:20:48 发布

scan724

最新推荐文章于 2023-02-13 10:20:48 发布

阅读量170

点赞数

分类专栏： Oracle dump解析

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

版权

Oracle dump解析专栏收录该内容

34 篇文章 31 订阅 ¥49.90 ¥99.00

订阅专栏

超级会员免费看

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)
      leaf: 0x1031b25 16980773 (0: nrow: 359 rrow: 359)
      leaf: 0x1031b26 16980774 (1: nrow: 359 rrow: 359)
	  
	  
对其运用前面所介绍过的dbms_utility里的存储过程获得其文件号和数据块号，并对该数据块进行转储，其内容如下所示。可以


select dbms_utility.data_block_address_file(17127088), dbms_utility.data_block_address_block(17127088) from dual;

SQL> select dbms_utility.data_block_address_file(17127088), dbms_utility.data_block_address_block(17127088) from dual;

DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(17127088) DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(17127088)
---------------------------------------------- ------------

了解本专栏