ORACLE空间管理实验1:探索LMT表空间管理下数据文件头的结构及位图中区的记录方式(二)

2014-11-24 10:35:56 · 作者: · 浏览: 2
nce redo_since_read
LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [1]
Block dump from disk:
buffer tsn: 9 rdba: 0x03800002 (14/2) ------tsn: 9表空间号,rdba: 0x03800002 (14/2) 14号文件2号块
scn: 0x0000.0077dfdb seq: 0x02 flg: 0x04 tail: 0xdfdb1d02
frmt: 0x02 chkval: 0xb96b type: 0x1d=KTFB Bitmapped File Space Header --这里可以看到这个块是位图块的信息
Hex dump of block: st=0, typ_found=1
Dump of memory from 0xB6C22600 to 0xB6C24600
B6C22600 0000A21D 03800002 0077DFDB 04020000 [..........w.....]
B6C22610 0000B96B 0000000E 00000008 00000500 [k...............]
B6C22620 00000001 00000000 00000000 0000007E [............~...]
B6C22630 000004FF 00000001 0000008F 00000003 [................]
B6C22640 00000000 00000000 00000000 00000000 [................]
B6C22650 00000080 00000008 00000000 00000000 [................]
B6C22660 00000000 00000000 00000000 00000000 [................]
Repeat 504 times
B6C245F0 00000000 00000000 00000000 DFDB1D02 [................]
File Space Header Block:
Header Control:
RelFno: 14, Unit: 8, Size: 1280, Flag: 1 ---相对文件号14,Unit: 8--分配单元,每个块的大小为8192,。 Size: 1280--此数据文件包含的块数-1280*8K=10M
AutoExtend: NO, Increment: 0, MaxSize: 0 ---
Initial Area: 126, Tail: 1279, First: 1, Free: 143 ---Initial Area: 126,这是指出了有126个块用于记录位图信息-,从3-127-11G前是6个
Deallocation scn: 3.0
Header Opcode:
Save: No Pending Op
Block dump from cache:

Dump of buffer cache at level 4 for tsn=9 rdba=58720259 --TNS9是表空间号,rdba=58720259是FILE和BLOCK,RDBA计算方法如下:

BYS@ bys3>select dbms_utility.make_data_block_address(14,2) from dual;
DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS(14,2)
------------------------------------------
58720258

#######################

3号块内容--第一个位图块--区的分配在此可以观察--详见实验第二步

############
Block dump from cache:
Dump of buffer cache at level 4 for tsn=9 rdba=58720260
Block dump from disk:
buffer tsn: 9 rdba: 0x03800004 (14/4) --4号位图块,未使用。
scn: 0x0000.0077dc17 seq: 0x01 flg: 0x04 tail: 0xdc171e01
frmt: 0x02 chkval: 0x8364 type: 0x1e=KTFB Bitmapped File Space Bitmap
Hex dump of block: st=0, typ_found=1
Dump of memory from 0xB6C22600 to 0xB6C24600
B6C22600 0000A21E 03800004 0077DC17 04010000 [..........w.....]
B6C245F0 00000000 00000000 00000000 DC171E01 [................]
File Space Bitmap Block:
BitMap Control:
RelFno: 14, BeginBlock: 508032, Flag: 0, First: 0, Free: 63488 --这个位图块中没有记录有区的信息。。数据文件刚开始用,才分了一个区,用不到这个位图块来记录。
###################################################################################################
Start dump data blocks tsn: 9 file#:14 minblk 127 maxblk 131
Block dump from cache:
Dump of buffer cache at level 4 for tsn=9 rdba=58720383
Block dump from disk:
buffer tsn: 9 rdba: 0x0380007f (14/127)
scn: 0x0000.0077dd0d seq: 0x01 flg: 0x04 tail: 0xdd0d1e01
frmt: 0x02 chkval: 0x40d9 type: 0x1e=KTFB Bitmapped File Space Bitmap --这个块还是关于区的位图块
Hex dump of block: st=0, typ_found=1
Dump of memory from 0xB6BE1600 to 0xB6BE3600
Repeat 507 times
B6BE35F0 00000000 00000000 00000000 DD0D1E01 [................]
File Space Bitmap Block:
BitMap Control:
RelFno: 14, BeginBlock: 62980224, Flag: 0, First: 0, Free: 63488 --这个位图块中没有记录有区的信息。。数据文件刚开始用,才分了一个区,用不到这个位图块来记录。
################################################################################
Block dump from cache:
Dump of buffer cache at level 4 for tsn=9 rdba=58720384
BH (0x21be7f70) file#: 14 rdba: 0x03800080 (14/128) class: 8 ba: 0x218e0000