繼續更新一次看看，又重復了上面的步驟， 提升了 物理位置 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">（出處：清風軟件下載學院）
