ITPub博客

首页 > 数据库 > Oracle > oracle10g data block structure

oracle10g data block structure

原创 Oracle 作者:qqmengxue 时间:2010-12-08 12:01:22 0 删除 编辑

环境:

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博客 ” ,链接:https://blog.itpub.net/10130206/viewspace-1042784/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: ORACLE BLOCK DUMP
下一篇: oracle调用C动态库
请登录后发表评论 登录
全部评论

注册时间:2009-03-26

  • 博文量
    169
  • 访问量
    589155