Oracle数据块深入分析总结.doc

Oracle数据块深入分析总结 最近在研究块的内部结构，把文档简单整理了一下，和大家分享一下。该篇文章借助dump和BBED对数据库内部结构进行了分析，最后附加了一个用BBED解决ORA-1200错误的小例子。在总结的过程中参考了《Disassembling the Oracle Data Block》以及网上的翻译版本。 dump说明 创建表空间和测试表： create tablespace testblock datafile /opt/oracle/oradata/oradb/testblock01.dbf size 100M; create table testblock( id number, name varchar(4) ) tablespace testblock; 插入3条数据然后提交： SQL insert into testblock values(1,a); SQL insert into testblock values(2,b); SQL insert into testblock values(3,c); SQL commit; SQL select * from testblock; ??????? ID NAME ---------- -------- ???????? 1 a ???????? 2 b ???????? 3 c SQL select rowid,dbms_rowid.rowid_relative_fno(rowid) rel_fno,dbms_rowid.rowid_block_number(rowid) blockno from testblock; ROWID???????????????? REL_FNO??? BLOCKNO ------------------???????? ----------??????? ---------- AAANK4AAFAAAAAQAAA????????? 5???????? 16 AAANK4AAFAAAAAQAAB????????? 5???????? 16 AAANK4AAFAAAAAQAAC????????? 5???????? 16 我们看到这3行数据都在5号数据文件的第16个块 执行数据块dump: SQL alter system dump datafile 5 block 16; 以下是该数据块的完整dump结果： Start dump data blocks tsn: 7 file#: 5 minblk 16 maxblk 16 buffer tsn: 7 rdba: 0(5/16) scn: 0x0000.001732d3 seq: 0x01 flg: 0x04 tail: 0x32d30601 frmt: 0x02 chkval: 0x84cb type: 0x06=trans data Hex dump of block: st=0, typ_found=1 Dump of memory from 0x0CEB6400 to 0x0CEB8400 CEB6400 0000A206001732D3 [......@..2......] CEB6410 000084CB0000D2B8 001732D3? [.............2..] CEB64200032000200200006? [......2...@... .] CEB64300080020500008000? [q.......W.......] CEB6440 001732C400000279 [.2......y...Q...] CEB64500000000100000000? [x...............] CEB646000030100 0018FFFF 1F651F5E? [............^.e.] CEB6470 00001F65 1F5E0003 1F801F66 [e.....^.f.......] CEB64800000000000000000? [................] ??????? Repeat 499 times CEB83C0 022C0000 02C10202 002C6101 03C