oracle實驗記錄 (dump index b*tree)
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部落格 ” ,連結:http://blog.itpub.net/12020513/viewspace-607613/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle實驗記錄 (oracle b*tree index訪問Cost計算(1))OracleIndex
- oracle實驗記錄 (dump undo)Oracle
- oracle實驗記錄 (dump logfile)Oracle
- oracle實驗記錄 (dump undo4)Oracle
- oracle實驗記錄 (dump undo3)Oracle
- oracle實驗記錄 (dump undo2)Oracle
- oracle實驗記錄 (函式index)Oracle函式Index
- B-tree and Bitmap IndexIndex
- 淺析oracle b-tree index搜尋原理OracleIndex
- oracle實驗記錄(INDEX fast full scan 的成本計算)OracleIndexAST
- What is the difference between Mysql InnoDB B+ tree index and hash index? Why does MongoDB use B-tree?MySqlIndexMongoDB
- 平衡樹索引(b-tree index)索引Index
- B-Tree Index 成本計算Index
- oracle實驗記錄 (flashback)Oracle
- oracle實驗記錄 (OMF)Oracle
- oracle實驗記錄 (NET)Oracle
- oracle實驗記錄 (audit)Oracle
- oracle實驗記錄 (oracle reset parameter)Oracle
- Oracle Data Redaction實驗記錄Oracle
- oracle實驗記錄 (block cleanout)OracleBloC
- oracle實驗記錄 (inlist card)Oracle
- oracle實驗記錄 (oracle 資料字典)Oracle
- Oracle檔案改名實驗記錄Oracle
- oracle實驗記錄 (選擇率)Oracle
- oracle實驗記錄 (事務控制)Oracle
- oracle實驗記錄 (bigfile tablespace)Oracle
- oracle實驗記錄 (恢復-redo)Oracle
- oracle實驗記錄 (expdp/impdp使用)Oracle
- oracle實驗記錄 (transport tablespace(Rman))Oracle
- oracle實驗記錄 (使用exp/imp)Oracle
- oracle實驗記錄 (CKPT的觸發)Oracle
- oracle實驗記錄 手工 duplicate database(1)OracleDatabase
- oracle實驗記錄Rman duplicate database(1)OracleDatabase
- oracle實驗記錄 (許可權,role)Oracle
- oracle實驗記錄 (SQL*PLUS 命令操作)OracleSQL
- oracle實驗記錄 (PFILE 啟動SPFILE)Oracle
- oracle實驗記錄 (SHARED server MODE)OracleServer
- oracle實驗記錄Rman duplicate database 2OracleDatabase