继续更新一次看看，又重复了上面的步骤， 提升了 物理位置 Block header dump: 0x00c007a3 Object id on Block? Y seg/obj: 0x66b7 csc: 0x00.1891b98 itc: 1 flg: O typ: 1 - DATA fsl: 0 fnx: 0x0 ver: 0x01 Itl Xid Uba Flag Lck Scn/Fsc0x01 xid: 0x0006.044.000000f2 uba: 0x00801660.00da.0f --U- 2 fsc 0x0000.01891b99 data_block_dump===============
tsiz: 0x1fb8hsiz: 0x28pbl: 0x0ba76c44bdba: 0x00c007a3flag=-----------ntab=1nrow=11frre=7fsbo=0x28fSEO=0x1de0avsp=0x1e0atosp=0x1e0a0xe:pti[0] nrow=11 offs=00x12:PRi[0] offs=0x1efa0x14:pri[1] offs=0x1f0d0x16:pri[2] offs=0x1f200x18:pri[3] offs=0x1f33
0x1a:pri[4] offs=0x1f460x1c:pri[5] offs=0x1f590x1e:pri[6] offs=0x1e57 -------发生变化0x20:pri[7] sfll=-10x22:pri[8] offs=0x1f920x24:pri[9] offs=0x1fa50x26:pri[10] offs=0x1de0 ------ 发生变化block_row_dump:tab 0, row 0, @0x1efatl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 02col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 1, @0x1f0dtl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 03col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74
tab 0, row 2, @0x1f20tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 04col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 3, @0x1f33tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 05col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 4, @0x1f46tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 06col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 5, @0x1f59tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 07col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 6, @0x1e57tl: 119 fb: --H-FL-- lb: 0x1 cc: 2
col 0: [ 2] c1 14col 1: [112] ---------------数据长度大大增加 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71tab 0, row 8, @0x1f92tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 0acol 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 9, @0x1fa5tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 0bcol 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 10, @0x1de0tl: 119 fb: --H-FL-- lb: 0x1 cc: 2col 0: [ 2] c1 14
col 1: [112] ---------------数据长度大大增加 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71end_of_block_dumpEnd dump data blocks tsn: 2 file#: 3 minblk 1955 maxblk 1955 SQL> alter table tn add ( c varchar2(30)); Table altered. SQL> alter system dump datafile 3 block 1955; System altered. 给表增加一个字段，我们发现数据没有变化 Block header dump: 0x00c007a3
Object id on Block? Y seg/obj: 0x66b7 csc: 0x00.1891b98 itc: 1 flg: O typ: 1 - DATA fsl: 0 fnx: 0x0 ver: 0x01 Itl Xid Uba Flag Lck Scn/Fsc0x01 xid: 0x0006.044.000000f2 uba: 0x00801660.00da.0f --U- 2 fsc 0x0000.01891b99 data_block_dump===============tsiz: 0x1fb8hsiz: 0x28pbl: 0x0ba76c44bdba: 0x00c007a3flag=-----------ntab=1
nrow=11frre=7fsbo=0x28fseo=0x1de0avsp=0x1e0atosp=0x1e0a0xe:pti[0] nrow=11 offs=00x12:pri[0] offs=0x1efa0x14:pri[1] offs=0x1f0d0x16:pri[2] offs=0x1f200x18:pri[3] offs=0x1f330x1a:pri[4] offs=0x1f460x1c:pri[5] offs=0x1f590x1e:pri[6] offs=0x1e570x20:pri[7] sfll=-1
0x22:pri[8] offs=0x1f920x24:pri[9] offs=0x1fa50x26:pri[10] offs=0x1de0block_row_dump:tab 0, row 0, @0x1efatl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 02col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 1, @0x1f0dtl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 03col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 2, @0x1f20tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 04col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 3, @0x1f33tl: 19 fb: --H-FL-- lb: 0x0 cc: 2
col 0: [ 2] c1 05col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 4, @0x1f46tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 06col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 5, @0x1f59tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 07col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 6, @0x1e57tl: 119 fb: --H-FL-- lb: 0x1 cc: 2col 0: [ 2] c1 14col 1: [112] 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71
71 71 71 71 71 71 71 71 71 71 71 71tab 0, row 8, @0x1f92tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 0acol 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 9, @0x1fa5tl: 19 fb: --H-FL-- lb: 0x0 cc: 2col 0: [ 2] c1 0bcol 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74tab 0, row 10, @0x1de0tl: 119 fb: --H-FL-- lb: 0x1 cc: 2col 0: [ 2] c1 14col 1: [112] 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71
end_of_block_dumpEnd dump data blocks tsn: 2 file#: 3 minblk 1955 maxblk 1955 SQL> update tn set c = 'p'; 10 rows updated. SQL> commit; Commit complete. SQL> alter system dump datafile 3 block 1955; System altered. 更新增加的字段，我们发现所有的行都被提升了物理位置 Block header dump: 0x00c007a3 Object id on Block? Y seg/obj: 0x66b7 csc: 0x00.1891b9c itc: 1 flg: O typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01 Itl Xid Uba Flag Lck Scn/Fsc0x01 xid: 0x0001.00a.000000e8 uba: 0x00803494.0147.11 --U- 10 fsc 0x0000.01891b9e data_block_dump===============tsiz: 0x1fb8hsiz: 0x28pbl: 0x0ba76c44bdba: 0x00c007a3flag=-----------ntab=1nrow=11frre=7fsbo=0x28fseo=0x1c46
avsp=0x1df6tosp=0x1df60xe:pti[0] nrow=11 offs=00x12:pri[0] offs=0x1dcb ---------所有行的物理位置都发生了变化,因为原来的位置装不下多出来的数据了0x14:pri[1] offs=0x1db60x16:pri[2] offs=0x1da10x18:pri[3] offs=0x1d8c0x1a:pri[4] offs=0x1d770x1c:pri[5] offs=0x1d620x1e:pri[6] offs=0x1ce90x20:pri[7] sfll=-10x22:pri[8] offs=0x1cd40x24:pri[9] offs=0x1cbf0x26:pri[10] offs=0x1c46block_row_dump:tab 0, row 0, @0x1dcbtl: 21 fb: --H-FL-- lb: 0x1 cc: 3col 0: [ 2] c1 02
col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74col 2: [ 1] 70tab 0, row 1, @0x1db6tl: 21 fb: --H-FL-- lb: 0x1 cc: 3col 0: [ 2] c1 03col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74col 2: [ 1] 70tab 0, row 2, @0x1da1tl: 21 fb: --H-FL-- lb: 0x1 cc: 3col 0: [ 2] c1 04col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74col 2: [ 1] 70tab 0, row 3, @0x1d8ctl: 21 fb: --H-FL-- lb: 0x1 cc: 3col 0: [ 2] c1 05col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74col 2: [ 1] 70tab 0, row 4, @0x1d77tl: 21 fb: --H-FL-- lb: 0x1 cc: 3col 0: [ 2] c1 06
col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74col 2: [ 1] 70tab 0, row 5, @0x1d62tl: 21 fb: --H-FL-- lb: 0x1 cc: 3col 0: [ 2] c1 07col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74col 2: [ 1] 70tab 0, row 6, @0x1ce9tl: 121 fb: --H-FL-- lb: 0x1 cc: 3col 0: [ 2] c1 14col 1: [112] 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71col 2: [ 1] 70tab 0, row 8, @0x1cd4tl: 21 fb: --H-FL-- lb: 0x1 cc: 3col 0: [ 2] c1 0a
col 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74col 2: [ 1] 70tab 0, row 9, @0x1cbftl: 21 fb: --H-FL-- lb: 0x1 cc: 3col 0: [ 2] c1 0bcol 1: [12] 77 77 77 65 65 65 72 72 72 74 74 74col 2: [ 1] 70tab 0, row 10, @0x1c46tl: 121 fb: --H-FL-- lb: 0x1 cc: 3col 0: [ 2] c1 14col 1: [112] 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71 71col 2: [ 1] 70end_of_block_dumpEnd dump data blocks tsn: 2 file#: 3 minblk 1955 maxblk 1955 right">（出处：清风软件下载学院）
