oracle block type
http://www.ixora.com.au/notes/cache_block_types.htm
| Code | Block Type | Versions |
|---|---|---|
| 1 | Undo header block (limited extents) | all, but superseded by type 14 from 8.0 |
| 2 | Undo data block | all |
| 3 | Save undo header block (limited extents) | all, but superseded by type 15 from 8.0 |
| 4 | Save undo data block | all |
| 5 | Data segment header block (limited extents, no freelist groups) | all, but superseded by type 16 from 8.0 |
| 6 | Table/cluster/index segment data block | all |
| 7 | Temporary segment data block | all |
| 8 | Sort key block | all |
| 9 | Sort run block | all |
| 10 | Free list block | all, but superseded by type 22 from 8.0 |
| 11 | Data file header block | all |
| 12 | Data segment header block (limited extents, with freelist groups) | all, but superseded by type 17 from 8.0 |
| 13 | Compatibility segment | all |
| 14 | Undo header block (unlimited extents) | from 7.3 |
| 15 | Save undo header block (unlimited extents) | from 7.3 |
| 16 | Data segment header block (unlimited extents, no freelist groups) | from 7.3 |
| 17 | Data segment header block (unlimited extents, with freelist groups) | from 7.3 |
| 18 | Extent map block | from 7.3 |
| 19 | Backup set piece header | from 8.0 |
| 20 | Backup set directory block | from 8.0 |
| 21 | Controlfile block | from 8.0 |
| 22 | Free list block with free block count | from 8.0 |
| 23 | LOB segment header block | from 8.0 |
| 24 | LOB segment freelist block | from 8.0 |
| 25 | LOB segment space usage index block | from 8.0 |
| 26 | LOB segment space usage bitmap block | from 8.0 |
| 27 | LOB segment chunk data block | from 8.0 |
| 28 | don’t know | |
| 29 | LMT space map header block | from 8.1 |
| 30 | LMT space map block | from 8.1 |
| 31 | don’t know | |
| 32 | ASSM level 1 bitmap block | from 9.0 |
| 33 | ASSM level 2 bitmap block | from 9.0 |
| 34 | ASSM level 3 bitmap block | from 9.0 |
| 35 | ASSM segment header block | from 9.0 |
| 36 | ASSM extent map block | from 9.0 |
| 37 | don’t know | |
| 38 | System managed undo header block | from 9.0 |
6 table/index /cluster segment datablock
BBED> p kcbh
struct kcbh, 20 bytes @0
ub1 type_kcbh @0 0×06
ub1 frmt_kcbh @1 0xa2
ub1 spare1_kcbh @2 0×00
ub1 spare2_kcbh @3 0×00
ub4 rdba_kcbh @4 0×0100001d
ub4 bas_kcbh @8 0×00051a80
ub2 wrp_kcbh @12 0×0000
ub1 seq_kcbh @14 0×01
ub1 flg_kcbh @15 0×06 (KCBHFDLC, KCBHFCKV)
ub2 chkval_kcbh @16 0xa7c0
ub2 spare3_kcbh @18 0×0000
11 Data file header block
BBED> p kcvfh
struct kcvfh, 676 bytes @0
struct kcvfhbfh, 20 bytes @0
ub1 type_kcbh @0 0×0b
ub1 frmt_kcbh @1 0xa2
ub1 spare1_kcbh @2 0×00
ub1 spare2_kcbh @3 0×00
ub4 rdba_kcbh @4 0×01000001
ub4 bas_kcbh @8 0×00000000
ub2 wrp_kcbh @12 0×0000
ub1 seq_kcbh @14 0×01
ub1 flg_kcbh @15 0×04 (KCBHFCKV)
ub2 chkval_kcbh @16 0×35e7
ub2 spare3_kcbh @18 0×0000
