Trace file /u01/app/oracle/diag/rdbms/test/test/trace/test_ora_22587.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: test
Release: 3.8.13-118.2.2.el6uek.x86_64
Version: #2 SMP Thu Dec 10 11:06:02 PST 2015
Machine: x86_64
VM name: VMWare Version: 6
Instance name: test
Redo thread mounted by this instance: 1
Oracle process number: 29
Unix process pid: 22587, image: oracle@test
*** 2016-02-16 16:17:44.447
*** SESSION ID:(69.20173) 2016-02-16 16:17:44.447
*** CLIENT ID:() 2016-02-16 16:17:44.447
*** SERVICE NAME:(test) 2016-02-16 16:17:44.447
*** MODULE NAME:(PL/SQL Developer) 2016-02-16 16:17:44.447
*** ACTION NAME:(SQL 窗口 - 新建) 2016-02-16 16:17:44.447
Start dump data blocks tsn: 6 file#:5 minblk 135 maxblk 135
Block dump from cache:
Dump of buffer cache at level 4 for tsn=6 rdba=20971655
BH (0xaafd88c8) file#: 5 rdba: 0x01400087 (5/135) class: 1 ba: 0xaabf6000
set: 12 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
dbwrid: 0 obj: 87984 objn: 87984 tsn: 6 afn: 5 hint: f
hash: [0xba7919f0,0xba7919f0] lru: [0x84ff25a8,0xabfc6dc0]
ckptq: [NULL] fileq: [NULL] objq: [0x84ff25d0,0xb6eece40] objaq: [0x84ff25e0,0xb6eece30]
st: XCURRENT md: NULL fpin: 'ktspbwh2: ktspfmdb' tch: 2
flags: block_written_once redo_since_read
LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [1]
Block dump from disk:
buffer tsn: 6 rdba: 0x01400087 (5/135)
//tsn(表空间编码,这里是指6号表空间）--不要让第5个数据文件给混淆，select tablespace_name from dba_tablespaces;
//rdba(相关数据库块地址,对应rowid的rfile# ,block#,使用dbms_utility包进行转化,可参见rowid这节)
//01400087 化成二进制前10位表示数据数据文件，后22位表示数据块
scn: 0x0000.00384e39 seq: 0x01 flg: 0x06 tail: 0x4e390601
//scn(数据块SCN 前两个字节0000 SCN Wrap,后4个字节SCN BASE bbed-offset:0x8)
//seq(数据块状态bbed-offset:0x14 用来改变坏块状态)
//flg(
1 = virgin block----新建块
2 = last change to the block was for a cleanout operation----数据块延迟清洗推进scn和seq）
4 = checksum value is set----设置校验和
8 = temporary data----临时块
6 的时候是 2,4 的组合 bbed-offset:0x15)
//trail(用来检查一致性的值
//tail check的组成：SCN Base的低2个字节+type+seq。即tail: 0x4e390601 =4e39+06+01)
frmt: 0x02 chkval: 0x4efc type: 0x06=trans data
//frmt 表示块格式，01表示oracle 7,02表示oracle 8+
//chkval 块检查值，db_block_checksum=TRUE,数据块读入buffer和写回数据文件之前都要做检查计算，如果计算值与数据块中记录的计算值不匹配就会标记该块是坏块.)
//type(块类型，
// Header Block Types
// ID Type
// 01 Undo segment header
// 02 Undo data block
// 03 Save undo header
// 04 Save undo data block
// 05 Data segment header (temp, index, data and so on)
// 06 KTB managed data block (with ITL)
// 07 Temp table data block (no ITL)
// 08 Sort Key
// 09 Sort Run
// 10 Segment free list block
// 11 Data file header )
----空闲区，数据区
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00007F57B7CEC000 to 0x00007F57B7CEE000
7F57B7CEC000 0000A206 01400087 00384E39 06010000 [......@.9N8.....]
7F57B7CEC010 00004EFC 00150001 000157B0 00384E36 [.N.......W..6N8.]
7F57B7CEC020 1FE80000 00321F02 01400080 001F000A [......2...@.....]
7F57B7CEC030 00000A39 00C00332 000202EB 00002001 [9...2........ ..]
7F57B7CEC040 00384E39 00000000 00000000 00000000 [9N8.............]
7F57B7CEC050 00000000 00000000 00000000 00000000 [................]
7F57B7CEC060 00000000 00010100 0014FFFF 1F7B1F92 [..............{.]
7F57B7CEC070 00001F7B 1F920001 00000000 00000000 [{...............]
7F57B7CEC080 00000000 00008000 00000000 00020100 [................]
7F57B7CEC090 00160000 003B0049 0000003B FFFF0002 [....I.;.;.......]
7F57B7CEC0A0 0AEC0049 0A500AA8 099809FC 08B00918 [I.....P.........]
7F57B7CEC0B0 07C00830 07100764 064406AC 05A005E4 [0...d.....D.....]
7F57B7CEC0C0 04F00548 045C04A0 03AC0404 0318035C [H.....\.....\...]
7F57B7CEC0D0 026802C0 01000618 0A1F19FE 0A2F0A2F [..h........././.]
7F57B7CEC0E0 0A2F0A2F 0A320A32 0A320A32 0A330A33 [/./.2.2.2.2.3.3.]
7F57B7CEC0F0 0A330A33 0A340A34 0A340A34 0A350A35 [3.3.4.4.4.4.5.5.]
7F57B7CEC100 0A350A35 0A380A38 0A380A38 0A390A39 [5.5.8.8.8.8.9.9.]
7F57B7CEC110 0A390A39 0A3A0A3A 0A3A0A3A 0A3B0A3B [9.9.:.:.:.:.;.;.]
7F57B7CEC120 0A3B0A3B 0A3E0A3E 0A3E0A3E 0A3F0A3F [;.;.>.>.>.>.?.?.]
7F57B7CEC130 0A3F0A3F 0A400A40 0A400A40 0A430A43 [?.?.@.@.@.@.C.C.]
7F57B7CEC140 0A430A43 0A440A44 0A440A44 0A450A45 [C.C.D.D.D.D.E.E.]
7F57B7CEC150 0A450A45 0A480A48 0A480A48 0A480A48 [E.E.H.H.H.H.H.H.]
7F57B7CEC160 0A480A48 0A480A48 0A480A48 0A4C0A49 [H.H.H.H.H.H.I.L.]
7F57B7CEC170 0A4C0A4C 0A4C0A4C 0A4C0A4C 0A4D0A4C [L.L.L.L.L.L.L.M.]
7F57B7CEC180 0A4F0A4F 0A4F0A4F 0A4F0A4F 0A4F0A4F [O.O.O.O.O.O.O.O.]
Repeat 1 times
7F57B7CEC1A0 0A520A50 0A520A52 0A520A52 0A520A52 [P.R.R.R.R.R.R.R.]
7F57B7CEC1B0 0A520A52 0A520A52 0A520A52 0A520A52 [R.R.R.R.R.R.R.R.]
7F57B7CEC1C0 0A530A52 0A530A53 0A540A53 0A560A56 [R.S.S.S.S.T.V.V.]
7F57B7CEC1D0 0A560A56 0A560A56 0A560A56 0A560A56 [V.V.V.V.V.V.V.V.]
7F57B7CEC1E0 0A560A56 0A560A56 0A560A56 0A590A57 [V.V.V.V.V.V.W.Y.]
7F57B7CEC1F0 0A590A59 0A590A59 0A590A59 0A590A59 [Y.Y.Y.Y.Y.Y.Y.Y.]
7F57B7CEC200 0A590A59 0A5A0A59 0A5A0A5A 0A5B0A5A [Y.Y.Y.Z.Z.Z.Z.[.]
7F57B7CEC210 0A5D0A5D 0A5D0A5D 0A5D0A5D 0A5D0A5D [].].].].].].].].]
7F57B7CEC220 0A600A5E 0A600A60 0A600A60 0A600A60 [^.`.`.`.`.`.`.`.]
7F57B7CEC230 0A610A60 0A630A63 0A630A63 0A630A63 [`.a.c.c.c.c.c.c.]
7F57B7CEC240 0A630A63 0A640A64 0A640A64 0A650A65 [c.c.d.d.d.d.e.e.]
7F57B7CEC250 0A650A65 0A660A66 0A660A66 0A690A67 [e.e.f.f.f.f.g.i.]
7F57B7CEC260 0A690A69 0A690A69 0A690A69 0A6A0A69 [i.i.i.i.i.i.i.j.]
7F57B7CEC270 0A6A0A6A 0A6B0A6A 0A6D0A6D 0A6D0A6D [j.j.j.k.m.m.m.m.]
7F57B7CEC280 0A6D0A6D 0A6D0A6D 0A6E0A6E 0A6E0A6E [m.m.m.m.n.n.n.n.]
7F57B7CEC290 0A710A6F 0A710A71 0A710A71 0A710A71 [o.q.q.q.q.q.q.q.]
7F57B7CEC2A0 0A720A71 0A720A72 0A730A72 0A750A75 [q.r.r.r.r.s.u.u.]
7F57B7CEC2B0 0A750A75 0A750A75 0A750A75 0A760A76 [u.u.u.u.u.u.v.v.]
7F57B7CEC2C0 0A760A76 0A770A77 0A770A77 0A7A0A78 [v.v.w.w.w.w.x.z.]
7F57B7CEC2D0 0A7A0A7A 0A7A0A7A 0A7A0A7A 0A7B0A7A [z.z.z.z.z.z.z.{.]
7F57B7CEC2E0 0A7B0A7B 0A7C0A7B 0A7C0A7C 0A7D0A7C [{.{.{.|.|.|.|.}.]
7F57B7CEC2F0 0A7D0A7D 0A7E0A7D 0A7E0A7E 0A7F0A7E [}.}.}.~.~.~.~...]
7F57B7CEC300 0A7F0A7F 0A800A7F 0A800A80 0A830A80 [................]
7F57B7CEC310 0A830A83 0A840A83 0A840A84 0A850A84 [................]
7F57B7CEC320 0A850A85 0A860A85 0A860A86 0A870A86 [................]
7F57B7CEC330 0A870A87 0A880A87 0A880A88 0A8B0A88 [................]
7F57B7CEC340 0A8B0A8B 0A8C0A8B 0A8C0A8C 0A8D0A8C [................]
7F57B7CEC350 0A8D0A8D 0A8E0A8D 0A8E0A8E 0A8F0A8E [................]
7F57B7CEC360 0A8F0A8F 0A900A8F 0A900A90 0A910A90 [................]
7F57B7CEC370 0A910A91 0A920A91 0A920A92 0A930A92 [................]
7F57B7CEC380 0A930A93 0A940A93 0A940A94 0A950A94 [................]
7F57B7CEC390 0A950A95 0A960A95 0A960A96 0A970A96 [................]
7F57B7CEC3A0 0A970A97 0A980A97 0A980A98 0A9B0A98 [................]
7F57B7CEC3B0 0A9B0A9B 0A9C0A9B 0A9C0A9C 0A9D0A9C [................]
7F57B7CEC3C0 0A9D0A9D 0A9E0A9D 0A9E0A9E 0A9F0A9E [................]
7F57B7CEC3D0 0A9F0A9F 0AA20A9F 0AA20AA2 0AA30AA2 [................]
7F57B7CEC3E0 0AA30AA3 0AA40AA3 0AA40AA4 0AA50AA4 [................]
7F57B7CEC3F0 0AA50AA5 0AA60AA5 0AA60AA6 0AA90AA6 [................]
7F57B7CEC400 0AA90AA9 0AAA0AA9 0AAA0AAA 0AAB0AAA [................]
7F57B7CEC410 0AAB0AAB 0AAC0AAB 0AAC0AAC 0AAD0AAC [................]
7F57B7CEC420 0AAD0AAD 0AAE0AAD 0AAE0AAE 0AAF0AAE [................]
7F57B7CEC430 0AAF0AAF 0AB20AAF 0AB20AB2 0AB30AB2 [................]
7F57B7CEC440 0AB30AB3 0AB40AB3 0AB40AB4 0AB50AB4 [................]
7F57B7CEC450 0AB50AB5 0AB60AB5 0AB60AB6 0AB70AB6 [................]
7F57B7CEC460 0AB70AB7 0AB80AB7 0AB80AB8 0AB90AB8 [................]
7F57B7CEC470 0AB90AB9 0ABC0AB9 0ABC0ABC 0ABD0ABC [................]
7F57B7CEC480 0ABD0ABD 0ABE0ABD 0ABE0ABE 0ABF0ABE [................]
7F57B7CEC490 0ABF0ABF 0AC00ABF 0AC00AC0 0AC10AC0 [................]
7F57B7CEC4A0 0AC10AC1 0AC20AC1 0AC20AC2 0AC30AC2 [................]
7F57B7CEC4B0 0AC30AC3 0AD90AC3 0AD90AD9 0ADA0AD9 [................]
7F57B7CEC4C0 0ADA0ADA 0ADB0ADA 0ADB0ADB 0ADC0ADB [................]
7F57B7CEC4D0 0ADC0ADC 0ADC0ADC 0ADD0ADD 0ADD0ADD [................]
7F57B7CEC4E0 0ADE0ADD 0ADE0ADE 0ADF0ADE 0ADF0ADF [................]
7F57B7CEC4F0 0AE00ADF 0AE00AE0 0AEB0AE0 0AEB0AEB [................]
7F57B7CEC500 0AEC0AEB 0AEC0AEC 0AED0AEC 0AED0AED [................]
7F57B7CEC510 0AEE0AED 0AEE0AEE 0AEF0AEE 0AEF0AEF [................]
7F57B7CEC520 0AEF0AEF 0AF00AF0 0AF00AF0 0AF10AF0 [................]
7F57B7CEC530 0AF10AF1 0AF10AF1 0AF90AF9 0AF90AF9 [................]
7F57B7CEC540 0AFA0AFA 0AFA0AFA 0AFB0AFB 0AFB0AFB [................]
7F57B7CEC550 0AFC0AFC 0AFC0AFC 0AFD0AFD 0AFD0AFD [................]
7F57B7CEC560 0AFE0AFE 0AFE0AFE 0B060AFE 0B060B06 [................]
7F57B7CEC570 0B070B06 0B070B07 0B080B07 0B080B08 [................]
7F57B7CEC580 0B090B08 0B090B09 0B0A0B09 0B0A0B0A [................]
7F57B7CEC590 0B0B0B0A 0B0B0B0B 0B0C0B0B 0B0C0B0C [................]
7F57B7CEC5A0 0B0D0B0C 0B0D0B0D 0B140B0D 0B140B14 [................]
7F57B7CEC5B0 0B150B14 0B150B15 0B160B15 0B160B16 [................]
7F57B7CEC5C0 0B170B16 0B170B17 0B1D0B17 0B1D0B1D [................]
7F57B7CEC5D0 0B1E0B1D 0B1E0B1E 0B1F0B1E 0B1F0B1F [................]
7F57B7CEC5E0 0B200B1F 0B200B20 0B200B20 0B200B20 [.. . . . . . . .]
7F57B7CEC5F0 0B210B20 0B210B21 0B210B21 0B210B21 [ .!.!.!.!.!.!.!.]
7F57B7CEC600 0B220B21 0B220B22 0B280B22 0B280B28 [!.".".".".(.(.(.]
7F57B7CEC610 0B290B28 0B290B29 0B290B29 0B290B29 [(.).).).).).).).]
7F57B7CEC620 0B2A0B29 0B2A0B2A 0B2A0B2A 0B2A0B2A [).*.*.*.*.*.*.*.]
7F57B7CEC630 0B2B0B2A 0B2B0B2B 0B300B2B 0B300B30 [*.+.+.+.+.0.0.0.]
7F57B7CEC640 0B310B30 0B360B36 0B360B36 0B370B37 [0.1.6.6.6.6.7.7.]
7F57B7CEC650 0B370B37 0B380B38 0B380B38 0B3E0B39 [7.7.8.8.8.8.9.>.]
7F57B7CEC660 0B3E0B3E 0B3F0B3E 0B3F0B3F 0B400B3F [>.>.>.?.?.?.?.@.]
7F57B7CEC670 0B400B40 0B410B40 0B460B46 0B460B46 [@.@.@.A.F.F.F.F.]
7F57B7CEC680 0B470B47 0B470B47 0B480B48 0B480B48 [G.G.G.G.H.H.H.H.]
7F57B7CEC690 0B4B0B49 0B4B0B4B 0B4C0B4B 0B4C0B4C [I.K.K.K.K.L.L.L.]
7F57B7CEC6A0 0B4D0B4C 0B4F0B4F 0B4F0B4F 0B500B50 [L.M.O.O.O.O.P.P.]
7F57B7CEC6B0 0B500B50 0B510B51 0B510B51 0B520B52 [P.P.Q.Q.Q.Q.R.R.]
7F57B7CEC6C0 0B520B52 0B530B53 0B530B53 0B560B54 [R.R.S.S.S.S.T.V.]
7F57B7CEC6D0 0B560B56 0B570B56 0B570B57 0B580B57 [V.V.V.W.W.W.W.X.]
7F57B7CEC6E0 0B580B58 0B580B58 0B5A0B5A 0B5A0B5A [X.X.X.X.Z.Z.Z.Z.]
7F57B7CEC6F0 0B5B0B5B 0B5B0B5B 0B5C0B5C 0B5C0B5C [[.[.[.[.\.\.\.\.]
7F57B7CEC700 0B610B5C 0B610B61 0B620B61 0B620B62 [\.a.a.a.a.b.b.b.]
7F57B7CEC710 0B640B62 0B6A0B6A 0B6A0B6A 0B6A0B6A [b.d.j.j.j.j.j.j.]
7F57B7CEC720 0B6A0B6A 0B6A0B6A 0B6A0B6A 0B700B6B [j.j.j.j.j.j.k.p.]
7F57B7CEC730 0B700B70 0B700B70 0B700B70 0B710B70 [p.p.p.p.p.p.p.q.]
7F57B7CEC740 0B710B71 0B720B71 0B720B72 0B720B72 [q.q.q.r.r.r.r.r.]
7F57B7CEC750 0B780B78 0B780B78 0B780B78 0B780B78 [x.x.x.x.x.x.x.x.]
7F57B7CEC760 0B790B79 0B790B79 0B990B79 0B990B99 [y.y.y.y.y.......]
7F57B7CEC770 0B990B99 0B990B99 0B990B99 0B990B99 [................]
7F57B7CEC780 0B9A0B99 0B9A0B9A 0B9A0B9A 0BAD0BAD [................]
7F57B7CEC790 0BAD0BAD 0BAD0BAD 0BAD0BAD 0BAD0BAD [................]
7F57B7CEC7A0 0BAD0BAD 0BC00BAD 0BC00BC0 0BC00BC0 [................]
7F57B7CEC7B0 0BC00BC0 0BC00BC0 0BC00BC0 0BC00BC0 [................]
7F57B7CEC7C0 0BD30BD3 0BD30BD3 0BD30BD3 0BD30BD3 [................]
7F57B7CEC7D0 0BD30BD3 0BD30BD3 0BD40BD4 0BD40BD4 [................]
7F57B7CEC7E0 0BE70BE7 0BE70BE7 0BE70BE7 0BE70BE7 [................]
7F57B7CEC7F0 0BE70BE7 0BE70BE7 0BE80BE8 0BE80BE8 [................]
7F57B7CEC800 0BFD0BFD 0BFD0BFD 0BFD0BFD 0BFD0BFD [................]
7F57B7CEC810 0BFD0BFD 0BFD0BFD 0BFE0BFE 0BFE0BFE [................]
7F57B7CEC820 0C0F0C0F 0C0F0C0F 0C0F0C0F 0C0F0C0F [................]
7F57B7CEC830 0C0F0C0F 0C0F0C0F 0C230C23 0C230C23 [........#.#.#.#.]
7F57B7CEC840 0C230C23 0C230C23 0C340C23 0C340C34 [#.#.#.#.#.4.4.4.]
7F57B7CEC850 0C340C34 0C420C42 0C420C42 0C420C42 [4.4.B.B.B.B.B.B.]
7F57B7CEC860 0C420C42 0C420C42 0C420C42 0C500C42 [B.B.B.B.B.B.B.P.]
7F57B7CEC870 0C500C50 0C500C50 0C500C50 0C500C50 [P.P.P.P.P.P.P.P.]
7F57B7CEC880 0C500C50 0C500C50 0C5D0C5D 0C5D0C5D [P.P.P.P.].].].].]
7F57B7CEC890 0C5D0C5D 0C5D0C5D 0C720C5D 0C720C72 [].].].].].r.r.r.]
7F57B7CEC8A0 0C720C72 0C720C72 0C720C72 0C720C72 [r.r.r.r.r.r.r.r.]
7F57B7CEC8B0 0C730C72 0C730C73 0C730C73 0C730C73 [r.s.s.s.s.s.s.s.]
7F57B7CEC8C0 0C740C73 0C740C74 0C8B0C74 0C8B0C8B [s.t.t.t.t.......]
7F57B7CEC8D0 0C8C0C8B 0C8C0C8C 0C8C0C8C 0C8C0C8C [................]
7F57B7CEC8E0 0C8C0C8C 0C8C0C8C 0C8D0C8C 0C8D0C8D [................]
7F57B7CEC8F0 0C8D0C8D 0C8D0C8D 0C8E0C8D 0CA60CA6 [................]
7F57B7CEC900 0CA60CA6 0CA70CA7 0CA70CA7 0CB90CA8 [................]
7F57B7CEC910 0CB90CB9 0CBA0CB9 0CBA0CBA 0CBB0CBA [................]
7F57B7CEC920 0CBB0CBB 0CBC0CBB 0CBC0CBC 0CBD0CBC [................]
7F57B7CEC930 0CBD0CBD 0CBD0CBD 00010001 01D101D5 [................]
7F57B7CEC940 01D101D1 024101D1 023E023E 023E023E [......A.>.>.>.>.]
7F57B7CEC950 027D0280 027D027D 02BD027D 02BB02BB [..}.}.}.}.......]
7F57B7CEC960 02BB02BB 02F502F6 02F502F5 031602F5 [................]
7F57B7CEC970 03140314 03140314 03220323 03220322 [........#.".".".]
7F57B7CEC980 03340322 03320332 03320332 03670369 [".4.2.2.2.2.i.g.]
7F57B7CEC990 03670367 03A40367 03A103A1 03A103A1 [g.g.g...........]
7F57B7CEC9A0 03EA03ED 03EA03EA 043703EA 04360436 [..........7.6.6.]
7F57B7CEC9B0 04360436 046D0442 046B046B 046B046B [6.6.B.m.k.k.k.k.]
7F57B7CEC9C0 04A804A9 04A804A8 04B604A8 04B404B4 [................]
7F57B7CEC9D0 04B404B4 04C804CA 04C804C8 04DB04C8 [................]
7F57B7CEC9E0 04DA04DA 04DA04DA 04E704E8 04E704E7 [................]
7F57B7CEC9F0 04EF04E7 04EE04EE 04EE04EE 04FB04FC [................]
7F57B7CECA00 04FB04FB 051D04FB 051C051C 051C051C [................]
7F57B7CECA10 05300531 05300530 053C0530 053B053B [1.0.0.0.0.<.;.;.]
7F57B7CECA20 053B053B 054C0550 054C054C 0560054C [;.;.P.L.L.L.L.`.]
7F57B7CECA30 055B055B 055B055B 0569056D 05690569 [[.[.[.[.m.i.i.i.]
7F57B7CECA40 05750569 05740574 05740574 057C057D [i.u.t.t.t.t.}.|.]
7F57B7CECA50 057C057C 0586057C 05850585 05850585 [|.|.|...........]
7F57B7CECA60 058C0591 058C058C 05AA058C 05A505A5 [................]
7F57B7CECA70 05A505A5 05BE05C4 05BE05BE 05E205BE [................]
7F57B7CECA80 05DC05DC 05DC05DC 05F905FF 05F905F9 [................]
7F57B7CECA90 061C05F9 06160616 06160616 06350636 [............6.5.]
7F57B7CECAA0 06350635 06490635 06430643 06430643 [5.5.5.I.C.C.C.C.]
7F57B7CECAB0 06610667 06610661 06840661 067E067E [g.a.a.a.a...~.~.]
7F57B7CECAC0 067E067E 069B06A1 069B069B 06B9069B [~.~.............]
7F57B7CECAD0 06B806B8 06B806B8 06BE06BF 06BE06BE [................]
7F57B7CECAE0 06C406BE 06C306C3 06C306C3 06C906CB [................]
7F57B7CECAF0 06C906C9 06F806C9 06F706F7 06F706F7 [................]
7F57B7CECB00 07020703 07020702 07160702 07150715 [................]
7F57B7CECB10 07150715 0729072A 07290729 07380729 [....*.).).).).8.]
7F57B7CECB20 07370737 07370737 073E073F 073E073E [7.7.7.7.?.>.>.>.]
7F57B7CECB30 074D073E 074C074C 074C074C 07520753 [>.M.L.L.L.L.S.R.]
7F57B7CECB40 07520752 075D0752 075B075B 075B075B [R.R.R.].[.[.[.[.]
7F57B7CECB50 07710772 07710771 07770771 07760776 [r.q.q.q.q.w.v.v.]
7F57B7CECB60 07760776 077B077D 077B077B 0789077B [v.v.}.{.{.{.{...]
7F57B7CECB70 07870787 07870787 07910793 07910791 [................]
7F57B7CECB80 079D0791 079B079B 079B079B 07A707A8 [................]
7F57B7CECB90 07A707A7 07B507A7 07B407B4 07B407B4 [................]
7F57B7CECBA0 07BC07C1 07BC07BC 07D707BC 07D607D6 [................]
7F57B7CECBB0 07D607D6 07DE07E0 07DE07DE 07EC07DE [................]
7F57B7CECBC0 07EA07EA 07EA07EA 07FA07FC 07FA07FA [................]
7F57B7CECBD0 080E07FA 080D080D 080D080D 0819081A [................]
7F57B7CECBE0 08190819 08270819 08260826 08260826 [......'.&.&.&.&.]
7F57B7CECBF0 0839083A 08390839 08480839 08470847 [:.9.9.9.9.H.G.G.]
7F57B7CECC00 08470847 085E085F 085E085E 0876085E [G.G._.^.^.^.^.v.]
7F57B7CECC10 08750875 08750875 006809F3 00920092 [u.u.u.u...h.....]
7F57B7CECC20 009C009C 00A0009C 00A000A0 01E800A0 [................]
7F57B7CECC30 01E601E7 01E201E5 01E001E1 01FF0200 [................]
7F57B7CECC40 01FD01FE 01FA01FB 01F801FA 021901F7 [................]
7F57B7CECC50 02170218 02140216 02130213 020F0210 [................]
7F57B7CECC60 02360237 02340235 02300232 022E022F [7.6.5.4.2.0./...]
7F57B7CECC70 022B022E 0000022A 00000000 00000000 [..+.*...........]
7F57B7CECC80 00000000 00000000 00000000 00000000 [................]
Repeat 8 times
7F57B7CECD10 00000000 01D50000 02530253 024F0251 [........S.S.Q.O.]
7F57B7CECD20 0258024E 02730273 026E0271 0278026D [N.X.s.s.q.n.m.x.]
7F57B7CECD30 00000000 00000000 00000000 00000000 [................]
Repeat 8 times
7F57B7CECDC0 00000000 00000000 028B0241 0287028A [........A.......]
7F57B7CECDD0 02970298 00000296 00000000 00000000 [................]
7F57B7CECDE0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CECE00 00000000 02CF0280 02CD02CE 02ED02ED [................]
7F57B7CECE10 000002EC 00000000 00000000 00000000 [................]
7F57B7CECE20 00000000 00000000 00000000 00000000 [................]
Repeat 6 times
7F57B7CECE90 02BD0000 02FB02FC 030B030D 00000000 [................]
7F57B7CECEA0 00000000 00000000 031D02F6 031B031C [................]
7F57B7CECEB0 00000000 00000000 00000000 03160000 [................]
7F57B7CECEC0 0329032A 00000000 00000000 00000000 [*.).............]
7F57B7CECED0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CECEF0 033C0323 0339033A 034C0350 035E034A [#.<.:.9.P.L.J.^.]
7F57B7CECF00 0358035A 00000000 00000000 00000000 [Z.X.............]
7F57B7CECF10 00000000 00000000 03720334 036F0370 [........4.r.p.o.]
7F57B7CECF20 03830387 037D0381 03930397 00000391 [......}.........]
7F57B7CECF30 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CECF50 03B10369 03AE03AF 03CA03AA 03C403C6 [i...............]
7F57B7CECF60 03DF03C0 03D903DB 000003D4 00000000 [................]
7F57B7CECF70 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CECF90 00000000 03A40000 03FA03FC 03F403F9 [................]
7F57B7CECFA0 04140418 040D0412 042C0430 0424042A [........0.,.*.$.]
7F57B7CECFB0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
7F57B7CECFE0 00000000 00000000 03ED0000 043C043D [............=.<.]
7F57B7CECFF0 00000000 00000000 00000000 04370000 [..............7.]
7F57B7CED000 04730477 04720472 04860486 00000485 [w.s.r.r.........]
7F57B7CED010 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED030 00000000 00000000 00000000 046D0000 [..............m.]
7F57B7CED040 04AE04AF 00000000 00000000 00000000 [................]
7F57B7CED050 04A90000 04BD04C1 000004BB 00000000 [................]
7F57B7CED060 00000000 00000000 04D504B6 04CF04D1 [................]
7F57B7CED070 00000000 00000000 00000000 04CA0000 [................]
7F57B7CED080 04E104E2 00000000 00000000 00000000 [................]
7F57B7CED090 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED0B0 00000000 00000000 00000000 000004DB [................]
7F57B7CED0C0 00000000 00000000 00000000 04F304E8 [................]
7F57B7CED0D0 000004F2 00000000 00000000 00000000 [................]
7F57B7CED0E0 00000000 00000000 00000000 04EF0000 [................]
7F57B7CED0F0 05070507 05160516 00000000 00000000 [................]
7F57B7CED100 00000000 00000000 00000000 00000000 [................]
Repeat 6 times
7F57B7CED170 00000000 00000000 04FC0000 05210522 [............".!.]
7F57B7CED180 0529052A 00000000 00000000 00000000 [*.).............]
7F57B7CED190 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED1B0 0534051D 00000537 00000000 00000000 [..4.7...........]
7F57B7CED1C0 00000000 05420531 00000000 00000000 [....1.B.........]
7F57B7CED1D0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
7F57B7CED210 00000000 00000000 00000000 0553053C [............<.S.]
7F57B7CED220 05580553 00000558 00000000 00000000 [S.X.X...........]
7F57B7CED230 00000000 00000000 05500000 05640564 [..........P.d.d.]
7F57B7CED240 00000564 00000000 00000000 00000000 [d...............]
7F57B7CED250 00000000 00000000 00000000 00000000 [................]
7F57B7CED260 00000000 05700560 00000570 00000000 [....`.p.p.......]
7F57B7CED270 00000000 00000000 0000056D 00000000 [........m.......]
7F57B7CED280 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED2A0 00000000 00000000 05750000 00000582 [..........u.....]
7F57B7CED2B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED2D0 00000000 00000000 00000000 057D0000 [..............}.]
7F57B7CED2E0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
7F57B7CED310 00000000 05860000 059D05A0 0599059C [................]
7F57B7CED320 05950598 00000594 00000000 00000000 [................]
7F57B7CED330 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED350 00000000 05B90591 05B505B6 05B105B2 [................]
7F57B7CED360 05AD05AE 00000000 00000000 00000000 [................]
7F57B7CED370 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED390 05AA0000 05D605D6 05D405D6 05CF05D0 [................]
7F57B7CED3A0 05CB05CC 05C705C8 00000000 00000000 [................]
7F57B7CED3B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED3D0 00000000 05C40000 05F405F4 05F205F4 [................]
7F57B7CED3E0 05ED05EE 05E905EA 05E505E6 00000000 [................]
7F57B7CED3F0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED410 00000000 00000000 05E20000 06110611 [................]
7F57B7CED420 060B060F 0607060A 06030606 00000602 [................]
7F57B7CED430 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED450 00000000 00000000 00000000 062E05FF [................]
7F57B7CED460 062C062E 06270628 06230624 061F0620 [..,.(.'.$.#. ...]
7F57B7CED470 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED490 00000000 00000000 00000000 061C0000 [................]
7F57B7CED4A0 063C063D 00000638 00000000 00000000 [=.<.8...........]
7F57B7CED4B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED4D0 065B0636 065B065B 06550659 06510654 [6.[.[.[.Y.U.T.Q.]
7F57B7CED4E0 064D0650 0000064C 00000000 00000000 [P.M.L...........]
7F57B7CED4F0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED510 00000000 06790649 06790679 06730677 [....I.y.y.y.w.s.]
7F57B7CED520 066F0672 066B066E 0000066A 00000000 [r.o.n.k.j.......]
7F57B7CED530 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED550 00000000 00000000 06960667 06940696 [........g.......]
7F57B7CED560 068F0690 068B068C 06870688 00000000 [................]
7F57B7CED570 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED590 00000000 00000000 06840000 06B306B3 [................]
7F57B7CED5A0 06AD06B1 06A906AC 06A506A8 000006A4 [................]
7F57B7CED5B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED5D0 00000000 00000000 00000000 000006A1 [................]
7F57B7CED5E0 00000000 000006B9 00000000 000006BF [................]
7F57B7CED5F0 00000000 00000000 00000000 06EF06C4 [................]
7F57B7CED600 06E906EA 06DA06E0 000006D9 00000000 [................]
7F57B7CED610 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED630 00000000 00000000 06FD06CB 000006FA [................]
7F57B7CED640 00000000 00000000 00000000 070906F8 [................]
7F57B7CED650 00000706 00000000 00000000 00000000 [................]
7F57B7CED660 00000000 00000000 00000000 07030000 [................]
7F57B7CED670 071A071D 00000000 00000000 00000000 [................]
7F57B7CED680 00000000 00000000 00000000 00000000 [................]
7F57B7CED690 07300716 0000072F 00000000 00000000 [..0./...........]
7F57B7CED6A0 00000000 073B072A 00000000 00000000 [....*.;.........]
7F57B7CED6B0 00000000 07380000 07430744 00000000 [......8.D.C.....]
7F57B7CED6C0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
7F57B7CED6F0 074F073F 00000000 074D0000 07550756 [?.O.......M.V.U.]
7F57B7CED700 00000000 00000000 00000000 07530000 [..............S.]
7F57B7CED710 07640766 00000763 00000000 00000000 [f.d.c...........]
7F57B7CED720 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
7F57B7CED750 00000000 075D0000 07730773 00000000 [......].s.s.....]
7F57B7CED760 00000000 00000000 07720000 07780778 [..........r.x.x.]
7F57B7CED770 00000000 07770000 07840784 07820783 [......w.........]
7F57B7CED780 00000000 00000000 00000000 00000000 [................]
7F57B7CED790 00000000 078E077D 078A078D 0000078A [....}...........]
7F57B7CED7A0 00000000 07980789 07940797 00000794 [................]
7F57B7CED7B0 00000000 07A40793 07A007A3 0000079F [................]
7F57B7CED7C0 00000000 00000000 00000000 07AD079D [................]
7F57B7CED7D0 000007AB 00000000 00000000 00000000 [................]
7F57B7CED7E0 07B807A8 00000000 00000000 00000000 [................]
7F57B7CED7F0 00000000 00000000 00000000 00000000 [................]
7F57B7CED800 07C607B5 07C407C5 07CC07CD 07D307CB [................]
7F57B7CED810 000007D2 00000000 07DA07C1 000007D9 [................]
7F57B7CED820 00000000 00000000 00000000 00000000 [................]
7F57B7CED830 00000000 00000000 07E707D7 07E607E7 [................]
7F57B7CED840 000007E5 00000000 07F707E0 07F507F6 [................]
7F57B7CED850 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED870 00000000 00000000 080A07EC 08080809 [................]
7F57B7CED880 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED8A0 00000000 00000000 081607FC 00000815 [................]
7F57B7CED8B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED8D0 0823080E 00000822 00000000 00000000 [..#."...........]
7F57B7CED8E0 00000000 00000000 00000000 00000000 [................]
7F57B7CED8F0 00000000 00000000 082C081A 0833082C [..........,.,.3.]
7F57B7CED900 00000833 00000000 00000000 00000000 [3...............]
7F57B7CED910 083C0827 0842083C 00000842 00000000 ['.<.<.B.B.......]
7F57B7CED920 00000000 00000000 084B083A 0855084B [........:.K.K.U.]
7F57B7CED930 00000855 00000000 00000000 00000000 [U...............]
7F57B7CED940 086F0848 00000869 00000000 00000000 [H.o.i...........]
7F57B7CED950 00000000 00000000 00000000 00000000 [................]
7F57B7CED960 085F0000 087E0884 00000000 00000000 [.._...~.........]
7F57B7CED970 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED990 00000876 00000000 00000000 00000000 [v...............]
7F57B7CED9A0 00000000 00000000 00000000 00000000 [................]
Repeat 81 times
7F57B7CEDEC0 00000000 00010001 00090001 00010001 [................]
7F57B7CEDED0 00030003 00030003 0003000A 00260019 [..............&.]
7F57B7CEDEE0 0003001A 001A0003 000F001A 00030003 [................]
7F57B7CEDEF0 000F000F 00030017 00200003 002A0020 [.......... . .*.]
7F57B7CEDF00 00030014 001D0003 0027001D 00030010 [..........'.....]
7F57B7CEDF10 00190003 00230019 00030010 00190003 [......#.........]
7F57B7CEDF20 00230019 00030010 00190003 00230019 [..#...........#.]
7F57B7CEDF30 00030013 001C0003 0026001C 00030014 [..........&.....]
7F57B7CEDF40 001D0003 0027001D 00030012 001B0003 [......'.........]
7F57B7CEDF50 0025001B 00030014 001D0003 0027001D [..%...........'.]
7F57B7CEDF60 00030013 001C0003 0026001C 0003000F [..........&.....]
7F57B7CEDF70 00180003 00220018 0003000E 00170003 [......".........]
7F57B7CEDF80 00210017 00030010 00190003 00230019 [..!...........#.]
7F57B7CEDF90 00030013 001C0003 0026001C 00030012 [..........&.....]
7F57B7CEDFA0 001B0003 0025001B 0003000F 00180003 [......%.........]
7F57B7CEDFB0 00220018 00030019 00220003 00350022 [..".......".".5.]
7F57B7CEDFC0 00030019 00220003 00340022 00030019 [......".".4.....]
7F57B7CEDFD0 00220003 00340022 00030019 00220003 [..".".4.......".]
7F57B7CEDFE0 00340022 00030019 00220003 00340022 [".4.......".".4.]
7F57B7CEDFF0 00030019 012C0034 02C10201 4E390601 [....4.,.......9N]
Block header dump: 0x01400087
Object id on Block? Y
seg/obj: 0x157b0 csc: 0x00.384e36 itc: 2 flg: E typ: 1 - DATA
brn: 0 bdba: 0x1400080 ver: 0x01 opc: 0
inc: 0 exflg: 0
//seg/obj:0x157b0 -16进制转成10进制87984
//csc: 0x00.15a3ea --cleanoutSCN,块清除时的SCN
//itc: 2 --ITL槽的数量
//flg: E --指用的是ASSM，如果是O表示用的是free list
//typ: 1 - DATA --事务型的数据块（并且：数据块头的type：0x06），存放表和索引数据。
//bdba(段头块，也就是对象的第一个块地址)
//ver(对象version）
//opc,inc(对象operation/insert count)
----ITL----
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x000a.01f.00000a39 0x00c00332.02eb.02 --U- 1 fsc 0x0000.00384e39
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
//Itl:ITL事务槽号的流水编号
//Xid：transac[X]tion identified(事务ID),由und的段号+undo的槽号+undo槽号的覆盖次数三部分组成
//Uba：undo block address记录了最近一次的该记录的前镜像（修改前的值）
//Flag：C是提交，U是快速提交，---是未提交（Flg C=Committed U=Commit Upper Bound T=Active at CSC）
//Lck：锁住了几行数据，对应有几个行锁
//Scn/Fsc：Scn=SCN of commited TX; Fsc=Free space credit(bytes)
//这里fsc 0x0000.00384e39是指提交的scn，这个值大于上次清除块时的scn=csc: 0x0000.00384e39(此scn是这个块中最小的SCN of commited)
//SCN WRAP:如果事务已提交并完成清洗，该字段保存事务提交SCN的SCN WRAP部分，否则该字段保存空闲预支字节数(FSC).比如我删除了一行数据10个字节，在事务提前前，这10个字节就属于fsc（即会写到SCN WRAP），只有事务提交后，才能正式返回到空闲空间。
//(注意：
//1、事务槽中首先记录的是Xid和Uba，只有在提交以后，当对这个数据块进行cleanout的时候，才会更新Flag和Scn。因此Oracle总是以事务表中对这个数据块的Scn以及Flag为准。
//2、一个事务开始以后，在一个数据块上得到一个事务槽，那么在这个事务提交以前，这个事务槽会一直占用，直到这个事务提交释放这个事务槽。
//3、只有在已经提交以后，这个itl事务槽中的scn才会有数值。
//4、事务是否已经提交、事务对应的SCN，这些信息都是以回滚段事务表中的为主，事务槽中的不准确
//5、事务槽中的事务id和uba地址是准确的
//6、事务槽1中的事务id和回滚段中的事务id肯定不是一样的，不同回滚段中的事务id也一定不一样。 )
-----用户数据头------
bdba: 0x01400087
//数据块的地址：16进制转成2进制取前10位二进制为文件号0000 0001 1000 ..... 0000000110=5号文件，后面剩于的部分表示块号，0X87转成10进制为135号块
data_block_dump,data header at 0x7f57b7cec064
===============
tsiz: 0x1f98
//top of size块的总大小即8088字节
hsiz: 0x14
//Data header size数据头大小即20个字节
pbl: 0x7f57b7cec064
76543210
flag=--------
ntab=1
//表数：表示这个块的数据在一个表
nrow=1
//行数：表示这个表有1行数据
frre=-1
//The first free row entry in the row directory＝you have to add one
fsbo=0x14
//Free space begin offset 叫起始空间：可以存放数据空间的起始位置（即定义了数据层中空闲空间的起始offset）
fseo=0x1f92
//Free space end offset 叫结束空间：可以存放数据空间的结束位置（即定义了数据层中空闲空间的结束offset）
avsp=0x1f7b
//Available space for new entries 叫空闲空间：定义了数据层中空闲空间的字节数
tosp=0x1f7b
//Total space 叫最终空闲空间：定义了ITL中事务提交后，数据层中空闲空间的字节数
0xe:pti[0] nrow=1 offs=0
//nrow=1 offs=0 --Table directory,整个表的开始，共一行数据 ，定义了该表在行索引中使用的插槽数
0x12:pri[0] offs=0x1f92
//Row index，叫行索引，定义了该块中包含的所有行数据的位置
-----用户数据------
block_row_dump:
tab 0, row 0, @0x1f92
//第一个表第一行的位置，定义了该表在行索引中的起始插槽号
tl: 6 fb: --H-FL-- lb: 0x1 cc: 1
//tl:6行长度6个字节
//fb: (Flag byte)--H-FL指H（Head piece of row）F(First data piece) L(Last data piece)
//lb: 0x1 --Lock byte和上面的ITL的lck相对应，表示这行是否被lock了
//cc:1 --表示有一列，即这个表有一个字段
col 0: [ 2] c1 02
//col 0: [ 2] c1 02 --第一行的第一个字段长度和值
end_of_block_dump
End dump data blocks tsn: 6 file#: 5 minblk 135 maxblk 135
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: test
Release: 3.8.13-118.2.2.el6uek.x86_64
Version: #2 SMP Thu Dec 10 11:06:02 PST 2015
Machine: x86_64
VM name: VMWare Version: 6
Instance name: test
Redo thread mounted by this instance: 1
Oracle process number: 29
Unix process pid: 22587, image: oracle@test
*** 2016-02-16 16:17:44.447
*** SESSION ID:(69.20173) 2016-02-16 16:17:44.447
*** CLIENT ID:() 2016-02-16 16:17:44.447
*** SERVICE NAME:(test) 2016-02-16 16:17:44.447
*** MODULE NAME:(PL/SQL Developer) 2016-02-16 16:17:44.447
*** ACTION NAME:(SQL 窗口 - 新建) 2016-02-16 16:17:44.447
Start dump data blocks tsn: 6 file#:5 minblk 135 maxblk 135
Block dump from cache:
Dump of buffer cache at level 4 for tsn=6 rdba=20971655
BH (0xaafd88c8) file#: 5 rdba: 0x01400087 (5/135) class: 1 ba: 0xaabf6000
set: 12 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
dbwrid: 0 obj: 87984 objn: 87984 tsn: 6 afn: 5 hint: f
hash: [0xba7919f0,0xba7919f0] lru: [0x84ff25a8,0xabfc6dc0]
ckptq: [NULL] fileq: [NULL] objq: [0x84ff25d0,0xb6eece40] objaq: [0x84ff25e0,0xb6eece30]
st: XCURRENT md: NULL fpin: 'ktspbwh2: ktspfmdb' tch: 2
flags: block_written_once redo_since_read
LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [1]
Block dump from disk:
buffer tsn: 6 rdba: 0x01400087 (5/135)
//tsn(表空间编码,这里是指6号表空间）--不要让第5个数据文件给混淆，select tablespace_name from dba_tablespaces;
//rdba(相关数据库块地址,对应rowid的rfile# ,block#,使用dbms_utility包进行转化,可参见rowid这节)
//01400087 化成二进制前10位表示数据数据文件，后22位表示数据块
scn: 0x0000.00384e39 seq: 0x01 flg: 0x06 tail: 0x4e390601
//scn(数据块SCN 前两个字节0000 SCN Wrap,后4个字节SCN BASE bbed-offset:0x8)
//seq(数据块状态bbed-offset:0x14 用来改变坏块状态)
//flg(
1 = virgin block----新建块
2 = last change to the block was for a cleanout operation----数据块延迟清洗推进scn和seq）
4 = checksum value is set----设置校验和
8 = temporary data----临时块
6 的时候是 2,4 的组合 bbed-offset:0x15)
//trail(用来检查一致性的值
//tail check的组成：SCN Base的低2个字节+type+seq。即tail: 0x4e390601 =4e39+06+01)
frmt: 0x02 chkval: 0x4efc type: 0x06=trans data
//frmt 表示块格式，01表示oracle 7,02表示oracle 8+
//chkval 块检查值，db_block_checksum=TRUE,数据块读入buffer和写回数据文件之前都要做检查计算，如果计算值与数据块中记录的计算值不匹配就会标记该块是坏块.)
//type(块类型，
// Header Block Types
// ID Type
// 01 Undo segment header
// 02 Undo data block
// 03 Save undo header
// 04 Save undo data block
// 05 Data segment header (temp, index, data and so on)
// 06 KTB managed data block (with ITL)
// 07 Temp table data block (no ITL)
// 08 Sort Key
// 09 Sort Run
// 10 Segment free list block
// 11 Data file header )
----空闲区，数据区
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00007F57B7CEC000 to 0x00007F57B7CEE000
7F57B7CEC000 0000A206 01400087 00384E39 06010000 [......@.9N8.....]
7F57B7CEC010 00004EFC 00150001 000157B0 00384E36 [.N.......W..6N8.]
7F57B7CEC020 1FE80000 00321F02 01400080 001F000A [......2...@.....]
7F57B7CEC030 00000A39 00C00332 000202EB 00002001 [9...2........ ..]
7F57B7CEC040 00384E39 00000000 00000000 00000000 [9N8.............]
7F57B7CEC050 00000000 00000000 00000000 00000000 [................]
7F57B7CEC060 00000000 00010100 0014FFFF 1F7B1F92 [..............{.]
7F57B7CEC070 00001F7B 1F920001 00000000 00000000 [{...............]
7F57B7CEC080 00000000 00008000 00000000 00020100 [................]
7F57B7CEC090 00160000 003B0049 0000003B FFFF0002 [....I.;.;.......]
7F57B7CEC0A0 0AEC0049 0A500AA8 099809FC 08B00918 [I.....P.........]
7F57B7CEC0B0 07C00830 07100764 064406AC 05A005E4 [0...d.....D.....]
7F57B7CEC0C0 04F00548 045C04A0 03AC0404 0318035C [H.....\.....\...]
7F57B7CEC0D0 026802C0 01000618 0A1F19FE 0A2F0A2F [..h........././.]
7F57B7CEC0E0 0A2F0A2F 0A320A32 0A320A32 0A330A33 [/./.2.2.2.2.3.3.]
7F57B7CEC0F0 0A330A33 0A340A34 0A340A34 0A350A35 [3.3.4.4.4.4.5.5.]
7F57B7CEC100 0A350A35 0A380A38 0A380A38 0A390A39 [5.5.8.8.8.8.9.9.]
7F57B7CEC110 0A390A39 0A3A0A3A 0A3A0A3A 0A3B0A3B [9.9.:.:.:.:.;.;.]
7F57B7CEC120 0A3B0A3B 0A3E0A3E 0A3E0A3E 0A3F0A3F [;.;.>.>.>.>.?.?.]
7F57B7CEC130 0A3F0A3F 0A400A40 0A400A40 0A430A43 [?.?.@.@.@.@.C.C.]
7F57B7CEC140 0A430A43 0A440A44 0A440A44 0A450A45 [C.C.D.D.D.D.E.E.]
7F57B7CEC150 0A450A45 0A480A48 0A480A48 0A480A48 [E.E.H.H.H.H.H.H.]
7F57B7CEC160 0A480A48 0A480A48 0A480A48 0A4C0A49 [H.H.H.H.H.H.I.L.]
7F57B7CEC170 0A4C0A4C 0A4C0A4C 0A4C0A4C 0A4D0A4C [L.L.L.L.L.L.L.M.]
7F57B7CEC180 0A4F0A4F 0A4F0A4F 0A4F0A4F 0A4F0A4F [O.O.O.O.O.O.O.O.]
Repeat 1 times
7F57B7CEC1A0 0A520A50 0A520A52 0A520A52 0A520A52 [P.R.R.R.R.R.R.R.]
7F57B7CEC1B0 0A520A52 0A520A52 0A520A52 0A520A52 [R.R.R.R.R.R.R.R.]
7F57B7CEC1C0 0A530A52 0A530A53 0A540A53 0A560A56 [R.S.S.S.S.T.V.V.]
7F57B7CEC1D0 0A560A56 0A560A56 0A560A56 0A560A56 [V.V.V.V.V.V.V.V.]
7F57B7CEC1E0 0A560A56 0A560A56 0A560A56 0A590A57 [V.V.V.V.V.V.W.Y.]
7F57B7CEC1F0 0A590A59 0A590A59 0A590A59 0A590A59 [Y.Y.Y.Y.Y.Y.Y.Y.]
7F57B7CEC200 0A590A59 0A5A0A59 0A5A0A5A 0A5B0A5A [Y.Y.Y.Z.Z.Z.Z.[.]
7F57B7CEC210 0A5D0A5D 0A5D0A5D 0A5D0A5D 0A5D0A5D [].].].].].].].].]
7F57B7CEC220 0A600A5E 0A600A60 0A600A60 0A600A60 [^.`.`.`.`.`.`.`.]
7F57B7CEC230 0A610A60 0A630A63 0A630A63 0A630A63 [`.a.c.c.c.c.c.c.]
7F57B7CEC240 0A630A63 0A640A64 0A640A64 0A650A65 [c.c.d.d.d.d.e.e.]
7F57B7CEC250 0A650A65 0A660A66 0A660A66 0A690A67 [e.e.f.f.f.f.g.i.]
7F57B7CEC260 0A690A69 0A690A69 0A690A69 0A6A0A69 [i.i.i.i.i.i.i.j.]
7F57B7CEC270 0A6A0A6A 0A6B0A6A 0A6D0A6D 0A6D0A6D [j.j.j.k.m.m.m.m.]
7F57B7CEC280 0A6D0A6D 0A6D0A6D 0A6E0A6E 0A6E0A6E [m.m.m.m.n.n.n.n.]
7F57B7CEC290 0A710A6F 0A710A71 0A710A71 0A710A71 [o.q.q.q.q.q.q.q.]
7F57B7CEC2A0 0A720A71 0A720A72 0A730A72 0A750A75 [q.r.r.r.r.s.u.u.]
7F57B7CEC2B0 0A750A75 0A750A75 0A750A75 0A760A76 [u.u.u.u.u.u.v.v.]
7F57B7CEC2C0 0A760A76 0A770A77 0A770A77 0A7A0A78 [v.v.w.w.w.w.x.z.]
7F57B7CEC2D0 0A7A0A7A 0A7A0A7A 0A7A0A7A 0A7B0A7A [z.z.z.z.z.z.z.{.]
7F57B7CEC2E0 0A7B0A7B 0A7C0A7B 0A7C0A7C 0A7D0A7C [{.{.{.|.|.|.|.}.]
7F57B7CEC2F0 0A7D0A7D 0A7E0A7D 0A7E0A7E 0A7F0A7E [}.}.}.~.~.~.~...]
7F57B7CEC300 0A7F0A7F 0A800A7F 0A800A80 0A830A80 [................]
7F57B7CEC310 0A830A83 0A840A83 0A840A84 0A850A84 [................]
7F57B7CEC320 0A850A85 0A860A85 0A860A86 0A870A86 [................]
7F57B7CEC330 0A870A87 0A880A87 0A880A88 0A8B0A88 [................]
7F57B7CEC340 0A8B0A8B 0A8C0A8B 0A8C0A8C 0A8D0A8C [................]
7F57B7CEC350 0A8D0A8D 0A8E0A8D 0A8E0A8E 0A8F0A8E [................]
7F57B7CEC360 0A8F0A8F 0A900A8F 0A900A90 0A910A90 [................]
7F57B7CEC370 0A910A91 0A920A91 0A920A92 0A930A92 [................]
7F57B7CEC380 0A930A93 0A940A93 0A940A94 0A950A94 [................]
7F57B7CEC390 0A950A95 0A960A95 0A960A96 0A970A96 [................]
7F57B7CEC3A0 0A970A97 0A980A97 0A980A98 0A9B0A98 [................]
7F57B7CEC3B0 0A9B0A9B 0A9C0A9B 0A9C0A9C 0A9D0A9C [................]
7F57B7CEC3C0 0A9D0A9D 0A9E0A9D 0A9E0A9E 0A9F0A9E [................]
7F57B7CEC3D0 0A9F0A9F 0AA20A9F 0AA20AA2 0AA30AA2 [................]
7F57B7CEC3E0 0AA30AA3 0AA40AA3 0AA40AA4 0AA50AA4 [................]
7F57B7CEC3F0 0AA50AA5 0AA60AA5 0AA60AA6 0AA90AA6 [................]
7F57B7CEC400 0AA90AA9 0AAA0AA9 0AAA0AAA 0AAB0AAA [................]
7F57B7CEC410 0AAB0AAB 0AAC0AAB 0AAC0AAC 0AAD0AAC [................]
7F57B7CEC420 0AAD0AAD 0AAE0AAD 0AAE0AAE 0AAF0AAE [................]
7F57B7CEC430 0AAF0AAF 0AB20AAF 0AB20AB2 0AB30AB2 [................]
7F57B7CEC440 0AB30AB3 0AB40AB3 0AB40AB4 0AB50AB4 [................]
7F57B7CEC450 0AB50AB5 0AB60AB5 0AB60AB6 0AB70AB6 [................]
7F57B7CEC460 0AB70AB7 0AB80AB7 0AB80AB8 0AB90AB8 [................]
7F57B7CEC470 0AB90AB9 0ABC0AB9 0ABC0ABC 0ABD0ABC [................]
7F57B7CEC480 0ABD0ABD 0ABE0ABD 0ABE0ABE 0ABF0ABE [................]
7F57B7CEC490 0ABF0ABF 0AC00ABF 0AC00AC0 0AC10AC0 [................]
7F57B7CEC4A0 0AC10AC1 0AC20AC1 0AC20AC2 0AC30AC2 [................]
7F57B7CEC4B0 0AC30AC3 0AD90AC3 0AD90AD9 0ADA0AD9 [................]
7F57B7CEC4C0 0ADA0ADA 0ADB0ADA 0ADB0ADB 0ADC0ADB [................]
7F57B7CEC4D0 0ADC0ADC 0ADC0ADC 0ADD0ADD 0ADD0ADD [................]
7F57B7CEC4E0 0ADE0ADD 0ADE0ADE 0ADF0ADE 0ADF0ADF [................]
7F57B7CEC4F0 0AE00ADF 0AE00AE0 0AEB0AE0 0AEB0AEB [................]
7F57B7CEC500 0AEC0AEB 0AEC0AEC 0AED0AEC 0AED0AED [................]
7F57B7CEC510 0AEE0AED 0AEE0AEE 0AEF0AEE 0AEF0AEF [................]
7F57B7CEC520 0AEF0AEF 0AF00AF0 0AF00AF0 0AF10AF0 [................]
7F57B7CEC530 0AF10AF1 0AF10AF1 0AF90AF9 0AF90AF9 [................]
7F57B7CEC540 0AFA0AFA 0AFA0AFA 0AFB0AFB 0AFB0AFB [................]
7F57B7CEC550 0AFC0AFC 0AFC0AFC 0AFD0AFD 0AFD0AFD [................]
7F57B7CEC560 0AFE0AFE 0AFE0AFE 0B060AFE 0B060B06 [................]
7F57B7CEC570 0B070B06 0B070B07 0B080B07 0B080B08 [................]
7F57B7CEC580 0B090B08 0B090B09 0B0A0B09 0B0A0B0A [................]
7F57B7CEC590 0B0B0B0A 0B0B0B0B 0B0C0B0B 0B0C0B0C [................]
7F57B7CEC5A0 0B0D0B0C 0B0D0B0D 0B140B0D 0B140B14 [................]
7F57B7CEC5B0 0B150B14 0B150B15 0B160B15 0B160B16 [................]
7F57B7CEC5C0 0B170B16 0B170B17 0B1D0B17 0B1D0B1D [................]
7F57B7CEC5D0 0B1E0B1D 0B1E0B1E 0B1F0B1E 0B1F0B1F [................]
7F57B7CEC5E0 0B200B1F 0B200B20 0B200B20 0B200B20 [.. . . . . . . .]
7F57B7CEC5F0 0B210B20 0B210B21 0B210B21 0B210B21 [ .!.!.!.!.!.!.!.]
7F57B7CEC600 0B220B21 0B220B22 0B280B22 0B280B28 [!.".".".".(.(.(.]
7F57B7CEC610 0B290B28 0B290B29 0B290B29 0B290B29 [(.).).).).).).).]
7F57B7CEC620 0B2A0B29 0B2A0B2A 0B2A0B2A 0B2A0B2A [).*.*.*.*.*.*.*.]
7F57B7CEC630 0B2B0B2A 0B2B0B2B 0B300B2B 0B300B30 [*.+.+.+.+.0.0.0.]
7F57B7CEC640 0B310B30 0B360B36 0B360B36 0B370B37 [0.1.6.6.6.6.7.7.]
7F57B7CEC650 0B370B37 0B380B38 0B380B38 0B3E0B39 [7.7.8.8.8.8.9.>.]
7F57B7CEC660 0B3E0B3E 0B3F0B3E 0B3F0B3F 0B400B3F [>.>.>.?.?.?.?.@.]
7F57B7CEC670 0B400B40 0B410B40 0B460B46 0B460B46 [@.@.@.A.F.F.F.F.]
7F57B7CEC680 0B470B47 0B470B47 0B480B48 0B480B48 [G.G.G.G.H.H.H.H.]
7F57B7CEC690 0B4B0B49 0B4B0B4B 0B4C0B4B 0B4C0B4C [I.K.K.K.K.L.L.L.]
7F57B7CEC6A0 0B4D0B4C 0B4F0B4F 0B4F0B4F 0B500B50 [L.M.O.O.O.O.P.P.]
7F57B7CEC6B0 0B500B50 0B510B51 0B510B51 0B520B52 [P.P.Q.Q.Q.Q.R.R.]
7F57B7CEC6C0 0B520B52 0B530B53 0B530B53 0B560B54 [R.R.S.S.S.S.T.V.]
7F57B7CEC6D0 0B560B56 0B570B56 0B570B57 0B580B57 [V.V.V.W.W.W.W.X.]
7F57B7CEC6E0 0B580B58 0B580B58 0B5A0B5A 0B5A0B5A [X.X.X.X.Z.Z.Z.Z.]
7F57B7CEC6F0 0B5B0B5B 0B5B0B5B 0B5C0B5C 0B5C0B5C [[.[.[.[.\.\.\.\.]
7F57B7CEC700 0B610B5C 0B610B61 0B620B61 0B620B62 [\.a.a.a.a.b.b.b.]
7F57B7CEC710 0B640B62 0B6A0B6A 0B6A0B6A 0B6A0B6A [b.d.j.j.j.j.j.j.]
7F57B7CEC720 0B6A0B6A 0B6A0B6A 0B6A0B6A 0B700B6B [j.j.j.j.j.j.k.p.]
7F57B7CEC730 0B700B70 0B700B70 0B700B70 0B710B70 [p.p.p.p.p.p.p.q.]
7F57B7CEC740 0B710B71 0B720B71 0B720B72 0B720B72 [q.q.q.r.r.r.r.r.]
7F57B7CEC750 0B780B78 0B780B78 0B780B78 0B780B78 [x.x.x.x.x.x.x.x.]
7F57B7CEC760 0B790B79 0B790B79 0B990B79 0B990B99 [y.y.y.y.y.......]
7F57B7CEC770 0B990B99 0B990B99 0B990B99 0B990B99 [................]
7F57B7CEC780 0B9A0B99 0B9A0B9A 0B9A0B9A 0BAD0BAD [................]
7F57B7CEC790 0BAD0BAD 0BAD0BAD 0BAD0BAD 0BAD0BAD [................]
7F57B7CEC7A0 0BAD0BAD 0BC00BAD 0BC00BC0 0BC00BC0 [................]
7F57B7CEC7B0 0BC00BC0 0BC00BC0 0BC00BC0 0BC00BC0 [................]
7F57B7CEC7C0 0BD30BD3 0BD30BD3 0BD30BD3 0BD30BD3 [................]
7F57B7CEC7D0 0BD30BD3 0BD30BD3 0BD40BD4 0BD40BD4 [................]
7F57B7CEC7E0 0BE70BE7 0BE70BE7 0BE70BE7 0BE70BE7 [................]
7F57B7CEC7F0 0BE70BE7 0BE70BE7 0BE80BE8 0BE80BE8 [................]
7F57B7CEC800 0BFD0BFD 0BFD0BFD 0BFD0BFD 0BFD0BFD [................]
7F57B7CEC810 0BFD0BFD 0BFD0BFD 0BFE0BFE 0BFE0BFE [................]
7F57B7CEC820 0C0F0C0F 0C0F0C0F 0C0F0C0F 0C0F0C0F [................]
7F57B7CEC830 0C0F0C0F 0C0F0C0F 0C230C23 0C230C23 [........#.#.#.#.]
7F57B7CEC840 0C230C23 0C230C23 0C340C23 0C340C34 [#.#.#.#.#.4.4.4.]
7F57B7CEC850 0C340C34 0C420C42 0C420C42 0C420C42 [4.4.B.B.B.B.B.B.]
7F57B7CEC860 0C420C42 0C420C42 0C420C42 0C500C42 [B.B.B.B.B.B.B.P.]
7F57B7CEC870 0C500C50 0C500C50 0C500C50 0C500C50 [P.P.P.P.P.P.P.P.]
7F57B7CEC880 0C500C50 0C500C50 0C5D0C5D 0C5D0C5D [P.P.P.P.].].].].]
7F57B7CEC890 0C5D0C5D 0C5D0C5D 0C720C5D 0C720C72 [].].].].].r.r.r.]
7F57B7CEC8A0 0C720C72 0C720C72 0C720C72 0C720C72 [r.r.r.r.r.r.r.r.]
7F57B7CEC8B0 0C730C72 0C730C73 0C730C73 0C730C73 [r.s.s.s.s.s.s.s.]
7F57B7CEC8C0 0C740C73 0C740C74 0C8B0C74 0C8B0C8B [s.t.t.t.t.......]
7F57B7CEC8D0 0C8C0C8B 0C8C0C8C 0C8C0C8C 0C8C0C8C [................]
7F57B7CEC8E0 0C8C0C8C 0C8C0C8C 0C8D0C8C 0C8D0C8D [................]
7F57B7CEC8F0 0C8D0C8D 0C8D0C8D 0C8E0C8D 0CA60CA6 [................]
7F57B7CEC900 0CA60CA6 0CA70CA7 0CA70CA7 0CB90CA8 [................]
7F57B7CEC910 0CB90CB9 0CBA0CB9 0CBA0CBA 0CBB0CBA [................]
7F57B7CEC920 0CBB0CBB 0CBC0CBB 0CBC0CBC 0CBD0CBC [................]
7F57B7CEC930 0CBD0CBD 0CBD0CBD 00010001 01D101D5 [................]
7F57B7CEC940 01D101D1 024101D1 023E023E 023E023E [......A.>.>.>.>.]
7F57B7CEC950 027D0280 027D027D 02BD027D 02BB02BB [..}.}.}.}.......]
7F57B7CEC960 02BB02BB 02F502F6 02F502F5 031602F5 [................]
7F57B7CEC970 03140314 03140314 03220323 03220322 [........#.".".".]
7F57B7CEC980 03340322 03320332 03320332 03670369 [".4.2.2.2.2.i.g.]
7F57B7CEC990 03670367 03A40367 03A103A1 03A103A1 [g.g.g...........]
7F57B7CEC9A0 03EA03ED 03EA03EA 043703EA 04360436 [..........7.6.6.]
7F57B7CEC9B0 04360436 046D0442 046B046B 046B046B [6.6.B.m.k.k.k.k.]
7F57B7CEC9C0 04A804A9 04A804A8 04B604A8 04B404B4 [................]
7F57B7CEC9D0 04B404B4 04C804CA 04C804C8 04DB04C8 [................]
7F57B7CEC9E0 04DA04DA 04DA04DA 04E704E8 04E704E7 [................]
7F57B7CEC9F0 04EF04E7 04EE04EE 04EE04EE 04FB04FC [................]
7F57B7CECA00 04FB04FB 051D04FB 051C051C 051C051C [................]
7F57B7CECA10 05300531 05300530 053C0530 053B053B [1.0.0.0.0.<.;.;.]
7F57B7CECA20 053B053B 054C0550 054C054C 0560054C [;.;.P.L.L.L.L.`.]
7F57B7CECA30 055B055B 055B055B 0569056D 05690569 [[.[.[.[.m.i.i.i.]
7F57B7CECA40 05750569 05740574 05740574 057C057D [i.u.t.t.t.t.}.|.]
7F57B7CECA50 057C057C 0586057C 05850585 05850585 [|.|.|...........]
7F57B7CECA60 058C0591 058C058C 05AA058C 05A505A5 [................]
7F57B7CECA70 05A505A5 05BE05C4 05BE05BE 05E205BE [................]
7F57B7CECA80 05DC05DC 05DC05DC 05F905FF 05F905F9 [................]
7F57B7CECA90 061C05F9 06160616 06160616 06350636 [............6.5.]
7F57B7CECAA0 06350635 06490635 06430643 06430643 [5.5.5.I.C.C.C.C.]
7F57B7CECAB0 06610667 06610661 06840661 067E067E [g.a.a.a.a...~.~.]
7F57B7CECAC0 067E067E 069B06A1 069B069B 06B9069B [~.~.............]
7F57B7CECAD0 06B806B8 06B806B8 06BE06BF 06BE06BE [................]
7F57B7CECAE0 06C406BE 06C306C3 06C306C3 06C906CB [................]
7F57B7CECAF0 06C906C9 06F806C9 06F706F7 06F706F7 [................]
7F57B7CECB00 07020703 07020702 07160702 07150715 [................]
7F57B7CECB10 07150715 0729072A 07290729 07380729 [....*.).).).).8.]
7F57B7CECB20 07370737 07370737 073E073F 073E073E [7.7.7.7.?.>.>.>.]
7F57B7CECB30 074D073E 074C074C 074C074C 07520753 [>.M.L.L.L.L.S.R.]
7F57B7CECB40 07520752 075D0752 075B075B 075B075B [R.R.R.].[.[.[.[.]
7F57B7CECB50 07710772 07710771 07770771 07760776 [r.q.q.q.q.w.v.v.]
7F57B7CECB60 07760776 077B077D 077B077B 0789077B [v.v.}.{.{.{.{...]
7F57B7CECB70 07870787 07870787 07910793 07910791 [................]
7F57B7CECB80 079D0791 079B079B 079B079B 07A707A8 [................]
7F57B7CECB90 07A707A7 07B507A7 07B407B4 07B407B4 [................]
7F57B7CECBA0 07BC07C1 07BC07BC 07D707BC 07D607D6 [................]
7F57B7CECBB0 07D607D6 07DE07E0 07DE07DE 07EC07DE [................]
7F57B7CECBC0 07EA07EA 07EA07EA 07FA07FC 07FA07FA [................]
7F57B7CECBD0 080E07FA 080D080D 080D080D 0819081A [................]
7F57B7CECBE0 08190819 08270819 08260826 08260826 [......'.&.&.&.&.]
7F57B7CECBF0 0839083A 08390839 08480839 08470847 [:.9.9.9.9.H.G.G.]
7F57B7CECC00 08470847 085E085F 085E085E 0876085E [G.G._.^.^.^.^.v.]
7F57B7CECC10 08750875 08750875 006809F3 00920092 [u.u.u.u...h.....]
7F57B7CECC20 009C009C 00A0009C 00A000A0 01E800A0 [................]
7F57B7CECC30 01E601E7 01E201E5 01E001E1 01FF0200 [................]
7F57B7CECC40 01FD01FE 01FA01FB 01F801FA 021901F7 [................]
7F57B7CECC50 02170218 02140216 02130213 020F0210 [................]
7F57B7CECC60 02360237 02340235 02300232 022E022F [7.6.5.4.2.0./...]
7F57B7CECC70 022B022E 0000022A 00000000 00000000 [..+.*...........]
7F57B7CECC80 00000000 00000000 00000000 00000000 [................]
Repeat 8 times
7F57B7CECD10 00000000 01D50000 02530253 024F0251 [........S.S.Q.O.]
7F57B7CECD20 0258024E 02730273 026E0271 0278026D [N.X.s.s.q.n.m.x.]
7F57B7CECD30 00000000 00000000 00000000 00000000 [................]
Repeat 8 times
7F57B7CECDC0 00000000 00000000 028B0241 0287028A [........A.......]
7F57B7CECDD0 02970298 00000296 00000000 00000000 [................]
7F57B7CECDE0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CECE00 00000000 02CF0280 02CD02CE 02ED02ED [................]
7F57B7CECE10 000002EC 00000000 00000000 00000000 [................]
7F57B7CECE20 00000000 00000000 00000000 00000000 [................]
Repeat 6 times
7F57B7CECE90 02BD0000 02FB02FC 030B030D 00000000 [................]
7F57B7CECEA0 00000000 00000000 031D02F6 031B031C [................]
7F57B7CECEB0 00000000 00000000 00000000 03160000 [................]
7F57B7CECEC0 0329032A 00000000 00000000 00000000 [*.).............]
7F57B7CECED0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CECEF0 033C0323 0339033A 034C0350 035E034A [#.<.:.9.P.L.J.^.]
7F57B7CECF00 0358035A 00000000 00000000 00000000 [Z.X.............]
7F57B7CECF10 00000000 00000000 03720334 036F0370 [........4.r.p.o.]
7F57B7CECF20 03830387 037D0381 03930397 00000391 [......}.........]
7F57B7CECF30 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CECF50 03B10369 03AE03AF 03CA03AA 03C403C6 [i...............]
7F57B7CECF60 03DF03C0 03D903DB 000003D4 00000000 [................]
7F57B7CECF70 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CECF90 00000000 03A40000 03FA03FC 03F403F9 [................]
7F57B7CECFA0 04140418 040D0412 042C0430 0424042A [........0.,.*.$.]
7F57B7CECFB0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
7F57B7CECFE0 00000000 00000000 03ED0000 043C043D [............=.<.]
7F57B7CECFF0 00000000 00000000 00000000 04370000 [..............7.]
7F57B7CED000 04730477 04720472 04860486 00000485 [w.s.r.r.........]
7F57B7CED010 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED030 00000000 00000000 00000000 046D0000 [..............m.]
7F57B7CED040 04AE04AF 00000000 00000000 00000000 [................]
7F57B7CED050 04A90000 04BD04C1 000004BB 00000000 [................]
7F57B7CED060 00000000 00000000 04D504B6 04CF04D1 [................]
7F57B7CED070 00000000 00000000 00000000 04CA0000 [................]
7F57B7CED080 04E104E2 00000000 00000000 00000000 [................]
7F57B7CED090 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED0B0 00000000 00000000 00000000 000004DB [................]
7F57B7CED0C0 00000000 00000000 00000000 04F304E8 [................]
7F57B7CED0D0 000004F2 00000000 00000000 00000000 [................]
7F57B7CED0E0 00000000 00000000 00000000 04EF0000 [................]
7F57B7CED0F0 05070507 05160516 00000000 00000000 [................]
7F57B7CED100 00000000 00000000 00000000 00000000 [................]
Repeat 6 times
7F57B7CED170 00000000 00000000 04FC0000 05210522 [............".!.]
7F57B7CED180 0529052A 00000000 00000000 00000000 [*.).............]
7F57B7CED190 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED1B0 0534051D 00000537 00000000 00000000 [..4.7...........]
7F57B7CED1C0 00000000 05420531 00000000 00000000 [....1.B.........]
7F57B7CED1D0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
7F57B7CED210 00000000 00000000 00000000 0553053C [............<.S.]
7F57B7CED220 05580553 00000558 00000000 00000000 [S.X.X...........]
7F57B7CED230 00000000 00000000 05500000 05640564 [..........P.d.d.]
7F57B7CED240 00000564 00000000 00000000 00000000 [d...............]
7F57B7CED250 00000000 00000000 00000000 00000000 [................]
7F57B7CED260 00000000 05700560 00000570 00000000 [....`.p.p.......]
7F57B7CED270 00000000 00000000 0000056D 00000000 [........m.......]
7F57B7CED280 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED2A0 00000000 00000000 05750000 00000582 [..........u.....]
7F57B7CED2B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED2D0 00000000 00000000 00000000 057D0000 [..............}.]
7F57B7CED2E0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
7F57B7CED310 00000000 05860000 059D05A0 0599059C [................]
7F57B7CED320 05950598 00000594 00000000 00000000 [................]
7F57B7CED330 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED350 00000000 05B90591 05B505B6 05B105B2 [................]
7F57B7CED360 05AD05AE 00000000 00000000 00000000 [................]
7F57B7CED370 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED390 05AA0000 05D605D6 05D405D6 05CF05D0 [................]
7F57B7CED3A0 05CB05CC 05C705C8 00000000 00000000 [................]
7F57B7CED3B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED3D0 00000000 05C40000 05F405F4 05F205F4 [................]
7F57B7CED3E0 05ED05EE 05E905EA 05E505E6 00000000 [................]
7F57B7CED3F0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED410 00000000 00000000 05E20000 06110611 [................]
7F57B7CED420 060B060F 0607060A 06030606 00000602 [................]
7F57B7CED430 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED450 00000000 00000000 00000000 062E05FF [................]
7F57B7CED460 062C062E 06270628 06230624 061F0620 [..,.(.'.$.#. ...]
7F57B7CED470 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED490 00000000 00000000 00000000 061C0000 [................]
7F57B7CED4A0 063C063D 00000638 00000000 00000000 [=.<.8...........]
7F57B7CED4B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED4D0 065B0636 065B065B 06550659 06510654 [6.[.[.[.Y.U.T.Q.]
7F57B7CED4E0 064D0650 0000064C 00000000 00000000 [P.M.L...........]
7F57B7CED4F0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED510 00000000 06790649 06790679 06730677 [....I.y.y.y.w.s.]
7F57B7CED520 066F0672 066B066E 0000066A 00000000 [r.o.n.k.j.......]
7F57B7CED530 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED550 00000000 00000000 06960667 06940696 [........g.......]
7F57B7CED560 068F0690 068B068C 06870688 00000000 [................]
7F57B7CED570 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED590 00000000 00000000 06840000 06B306B3 [................]
7F57B7CED5A0 06AD06B1 06A906AC 06A506A8 000006A4 [................]
7F57B7CED5B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED5D0 00000000 00000000 00000000 000006A1 [................]
7F57B7CED5E0 00000000 000006B9 00000000 000006BF [................]
7F57B7CED5F0 00000000 00000000 00000000 06EF06C4 [................]
7F57B7CED600 06E906EA 06DA06E0 000006D9 00000000 [................]
7F57B7CED610 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED630 00000000 00000000 06FD06CB 000006FA [................]
7F57B7CED640 00000000 00000000 00000000 070906F8 [................]
7F57B7CED650 00000706 00000000 00000000 00000000 [................]
7F57B7CED660 00000000 00000000 00000000 07030000 [................]
7F57B7CED670 071A071D 00000000 00000000 00000000 [................]
7F57B7CED680 00000000 00000000 00000000 00000000 [................]
7F57B7CED690 07300716 0000072F 00000000 00000000 [..0./...........]
7F57B7CED6A0 00000000 073B072A 00000000 00000000 [....*.;.........]
7F57B7CED6B0 00000000 07380000 07430744 00000000 [......8.D.C.....]
7F57B7CED6C0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
7F57B7CED6F0 074F073F 00000000 074D0000 07550756 [?.O.......M.V.U.]
7F57B7CED700 00000000 00000000 00000000 07530000 [..............S.]
7F57B7CED710 07640766 00000763 00000000 00000000 [f.d.c...........]
7F57B7CED720 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
7F57B7CED750 00000000 075D0000 07730773 00000000 [......].s.s.....]
7F57B7CED760 00000000 00000000 07720000 07780778 [..........r.x.x.]
7F57B7CED770 00000000 07770000 07840784 07820783 [......w.........]
7F57B7CED780 00000000 00000000 00000000 00000000 [................]
7F57B7CED790 00000000 078E077D 078A078D 0000078A [....}...........]
7F57B7CED7A0 00000000 07980789 07940797 00000794 [................]
7F57B7CED7B0 00000000 07A40793 07A007A3 0000079F [................]
7F57B7CED7C0 00000000 00000000 00000000 07AD079D [................]
7F57B7CED7D0 000007AB 00000000 00000000 00000000 [................]
7F57B7CED7E0 07B807A8 00000000 00000000 00000000 [................]
7F57B7CED7F0 00000000 00000000 00000000 00000000 [................]
7F57B7CED800 07C607B5 07C407C5 07CC07CD 07D307CB [................]
7F57B7CED810 000007D2 00000000 07DA07C1 000007D9 [................]
7F57B7CED820 00000000 00000000 00000000 00000000 [................]
7F57B7CED830 00000000 00000000 07E707D7 07E607E7 [................]
7F57B7CED840 000007E5 00000000 07F707E0 07F507F6 [................]
7F57B7CED850 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED870 00000000 00000000 080A07EC 08080809 [................]
7F57B7CED880 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED8A0 00000000 00000000 081607FC 00000815 [................]
7F57B7CED8B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED8D0 0823080E 00000822 00000000 00000000 [..#."...........]
7F57B7CED8E0 00000000 00000000 00000000 00000000 [................]
7F57B7CED8F0 00000000 00000000 082C081A 0833082C [..........,.,.3.]
7F57B7CED900 00000833 00000000 00000000 00000000 [3...............]
7F57B7CED910 083C0827 0842083C 00000842 00000000 ['.<.<.B.B.......]
7F57B7CED920 00000000 00000000 084B083A 0855084B [........:.K.K.U.]
7F57B7CED930 00000855 00000000 00000000 00000000 [U...............]
7F57B7CED940 086F0848 00000869 00000000 00000000 [H.o.i...........]
7F57B7CED950 00000000 00000000 00000000 00000000 [................]
7F57B7CED960 085F0000 087E0884 00000000 00000000 [.._...~.........]
7F57B7CED970 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7F57B7CED990 00000876 00000000 00000000 00000000 [v...............]
7F57B7CED9A0 00000000 00000000 00000000 00000000 [................]
Repeat 81 times
7F57B7CEDEC0 00000000 00010001 00090001 00010001 [................]
7F57B7CEDED0 00030003 00030003 0003000A 00260019 [..............&.]
7F57B7CEDEE0 0003001A 001A0003 000F001A 00030003 [................]
7F57B7CEDEF0 000F000F 00030017 00200003 002A0020 [.......... . .*.]
7F57B7CEDF00 00030014 001D0003 0027001D 00030010 [..........'.....]
7F57B7CEDF10 00190003 00230019 00030010 00190003 [......#.........]
7F57B7CEDF20 00230019 00030010 00190003 00230019 [..#...........#.]
7F57B7CEDF30 00030013 001C0003 0026001C 00030014 [..........&.....]
7F57B7CEDF40 001D0003 0027001D 00030012 001B0003 [......'.........]
7F57B7CEDF50 0025001B 00030014 001D0003 0027001D [..%...........'.]
7F57B7CEDF60 00030013 001C0003 0026001C 0003000F [..........&.....]
7F57B7CEDF70 00180003 00220018 0003000E 00170003 [......".........]
7F57B7CEDF80 00210017 00030010 00190003 00230019 [..!...........#.]
7F57B7CEDF90 00030013 001C0003 0026001C 00030012 [..........&.....]
7F57B7CEDFA0 001B0003 0025001B 0003000F 00180003 [......%.........]
7F57B7CEDFB0 00220018 00030019 00220003 00350022 [..".......".".5.]
7F57B7CEDFC0 00030019 00220003 00340022 00030019 [......".".4.....]
7F57B7CEDFD0 00220003 00340022 00030019 00220003 [..".".4.......".]
7F57B7CEDFE0 00340022 00030019 00220003 00340022 [".4.......".".4.]
7F57B7CEDFF0 00030019 012C0034 02C10201 4E390601 [....4.,.......9N]
Block header dump: 0x01400087
Object id on Block? Y
seg/obj: 0x157b0 csc: 0x00.384e36 itc: 2 flg: E typ: 1 - DATA
brn: 0 bdba: 0x1400080 ver: 0x01 opc: 0
inc: 0 exflg: 0
//seg/obj:0x157b0 -16进制转成10进制87984
//csc: 0x00.15a3ea --cleanoutSCN,块清除时的SCN
//itc: 2 --ITL槽的数量
//flg: E --指用的是ASSM，如果是O表示用的是free list
//typ: 1 - DATA --事务型的数据块（并且：数据块头的type：0x06），存放表和索引数据。
//bdba(段头块，也就是对象的第一个块地址)
//ver(对象version）
//opc,inc(对象operation/insert count)
----ITL----
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x000a.01f.00000a39 0x00c00332.02eb.02 --U- 1 fsc 0x0000.00384e39
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
//Itl:ITL事务槽号的流水编号
//Xid：transac[X]tion identified(事务ID),由und的段号+undo的槽号+undo槽号的覆盖次数三部分组成
//Uba：undo block address记录了最近一次的该记录的前镜像（修改前的值）
//Flag：C是提交，U是快速提交，---是未提交（Flg C=Committed U=Commit Upper Bound T=Active at CSC）
//Lck：锁住了几行数据，对应有几个行锁
//Scn/Fsc：Scn=SCN of commited TX; Fsc=Free space credit(bytes)
//这里fsc 0x0000.00384e39是指提交的scn，这个值大于上次清除块时的scn=csc: 0x0000.00384e39(此scn是这个块中最小的SCN of commited)
//SCN WRAP:如果事务已提交并完成清洗，该字段保存事务提交SCN的SCN WRAP部分，否则该字段保存空闲预支字节数(FSC).比如我删除了一行数据10个字节，在事务提前前，这10个字节就属于fsc（即会写到SCN WRAP），只有事务提交后，才能正式返回到空闲空间。
//(注意：
//1、事务槽中首先记录的是Xid和Uba，只有在提交以后，当对这个数据块进行cleanout的时候，才会更新Flag和Scn。因此Oracle总是以事务表中对这个数据块的Scn以及Flag为准。
//2、一个事务开始以后，在一个数据块上得到一个事务槽，那么在这个事务提交以前，这个事务槽会一直占用，直到这个事务提交释放这个事务槽。
//3、只有在已经提交以后，这个itl事务槽中的scn才会有数值。
//4、事务是否已经提交、事务对应的SCN，这些信息都是以回滚段事务表中的为主，事务槽中的不准确
//5、事务槽中的事务id和uba地址是准确的
//6、事务槽1中的事务id和回滚段中的事务id肯定不是一样的，不同回滚段中的事务id也一定不一样。 )
-----用户数据头------
bdba: 0x01400087
//数据块的地址：16进制转成2进制取前10位二进制为文件号0000 0001 1000 ..... 0000000110=5号文件，后面剩于的部分表示块号，0X87转成10进制为135号块
data_block_dump,data header at 0x7f57b7cec064
===============
tsiz: 0x1f98
//top of size块的总大小即8088字节
hsiz: 0x14
//Data header size数据头大小即20个字节
pbl: 0x7f57b7cec064
76543210
flag=--------
ntab=1
//表数：表示这个块的数据在一个表
nrow=1
//行数：表示这个表有1行数据
frre=-1
//The first free row entry in the row directory＝you have to add one
fsbo=0x14
//Free space begin offset 叫起始空间：可以存放数据空间的起始位置（即定义了数据层中空闲空间的起始offset）
fseo=0x1f92
//Free space end offset 叫结束空间：可以存放数据空间的结束位置（即定义了数据层中空闲空间的结束offset）
avsp=0x1f7b
//Available space for new entries 叫空闲空间：定义了数据层中空闲空间的字节数
tosp=0x1f7b
//Total space 叫最终空闲空间：定义了ITL中事务提交后，数据层中空闲空间的字节数
0xe:pti[0] nrow=1 offs=0
//nrow=1 offs=0 --Table directory,整个表的开始，共一行数据 ，定义了该表在行索引中使用的插槽数
0x12:pri[0] offs=0x1f92
//Row index，叫行索引，定义了该块中包含的所有行数据的位置
-----用户数据------
block_row_dump:
tab 0, row 0, @0x1f92
//第一个表第一行的位置，定义了该表在行索引中的起始插槽号
tl: 6 fb: --H-FL-- lb: 0x1 cc: 1
//tl:6行长度6个字节
//fb: (Flag byte)--H-FL指H（Head piece of row）F(First data piece) L(Last data piece)
//lb: 0x1 --Lock byte和上面的ITL的lck相对应，表示这行是否被lock了
//cc:1 --表示有一列，即这个表有一个字段
col 0: [ 2] c1 02
//col 0: [ 2] c1 02 --第一行的第一个字段长度和值
end_of_block_dump
End dump data blocks tsn: 6 file#: 5 minblk 135 maxblk 135
扫一扫
918
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
