oracle10g data block structure

环境:

oracle 10.2.0.1

OS:REDHAT 5.3 64BIT

[@more@]

===========view block header======================

p kcbh
struct kcbh, 20 bytes @0
ub1 type_kcbh @0 0x06
ub1 frmt_kcbh @1 0xa2
ub1 spare1_kcbh @2 0x00
ub1 spare2_kcbh @3 0x00
ub4 rdba_kcbh @4 0x0040007a
ub4 bas_kcbh @8 0xdf3de2d9
ub2 wrp_kcbh @12 0x0a4f
ub1 seq_kcbh @14 0x01
ub1 flg_kcbh @15 0x06 (KCBHFDLC, KCBHFCKV)
ub2 chkval_kcbh @16 0x625c
ub2 spare3_kcbh @18 0x0000

===========view block space======================

p kdbh
struct kdbh, 14 bytes @68
ub1 kdbhflag @68 0x00 (NONE)
b1 kdbhntab @69 1
b2 kdbhnrow @70 108
sb2 kdbhfrre @72 -1
sb2 kdbhfsbo @74 234
sb2 kdbhfseo @76 1107
b2 kdbhavsp @78 873
b2 kdbhtosp @80 873

===========view block rows======================

p kdbt
struct kdbt[0], 4 bytes @82
b2 kdbtoffs @82 0
b2 kdbtnrow @84 108

===========view block object======================

p ktbbh
struct ktbbh, 48 bytes @20
ub1 ktbbhtyp @20 0x01 (KDDBTDATA)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x00000012
ub4 ktbbhod1 @24 0x00000012[object id] struct ktbbhcsc, 8 bytes @28 [CSC at Last Block Clean Out]

ub4 kscnbas @28 0xdf3de2d8
ub2 kscnwrp @32 0x0a4f
b2 ktbbhict @36 1[No. ltl] ub1 ktbbhflg @38 0x02 (NONE)
ub1 ktbbhfsl @39 0x00[free space lock] ub4 ktbbhfnx @40 0x00000000[krdba] struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0005
ub2 kxidslt @46 0x0023
ub4 kxidsqn @48 0x0000020f
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x0080012a
ub2 kubaseq @56 0x01b7
ub1 kubarec @58 0x32
ub2 ktbitflg @60 0x2001 (KTBFUPB)
union _ktbitun, 2 bytes @62
b2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0xdf3de2d9

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10130206/viewspace-1042784/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10130206/viewspace-1042784/