ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > Linux操作系统 > Linux操作系统 > oracle实验记录 （dump index b*tree）

oracle实验记录 （dump index b*tree）

原创 Linux操作系统 作者：fufuh2o 时间：2009-06-26 10:16:45 0 删除 编辑

SQL> create table t (x int);

表已创建。

SQL> insert into  t values(1);

已创建 1 行。

SQL> insert into  t values(2);

已创建 1 行。

SQL> insert into  t values(9999);

已创建 1 行。

SQL> commit
  2  ;

提交完成。

SQL> create  unique index t_idx on t(x);

索引已创建。

SQL> analyze index t_idx validate structure;

索引已分析

SQL> select lf_blks,br_blks,btree_space from index_stats;

   LF_BLKS    BR_BLKS BTREE_SPACE
---------- ---------- -----------
         1          0        8000

SQL> select data_object_id from dba_objects where object_name='T_IDX';

DATA_OBJECT_ID
--------------
         55981

SQL> alter session set events 'immediate trace name treedump level 55981';

会话已更改。

 

----- begin tree dump
leaf: 0x40f082 4255874 (0: nrow: 3 rrow: 3)
----- end tree dump

SQL> select dbms_utility.data_block_address_file(4255874) "file",dbms_utility.da
ta_block_address_block(4255874) from dual;

      file DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(4255874)
---------- ----------------------------------------------
         1                                          61570

SQL> alter system dump  datafile 1 blSock 61570;

系统已更改。
Block header dump:  0x0040f082
 Object id on Block? Y
 seg/obj: 0xdaad  csc: 0x00.64f6ea  itc: 2  flg: -  typ: 2 - INDEX
     fsl: 0  fnx: 0x0 ver: 0x01
 
 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
0x01   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
0x02   0xffff.000.00000000  0x00000000.0000.00  C---    0  scn 0x0000.0064f6ea
 
Leaf block dump
===============
header address 108986972=0x67f025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 1
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 8002=0x1f42
kdxcoavs 7960
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 6
kdxlebksz 8036
row#0[8025] flag: ------, lock: 0, len=11, data:(6):  00 40 eb ea 00 00
col 0; len 2; (2):  c1 02
row#1[8014] flag: ------, lock: 0, len=11, data:(6):  00 40 eb ea 00 01
col 0; len 2; (2):  c1 03
row#2[8002] flag: ------, lock: 0, len=12, data:(6):  00 40 eb ea 00 02
col 0; len 3; (3):  c2 64 64
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 61570 maxblk 61570
EXEC #6:c=0,e=3792,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=27574480581   


SQL> select dump(2,16)from dual;

DUMP(2,16)
-----------------
Typ=2 Len=2: c1,3

SQL> delete from t where x=2;

已删除 1 行。

SQL> commit;

提交完成。

SQL> alter system dump  datafile 1 block 61570;

系统已更改。


Leaf block dump
===============
header address 108986972=0x67f025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 1
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 8002=0x1f42
kdxcoavs 7960
kdxlespl 0
kdxlende 1
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 6
kdxlebksz 8036
row#0[8025] flag: ------, lock: 0, len=11, data:(6):  00 40 eb ea 00 00
col 0; len 2; (2):  c1 02
row#1[8014] flag: ---D--, lock: 2, len=11, data:(6):  00 40 eb ea 00 01~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~被删除的还在index条目里
col 0; len 2; (2):  c1 03
row#2[8002] flag: ------, lock: 0, len=12, data:(6):  00 40 eb ea 00 02
col 0; len 3; (3):  c2 64 64
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 61570 maxblk 61570
EXEC #15:c=0,e=4843,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=28063881644

 

 

SQL> insert into t values(2);~~~~~~~~~~~~~~~~~~方便实验

已创建 1 行。

SQL> commit;

提交完成。


