dump 叶子节点

然后,我们从中随便挑一个叶子节点,对其进行转储。假设就选row#0行所指向的叶子节点,根据dba的值:25226402可以知道,文件号为6,数据块号为60578。将其转储以后,其内容如下所示,我只显示与分支节点不同的

Branch block dump
=================
header address 140436935371340=0x7fba05a56a4c
kdxcolev 1
KDXCOLEV Flags = - - -
kdxcolok 1
kdxcoopc 0x81: opcode=1: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 1
kdxconro 378
kdxcofbo 784=0x310
kdxcofeo 3713=0xe81
kdxcoavs 2929
kdxbrlmc 16982257=0x10320f1
kdxbrsno 310
kdxbrbksz 8056 
kdxbr2urrc 4
row#0[4835] dba: 16990452=0x10340f4
col 0; len 4; (4):  c3 06 2f 45  ---54689
col 1; len 3; (3):  01 03 31
row#1[4640] dba: 16995572=0x10354f4 
col 0; len 4; (4):  c3 06 2f 4d   --54676
col 1; len 3; (3):  01 03 2b
row#2[4848] dba: 16984999=0x1032ba7
col 0; len 4; (4):  c3 06 2f 55
col 1; TERM
row#3[4858] dba: 16990413=0x10340cd
col 0; len 4; (4):  c3 06 2f 64
col 1; len 3; (3):  01 03 31
row#4[3726] dba: 17000201=0x1036709
col 0; len 4; (4):  c3 06 30 08
col 1; len 3; (3):  01 03 31
row#5[4871] dba: 16979575=0x1031677
col 0; len 4; (4):  c3 06 30 10
col 1; TERM
row#6[4881] dba: 16990417=0x10340d1
col 0; len 4; (4):  c3 06 30 1f
col 1; len 3; (3):  01 03 31
row#7[3778] dba: 16999945=0x1036609
col 0; len 4; (4):  c3 06 30 27
col 1; len 3; (3):  01 03 2b
row#8[4894] dba: 16984778=0x1032aca
col 0; len 4; (4):  c3 06 30 2f
col 1; TERM

 然后,我们从中随便挑一个叶子节点,对其进行转储。假设就选row#0行所指向的叶子节点,
 
 根据dba的值:25226402可以知道,文件号为6,数据块号为60578。
 
 将其转储以后,其内容如下所示,我只显示与分支节点不同的部分。
 
 
select dbms_utility.data_block_address_file(25226402), dbms_utility.data_block_address_block(25226402) from dual;
  
 SQL> select dbms_utility.data_block_address_file(25226402), dbms_utility.data_block_address_block(25226402) from dual;

DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(25226402) DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(25226402)
---------------------------------------------- -----------------------------------------------
					     6						 60578

SQL> alter system dump datafile 6 block 60578;

row#0[4835] dba: 16990452=0x10340f4
col 0; len 4; (4):  c3 06 2f 45
col 1; len 3; (3):  01 03 31
row#1[4640] dba: 16995572=0x10354f4
col 0; len 4; (4):  c3 06 2f 4d
col 1; len 3; (3):  01 03 2b
row#2[4848] dba: 16984999=0x1032ba7
col 0; len 4; (4):  c3 06 2f 55
col 1; TERM

col 0表示索引键值,其算法与我们在前面介绍分支节点时所说的算法一致。col 1表示ROWID
					 
原文地址:https://www.cnblogs.com/hzcya1995/p/13348393.html