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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Data block Structure and Row Piece Structure_20091209BloCStruct
- data structureStruct
- Data Structure_樹Struct
- sqrt-data-structureStruct
- index branch and leaf block structure(轉)IndexBloCStruct
- dsi401_block structure(一)BloCStruct
- Export data from a data blockExportBloC
- dsi401_block structure之(二)BloCStruct
- Structure of the Data Dictionary : Base Tables (258)Struct
- Half-Edge-Mesh-Data-StructureStruct
- data structure online videoStructIDE
- Disjoint set(並查集) data structure並查集Struct
- Structure of the Data Dictionary : User-Accessible Views (259)StructView
- DATA BLOCK內部結構BloC
- Oracle Data block 的物理結構OracleBloC
- Oracle 的 data block研讀(二)OracleBloC
- DATA BLOCK內部結構圖BloC
- LeetCode-Two Sum III - Data structure designLeetCodeStruct
- Availability and Optimization of Free Space in a Data Block(五)AIBloC
- Availability and Compression of Free Space in a Data BlockAIBloC
- Oracle10g 五種不同的block sizeOracleBloC
- Oracle10g新增BLOCK CHANGE TRACKING功能OracleBloC
- UVA 11995 I Can Guess the Data Structure!(ADT)Struct
- oracle concept——data block,extent,segment-01OracleBloC
- [Data Guard]Oracle10g Data Guard學習筆記(一)Oracle筆記
- [Data Guard]Oracle10g Data Guard學習筆記(二)Oracle筆記
- [Data Guard]Oracle10g Data Guard學習筆記(三)Oracle筆記
- A C++ half-edge data structure for a triangle mesh with no external dependencies whatsoeveC++Struct
- oracle10g data guard redo transport serviceOracle
- Script:Translate RDBA relative data block addressBloC
- 模擬data block lost write的簡單方法BloC
- 原創:oracle data block 內部結構分析OracleBloC
- H.264碼流結構 (H.264 Data Structure)Struct
- Hadley Wickham, author of R Packages: Data Structure Prodigy(圖靈訪談)PackageStruct圖靈
- Oracle10g Wait Event Data Collection ProcedureOracleAI
- [轉載]ORA-01578: ORACLE data block corruptedOracleBloC
- Oracle Data block 的物理結構-體系架構OracleBloC架構
- 【OCP最新題庫解析(052)--題6】Which structure can span multiple data filesStruct