SQL> declare
  2  begin
  3  for i in 2..999 loop
  4  delete from t where x=i;
  5  commit;
  6  insert into t values(i+1);
  7  commit;
  8  end loop;
  9  end;
 10  /

PL/SQL 过程已成功完成。

 

SQL> analyze index t_idx validate structure;

索引已分析

SQL> select lf_blks,br_blks,btree_space from index_stats;

   LF_BLKS    BR_BLKS BTREE_SPACE
---------- ---------- -----------
         1          0        8000~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`大小没变哦，物理上重用空间了 看看 dump

 


SQL> alter session set events 'immediate trace name treedump level 5598
  2  ;

会话已更改。


----- begin tree dump
leaf: 0x40f082 4255874 (0: nrow: 3 rrow: 3)
----- end tree dump
EXEC #13:c=0,e=2142,p=0,cr=3,cu=1,mis=0,r=0,dep=0,og=1,tim=28752428105

SQL> select dbms_utility.data_block_address_file(4255874) "file",dbms_utility.
ta_block_address_block(4255874) from dual;

      file DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(4255874)
---------- ----------------------------------------------
         1                                          61570

 

Leaf block dump
===============
header address 108986972=0x67f025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 1
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 4093=0xffd
kdxcoavs 7960
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 6
kdxlebksz 8036
row#0[8025] flag: ------, lock: 0, len=11, data:(6):  00 40 eb ea 00 00
col 0; len 2; (2):  c1 02
row#1[4093] flag: ------, lock: 2, len=11, data:(6):  00 40 eb ea 00 03
col 0; len 2; (2):  c2 0b~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~1000，删除的2 已经被重用
row#2[8013] flag: ------, lock: 0, len=12, data:(6):  00 40 eb ea 00 02
col 0; len 3; (3):  c2 64 64~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~9999
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 61570 maxblk 61570
EXEC #7:c=0,e=3885,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=28895023124

 

 

SQL> select dump(1000,16) from dual;

DUMP(1000,16)
-----------------
Typ=2 Len=2: c2,b

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~继续实验
SQL> create table hr (a int);

表已创建。

SQL> insert into hr values(1);

已创建 1 行。

SQL> insert into hr values(2);

已创建 1 行。

SQL> insert into hr values(3);

已创建 1 行。

SQL> insert into hr values(4);

已创建 1 行。

SQL> insert into hr values(5);

已创建 1 行。

SQL> insert into hr values(6);

已创建 1 行。

SQL> commit;

提交完成。

SQL> declare
  2  begin
  3  for i in 1..20 loop
  4  insert into hr values(10);
  5  commit;
  6  end loop;
  7  end;
  8  /

PL/SQL 过程已成功完成。

 

SQL> insert into hr values (11);

已创建 1 行。

SQL> insert into hr values (12);

已创建 1 行。

SQL> insert into hr values (13);

已创建 1 行。

SQL> commit;

提交完成。

 

SQL> create index hr_idx on hr(a);

索引已创建。

 

SQL> analyze index hr_idx validate structure;

索引已分析

SQL> select lf_blks,br_blks,btree_space from index_stats;

   LF_BLKS    BR_BLKS BTREE_SPACE
---------- ---------- -----------
         1          0        8000

SQL> select data_object_id from dba_objects where object_name='HR_IDX';

DATA_OBJECT_ID
--------------
         55995

SQL> alter session set events 'immediate trace name treedump level 55995';

会话已更改。

----- begin tree dump
leaf: 0x40f222 4256290 (0: nrow: 26 rrow: 26)
----- end tree dump
EXEC #9:c=0,e=1269,p=0,cr=3,cu=1,mis=0,r=0,dep=0,og=1,tim=5190594035

SQL> select dbms_utility.data_block_address_file(4256290) "file",dbms_utility.da
ta_block_address_block(4256290) from dual;

      file DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(4256290)
---------- ----------------------------------------------
         1                                          61986


SQL> alter system dump datafile 1 block 61986;

系统已更改。

SQL>

 

Leaf block dump
===============
header address 111411804=0x6a4025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 26
kdxcofbo 88=0x58
kdxcofeo 7724=0x1e2c
kdxcoavs 7636
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  00 40 f2 1a 00 00
row#1[8012] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 03
col 1; len 6; (6):  00 40 f2 1a 00 01
row#2[8000] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 04
col 1; len 6; (6):  00 40 f2 1a 00 02
row#3[7988] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 05
col 1; len 6; (6):  00 40 f2 1a 00 03
row#4[7976] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 06~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为10
col 1; len 6; (6):  00 40 f2 1a 00 04
row#5[7964] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 07
col 1; len 6; (6):  00 40 f2 1a 00 05
row#6[7952] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 06
row#7[7940] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 07
row#8[7928] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 08
row#9[7916] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 09
row#10[7904] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0a
row#11[7892] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0b
row#12[7880] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0c
row#13[7868] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0d
row#14[7856] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0e
row#15[7844] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0f
row#16[7832] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 10
row#17[7820] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 11
row#18[7808] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 12
row#19[7796] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 13
row#20[7784] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 14
row#21[7772] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 15
row#22[7760] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 16
row#23[7748] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 17
row#24[7736] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 18
row#25[7724] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为10
col 1; len 6; (6):  00 40 f2 1a 00 19
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 61986 maxblk 61986
EXEC #4:c=0,e=6167,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=5291176015

 

Leaf block dump
===============
header address 111411804=0x6a4025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 29
kdxcofbo 94=0x5e~~~~~~~~~~~
kdxcofeo 7688=0x1e08
kdxcoavs 7594~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~块中可用空间数量
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  00 40 f2 1a 00 00
row#1[8012] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 03
col 1; len 6; (6):  00 40 f2 1a 00 01
row#2[8000] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 04
col 1; len 6; (6):  00 40 f2 1a 00 02
row#3[7988] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 05
col 1; len 6; (6):  00 40 f2 1a 00 03
row#4[7976] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 06
col 1; len 6; (6):  00 40 f2 1a 00 04
row#5[7964] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 07
col 1; len 6; (6):  00 40 f2 1a 00 05
row#6[7952] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为10
col 1; len 6; (6):  00 40 f2 1a 00 06
row#7[7940] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 07
row#8[7928] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 08
row#9[7916] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 09
row#10[7904] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0a
row#11[7892] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0b
row#12[7880] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0c
row#13[7868] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0d
row#14[7856] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0e
row#15[7844] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0f
row#16[7832] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 10
row#17[7820] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 11
row#18[7808] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 12
row#19[7796] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 13
row#20[7784] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 14
row#21[7772] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 15
row#22[7760] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 16
row#23[7748] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 17
row#24[7736] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 18
row#25[7724] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0b ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为10
col 1; len 6; (6):  00 40 f2 1a 00 19
row#26[7712] flag: ------, lock: 2, len=12
col 0; len 2; (2):  c1 0c
col 1; len 6; (6):  00 40 f2 1a 00 1a
row#27[7700] flag: ------, lock: 2, len=12
col 0; len 2; (2):  c1 0d
col 1; len 6; (6):  00 40 f2 1a 00 1b
row#28[7688] flag: ------, lock: 2, len=12
col 0; len 2; (2):  c1 0e~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为13
col 1; len 6; (6):  00 40 f2 1a 00 1c
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 61986 maxblk 61986
EXEC #2:c=0,e=6613,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=5404145828

SQL> select dump(10,16) from dual;

DUMP(10,16)
-----------------
Typ=2 Len=2: c1,b

SQL> select dump(13,16) from dual;

DUMP(13,16)
-----------------
Typ=2 Len=2: c1,e

 

 

SQL> delete from hr where a=10;

已删除20行。

SQL> commit;

提交完成。


SQL> analyze index hr_idx validate structure;

索引已分析

SQL> select lf_blks,br_blks,btree_space from index_stats;~~~~~~~~~~~~~~~~~~~~~~~~~~~~大小没变

   LF_BLKS    BR_BLKS BTREE_SPACE
---------- ---------- -----------
         1          0        8000

SQL> alter system dump datafile 1 block 61986;

系统已更改。


 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
0x01   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
0x02   0x0004.01b.00002bf3  0x0080031c.045d.31  --U-   20  fsc 0x0118.006beaf4
 
Leaf block dump
===============
header address 111411804=0x6a4025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 29
kdxcofbo 94=0x5e
kdxcofeo 7688=0x1e08
kdxcoavs 7594~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~块中可用空间数量 ，没变
kdxlespl 0
kdxlende 20~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~删除了20行
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  00 40 f2 1a 00 00
row#1[8012] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 03
col 1; len 6; (6):  00 40 f2 1a 00 01
row#2[8000] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 04
col 1; len 6; (6):  00 40 f2 1a 00 02
row#3[7988] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 05
col 1; len 6; (6):  00 40 f2 1a 00 03
row#4[7976] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 06
col 1; len 6; (6):  00 40 f2 1a 00 04
row#5[7964] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 07
col 1; len 6; (6):  00 40 f2 1a 00 05
row#6[7952] flag: ---D--, lock: 2, len=12~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为10的 已经标记为 D 代表删除
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 06
row#7[7940] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 07
row#8[7928] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 08
row#9[7916] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 09
row#10[7904] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0a
row#11[7892] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0b
row#12[7880] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0c
row#13[7868] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0d
row#14[7856] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0e
row#15[7844] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 0f
row#16[7832] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 10
row#17[7820] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 11
row#18[7808] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 12
row#19[7796] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 13
row#20[7784] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 14
row#21[7772] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 15
row#22[7760] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 16
row#23[7748] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 17
row#24[7736] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b
col 1; len 6; (6):  00 40 f2 1a 00 18
row#25[7724] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 0b~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为10的 已经标记为 D 代表删除
col 1; len 6; (6):  00 40 f2 1a 00 19
row#26[7712] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0c
col 1; len 6; (6):  00 40 f2 1a 00 1a
row#27[7700] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0d
col 1; len 6; (6):  00 40 f2 1a 00 1b
row#28[7688] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0e         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为13
col 1; len 6; (6):  00 40 f2 1a 00 1c
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 61986 maxblk 61986
EXEC #4:c=15625,e=7972,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=5604454876

 


  1  declare
  2  begin
  3  for i in 14..999 loop
  4  delete from hr where a=i;~~~~~~~~~~~~~~~~~~~~删除14行（没有） ，删除15，删除16
  5  commit;
  6  insert into hr  values(i+1);~~~~~~~~~~插入15，插入16，插入17
  7  commit;
  8  end loop;
  9* end;

 

SQL> analyze index hr_idx validate structure;

索引已分析

SQL> select lf_blks,br_blks,btree_space from index_stats;

   LF_BLKS    BR_BLKS BTREE_SPACE
---------- ---------- -----------
         1          0        8000

SQL> alter system dump datafile 1 block 61986;

系统已更改。

Leaf block dump
===============
header address 111411804=0x6a4025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 10
kdxcofbo 56=0x38
kdxcofeo 2836=0xb14
kdxcoavs 7860~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~块中可用空间减少
kdxlespl 0
kdxlende 0~~~~~~~~~~~~~~~~~~~~~~`没有删除的INDEX 条目
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02~~~~~~~~~~~~~~~~~~~~~~~~~~~~~1
col 1; len 6; (6):  00 40 f2 1a 00 00
row#1[8012] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 03~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~2
col 1; len 6; (6):  00 40 f2 1a 00 01
row#2[8000] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 04
col 1; len 6; (6):  00 40 f2 1a 00 02
row#3[7988] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 05
col 1; len 6; (6):  00 40 f2 1a 00 03
row#4[7976] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 06
col 1; len 6; (6):  00 40 f2 1a 00 04
row#5[7964] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 07~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为 6
col 1; len 6; (6):  00 40 f2 1a 00 05                                     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~以前 10的位置 已经被重用
row#6[7952] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0c~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为11
col 1; len 6; (6):  00 40 f2 1a 00 1a
row#7[7940] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0d
col 1; len 6; (6):  00 40 f2 1a 00 1b
row#8[7928] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 0e~~~~~~~~~~~~~~~~~~~~~~~~~~~~~13
col 1; len 6; (6):  00 40 f2 1a 00 1c
row#9[2836] flag: ------, lock: 2, len=12
col 0; len 2; (2):  c2 0b~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~值为 1000
col 1; len 6; (6):  00 40 f2 1a 00 06
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 61986 maxblk 61986
EXEC #7:c=0,e=3778,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=6429079867

 

