[转帖]create table INITRANS参数分析

set dba 5,179 p ktbbh p kdbh d offset 36 count 12 BBED> struct ktbbh, 144 bytes @20 ub1 ktbbhtyp @20 0x01 (KDDBTDATA) union ktbbhsid, 4 bytes @24 ub4 ktbbhsg1 @24 0x0000361c ub4 ktbbhod1 @24 0x0000361c struct ktbbhcsc, 8 bytes @28 ub4 kscnbas @28 0x000b3343 ub2 kscnwrp @32 0x0000 sb2 ktbbhict @36 -2043 ub1 ktbbhflg @38 0x32 (NONE) ub1 ktbbhfsl @39 0x00 ub4 ktbbhfnx @40 0x014000a0 struct ktbbhitl[0], 24 bytes @44 struct ktbitxid, 8 bytes @44 ub2 kxidusn @44 0x0003 ub2 kxidslt @46 0x001e ub4 kxidsqn @48 0x0000013d struct ktbituba, 8 bytes @52 ub4 kubadba @52 0x00c009e4 ub2 kubaseq @56 0x0183 ub1 kubarec @58 0x2d ub2 ktbitflg @60 0x210a (KTBFUPB) union _ktbitun, 2 bytes @62 sb2 _ktbitfsc @62 0 ub2 _ktbitwrp @62 0x0000 ub4 ktbitbas @64 0x000b3351 struct ktbbhitl[1], 24 bytes @68 struct ktbitxid, 8 bytes @68 ub2 kxidusn @68 0x0000 ub2 kxidslt @70 0x0000 ub4 kxidsqn @72 0x00000000 struct ktbituba, 8 bytes @76 ub4 kubadba @76 0x00000000 ub2 kubaseq @80 0x0000 ub1 kubarec @82 0x00 ub2 ktbitflg @84 0x0000 (NONE) union _ktbitun, 2 bytes @86 sb2 _ktbitfsc @86 0 ub2 _ktbitwrp @86 0x0000 ub4 ktbitbas @88 0x00000000 struct ktbbhitl[2], 24 bytes @92 struct ktbitxid, 8 bytes @92 ub2 kxidusn @92 0x0000 ub2 kxidslt @94 0x0000 ub4 kxidsqn @96 0x00000000 struct ktbituba, 8 bytes @100 ub4 kubadba @100 0x00000000 ub2 kubaseq @104 0x0000 ub1 kubarec @106 0x00 ub2 ktbitflg @108 0x0000 (NONE) union _ktbitun, 2 bytes @110 sb2 _ktbitfsc @110 0 ub2 _ktbitwrp @110 0x0000 ub4 ktbitbas @112 0x00000000 struct ktbbhitl[3], 24 bytes @116 struct ktbitxid, 8 bytes @116 ub2 kxidusn @116 0x0000 ub2 kxidslt @118 0x0000 ub4 kxidsqn @120 0x00000000 struct ktbituba, 8 bytes @124 ub4 kubadba @124 0x00000000 ub2 kubaseq @128 0x0000 ub1 kubarec @130 0x00 ub2 ktbitflg @132 0x0000 (NONE) union _ktbitun, 2 bytes @134 sb2 _ktbitfsc @134 0 ub2 _ktbitwrp @134 0x0000 ub4 ktbitbas @136 0x00000000 struct ktbbhitl[167], 24 bytes @4052 struct ktbitxid, 8 bytes @4052 ub2 kxidusn @4052 0x0000 ub2 kxidslt @4054 0x0000 ub4 kxidsqn @4056 0x00000000 struct ktbituba, 8 bytes @4060 ub4 kubadba @4060 0x00000000 ub2 kubaseq @4064 0x0000 ub1 kubarec @4066 0x00 ub2 ktbitflg @4068 0x0000 (NONE) union _ktbitun, 2 bytes @4070 sb2 _ktbitfsc @4070 0 ub2 _ktbitwrp @4070 0x0000 ub4 ktbitbas @4072 0x00000000 struct ktbbhitl[168], 24 bytes @4076 struct ktbitxid, 8 bytes @4076 ub2 kxidusn @4076 0x0000 ub2 kxidslt @4078 0x0000 ub4 kxidsqn @4080 0x00000000 struct ktbituba, 8 bytes @4084 ub4 kubadba @4084 0x00000000 ub2 kubaseq @4088 0x0000 ub1 kubarec @4090 0x00 ub2 ktbitflg @4092 0x0000 (NONE) union _ktbitun, 2 bytes @4094 sb2 _ktbitfsc @4094 0 ub2 _ktbitwrp @4094 0x0000 ub4 ktbitbas @4096 0x00000000 BBED> struct kdbh, 14 bytes @4108 ub1 kdbhflag @4108 0x00 (NONE) sb1 kdbhntab @4109 1 sb2 kdbhnrow @4110 135 sb2 kdbhfrre @4112 -1 sb2 kdbhfsbo @4114 288 sb2 kdbhfseo @4116 705 sb2 kdbhavsp @4118 417 sb2 kdbhtosp @4120 417 BBED> File: /data2/enmo/hsql01.dbf (5) Block: 179 Offsets: 36 to 47 Dba:0x014000b3 ———————————————————————— a9f83200 b0004001 03001e00 <32 bytes per line> BBED> –8192 40 + 4056=4096