SQL> analyze index hr_idx validate structure;

索引已分析

SQL> select lf_blks,br_blks,btree_space from index_stats;

   LF_BLKS    BR_BLKS BTREE_SPACE
---------- ---------- -----------
         1          0        8000

SQL> alter system dump datafile 1 block 61986;

系统已更改。

SQL> select dump(1000,16) from dual;

DUMP(1000,16)
-----------------
Typ=2 Len=2: c2,b

SQL>


SQL> select * from hr;

         A
----------
         1
         2
         3
         4
         5
         6
      1000
        11
        12
        13

已选择10行。

 

 


SQL> create table xh (a int);

表已创建。
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~loop例
SQL> declare
  2  begin
  3  for i in 13..99 loop
  4  insert into xh  values(i);
  5  commit;
  6  end loop;
  7  end;
  8  /

PL/SQL 过程已成功完成。

SQL> select * from xh
  2  ;

         A
----------
        13
        14
        15
        16
        17
        18
        19
        20
        21
        22
        23

         A
----------
        24
        25
        26
        27
        28
        29
        30
        31
        32
        33
        34

         A
----------
        35
        36
        37
        38
        39
        40
        41
        42
        43
        44
        45

         A
----------
        46
        47
        48
        49
        50
        51
        52
        53
        54
        55
        56

         A
----------
        57
        58
        59
        60
        61
        62
        63
        64
        65
        66
        67

         A
----------
        68
        69
        70
        71
        72
        73
        74
        75
        76
        77
        78

         A
----------
        79
        80
        81
        82
        83
        84
        85
        86
        87
        88
        89

         A
----------
        90
        91
        92
        93
        94
        95
        96
        97
        98
        99

已选择87行。

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~家~~~~~~~~~~

 

SQL> create table t (a int);

表已创建。

SQL> insert into t values(1);

已创建 1 行。

SQL> insert into t values(2);

已创建 1 行。

SQL> insert into t values(3);

已创建 1 行。

SQL> commit;

提交完成。

 


SQL> create  unique index t_idx on t(a);

索引已创建。

SQL> analyze index t_idx validate structure;

索引已分析

SQL> select lf_blks,br_blks,btree_space from index_stats;

   LF_BLKS    BR_BLKS BTREE_SPACE
---------- ---------- -----------
         1          0        8000

SQL> select data_object_id from dba_objects where object_name='T_IDX';

DATA_OBJECT_ID
--------------
         50485

SQL> alter session set events 'immediate trace name treedump level 50485';

会话已更改。


----- begin tree dump
leaf: 0x40d9d2 4250066 (0: nrow: 3 rrow: 3)
----- end tree dump

SQL> select dbms_utility.data_block_address_file(4250066) "file",dbms_utility.da
ta_block_address_block(4250066) from dual;

      file DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(4250066)
---------- ----------------------------------------------
         1                                          55762

 

SQL> alter system dump datafile 1 block 55762;

系统已更改。


Leaf block dump
===============
header address 92668508=0x586025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 1
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 8003=0x1f43
kdxcoavs 7961
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 6
kdxlebksz 8036
row#0[8025] flag: ------, lock: 0, len=11, data:(6):  00 40 d9 ca 00 00
col 0; len 2; (2):  c1 02~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~1
row#1[8014] flag: ------, lock: 0, len=11, data:(6):  00 40 d9 ca 00 01
col 0; len 2; (2):  c1 03~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~2
row#2[8003] flag: ------, lock: 0, len=11, data:(6):  00 40 d9 ca 00 02
col 0; len 2; (2):  c1 04~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`3
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 55762 maxblk 55762


SQL> select dump(2,16) from dual;

DUMP(2,16)
-----------------
Typ=2 Len=2: c1,3


SQL> delete from t where a=2;

已删除 1 行。

SQL> select * from t;

         A
----------
         1
         3

SQL> commit;

提交完成。

SQL> alter system dump datafile 1 block 55762;

系统已更改。
Leaf block dump
===============
header address 92668508=0x586025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 1
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 8003=0x1f43
kdxcoavs 7961
kdxlespl 0
kdxlende 1
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 6
kdxlebksz 8036
row#0[8025] flag: ------, lock: 0, len=11, data:(6):  00 40 d9 ca 00 00
col 0; len 2; (2):  c1 02
row#1[8014] flag: ---D--, lock: 2, len=11, data:(6):  00 40 d9 ca 00 01~~~~~~~~~~~~~~~~~~已经删除 ，但INDEX条目还在，标记为D
col 0; len 2; (2):  c1 03
row#2[8003] flag: ------, lock: 0, len=11, data:(6):  00 40 d9 ca 00 02
col 0; len 2; (2):  c1 04
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 55762 maxblk 55762

 


SQL> insert into t values(4);

已创建 1 行。

SQL> commit;

提交完成。

SQL> alter system dump datafile 1 block 55762;

系统已更改。


Leaf block dump
===============
header address 92668508=0x586025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 1
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 7992=0x1f38
kdxcoavs 7961
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 6
kdxlebksz 8036
row#0[8025] flag: ------, lock: 0, len=11, data:(6):  00 40 d9 ca 00 00
col 0; len 2; (2):  c1 02
row#1[8003] flag: ------, lock: 0, len=11, data:(6):  00 40 d9 ca 00 02
col 0; len 2; (2):  c1 04~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~原先的已经被重用
row#2[7992] flag: ------, lock: 2, len=11, data:(6):  00 40 d9 ca 00 03
col 0; len 2; (2):  c1 05
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 55762 maxblk 55762

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SQL> create table ttt (a int);

表已创建。

SQL> insert into ttt values(1);

已创建 1 行。

SQL> insert into ttt values(2);

已创建 1 行。

SQL> insert into ttt values(9999);

已创建 1 行。

SQL> commit;

提交完成。

SQL> create index ttt_idx on ttt(a);

索引已创建。

SQL> analyze index ttt_idx validate structure;

索引已分析

SQL> select data_object_id from dba_objects where object_name='TTT_IDX';

DATA_OBJECT_ID
--------------
         50491

SQL> select lf_blks,br_blks,btree_space from index_stats;

   LF_BLKS    BR_BLKS BTREE_SPACE
---------- ---------- -----------
         1          0        8000

SQL> alter session set events 'immediate trace name treedump level 50491';

会话已更改。
----- begin tree dump
leaf: 0x40d9e2 4250082 (0: nrow: 3 rrow: 3)
----- end tree dump

 

SQL> select dbms_utility.data_block_address_file(4250082) "file",dbms_utility.
ta_block_address_block(4250082) from dual;

      file DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(4250082)
---------- ----------------------------------------------
         1                                          55778

SQL> alter system dump datafile 1 block 55778;

系统已更改。

Leaf block dump
===============
header address 92668508=0x586025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 7999=0x1f3f
kdxcoavs 7957
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  00 40 d9 da 00 00
row#1[8012] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 03
col 1; len 6; (6):  00 40 d9 da 00 01
row#2[7999] flag: ------, lock: 0, len=13
col 0; len 3; (3):  c2 64 64~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~9999 长度3
col 1; len 6; (6):  00 40 d9 da 00 02
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 55778 maxblk 55778


SQL> select dump(9999,16) from dual;

DUMP(9999,16)
---------------------
Typ=2 Len=3: c2,64,64


SQL> delete from ttt where a=2;

已删除 1 行。

SQL> select * from ttt;

         A
----------
         1
      9999

SQL> commit;

提交完成。
Leaf block dump
===============
header address 92668508=0x586025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 7999=0x1f3f
kdxcoavs 7957
kdxlespl 0
kdxlende 1
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  00 40 d9 da 00 00
row#1[8012] flag: ---D--, lock: 2, len=12~~~~~~~~~~~~~~~~~~删除的还在,长度2 已经标记D,值为2
col 0; len 2; (2):  c1 03
col 1; len 6; (6):  00 40 d9 da 00 01
row#2[7999] flag: ------, lock: 0, len=13
col 0; len 3; (3):  c2 64 64
col 1; len 6; (6):  00 40 d9 da 00 02
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 55778 maxblk 55778


SQL> select dump(8888,16) from dual;

DUMP(8888,16)
---------------------
Typ=2 Len=3: c2,59,59

SQL> insert into ttt values(8888);

已创建 1 行。

SQL> commit;
Leaf block dump
===============
header address 92668508=0x586025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 7986=0x1f32
kdxcoavs 7956
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  00 40 d9 da 00 00
row#1[7986] flag: ------, lock: 2, len=13
col 0; len 3; (3):  c2 59 59~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~重用了
col 1; len 6; (6):  00 40 d9 da 00 03
row#2[7999] flag: ------, lock: 0, len=13
col 0; len 3; (3):  c2 64 64
col 1; len 6; (6):  00 40 d9 da 00 02
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 55778 maxblk 55778

提交完成。
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~最新实验与长度无关系,与顺序有关系
SQL> create table ttt (a int);

表已创建。

SQL> insert into ttt values(1);

已创建 1 行。

SQL> insert into ttt values(2);

已创建 1 行。

SQL> insert into ttt values(9999999);

已创建 1 行。

SQL> commit;

提交完成。

SQL> select * from ttt;

         A
----------
         1
         2
   9999999

SQL> create index ttt_idx on ttt(a);

索引已创建。

SQL> analyze index ttt_idx validate structure;

索引已分析

SQL> select data_object_id from dba_objects where object_name='TTT_IDX';

DATA_OBJECT_ID
--------------
         50493

SQL> select lf_blks,br_blks,btree_space from index_stats;

   LF_BLKS    BR_BLKS BTREE_SPACE
---------- ---------- -----------
         1          0        8000

SQL> alter session set events 'immediate trace name treedump level 50493';

会话已更改。

SQL> select dbms_utility.data_block_address_file(4250082) "file",dbms_utility.
ta_block_address_block(4250082) from dual;

      file DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(4250082)
---------- ----------------------------------------------
         1                                          55778

SQL> alter system dump datafile 1 block 55778;

系统已更改。

SQL> delete from ttt where a=2;

已删除 1 行。

SQL> select * from ttt;

         A
----------
         1
   9999999

SQL> alter system dump datafile 1 block 55778;

系统已更改。

SQL> insert into ttt values(99999999999);

已创建 1 行。

SQL> commit;

提交完成。

SQL> select * from ttt;

         A
----------
         1
   9999999
1.0000E+11

SQL> alter system dump datafile 1 block 55778;

系统已更改。

SQL> select dum(777777,16) from dual;
select dum(777777,16) from dual
       *
第 1 行出现错误:
ORA-00904: "DUM": 标识符无效


SQL> select dump(777777,16) from dual;

DUMP(777777,16)
------------------------
Typ=2 Len=4: c3,4e,4e,4e

SQL> insert into ttt values(777777);

已创建 1 行。

SQL> commit;

提交完成。

SQL> select * from ttt;

         A
----------
         1
   9999999
1.0000E+11
    777777

SQL> alter system dump datafile 1 block 55778;

系统已更改。


----- begin tree dump
leaf: 0x40d9e2 4250082 (0: nrow: 3 rrow: 3)
----- end tree dump


Leaf block dump
===============
header address 92668508=0x586025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 7997=0x1f3d
kdxcoavs 7955
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  00 40 d9 da 00 00
row#1[8012] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 03
col 1; len 6; (6):  00 40 d9 da 00 01
row#2[7997] flag: ------, lock: 0, len=15
col 0; len 5; (5):  c4 0a 64 64 64
col 1; len 6; (6):  00 40 d9 da 00 02
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 55778 maxblk 55778

 

Leaf block dump
===============
header address 92668508=0x586025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 3
kdxcofbo 42=0x2a
kdxcofeo 7997=0x1f3d
kdxcoavs 7955
kdxlespl 0
kdxlende 1
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  00 40 d9 da 00 00
row#1[8012] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 03
col 1; len 6; (6):  00 40 d9 da 00 01
row#2[7997] flag: ------, lock: 0, len=15
col 0; len 5; (5):  c4 0a 64 64 64
col 1; len 6; (6):  00 40 d9 da 00 02
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 55778 maxblk 55778

 

Leaf block dump
===============
header address 92668508=0x586025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 4
kdxcofbo 44=0x2c
kdxcofeo 7980=0x1f2c
kdxcoavs 7936
kdxlespl 0
kdxlende 1
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  00 40 d9 da 00 00
row#1[8012] flag: ---D--, lock: 2, len=12
col 0; len 2; (2):  c1 03
col 1; len 6; (6):  00 40 d9 da 00 01
row#2[7997] flag: ------, lock: 0, len=15
col 0; len 5; (5):  c4 0a 64 64 64
col 1; len 6; (6):  00 40 d9 da 00 02
row#3[7980] flag: ------, lock: 2, len=17
col 0; len 7; (7):  c6 0a 64 64 64 64 64
col 1; len 6; (6):  00 40 d9 da 00 03
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 55778 maxblk 55778

 

Leaf block dump
===============
header address 92668508=0x586025c
kdxcolev 0
KDXCOLEV Flags = - - -
kdxcolok 0
kdxcoopc 0x80: pcode=0: iot flags=--- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 4
kdxcofbo 44=0x2c
kdxcofeo 7966=0x1f1e
kdxcoavs 7934
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 0=0x0
kdxledsz 0
kdxlebksz 8036
row#0[8024] flag: ------, lock: 0, len=12
col 0; len 2; (2):  c1 02
col 1; len 6; (6):  00 40 d9 da 00 00
row#1[7966] flag: ------, lock: 2, len=14
col 0; len 4; (4):  c3 4e 4e 4e
col 1; len 6; (6):  00 40 d9 da 00 04
row#2[7997] flag: ------, lock: 0, len=15
col 0; len 5; (5):  c4 0a 64 64 64
col 1; len 6; (6):  00 40 d9 da 00 02
row#3[7980] flag: ------, lock: 0, len=17
col 0; len 7; (7):  c6 0a 64 64 64 64 64
col 1; len 6; (6):  00 40 d9 da 00 03
----- end of leaf block dump -----
End dump data blocks tsn: 0 file#: 1 minblk 55778 maxblk 55778

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12020513/viewspace-607613/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： oracle实验记录 （dump logfile）
下一篇： oracle实验记录 （block cleanout）
请登录后发表评论 登录
全部评论
fufuh2o

注册时间：2009-06-26

  • 博文量
    182
  • 访问量
    471644

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593