This page was saved using WebZIP 7.0.3.1030 offline browser (Unregistered) on 09/04/11 14:29:53.
Address: http://home2oracle.narod.ru/block_internal/6e.html
Title: 6.Trans data-LOB index  •  Size: 271597  •  Last Modified: Thu, 04 Feb 2010 15:48:32 GMT
6   TRANS DATA (LOB index\leaf block)
 
  0 1 2 3 4 5 6 7 8 9 A B C D E F   Start dump data blocks tsn: 12 file#: 11 minblk 183426 maxblk 183426
00 061 022 003 004 82 CC C2 025 6D EA 06 00 00 006 047 048   Transaction buffer tsn: 12 rdba: 0x02c2cc82 (11/183426)
10 FE 429 00 0010 0211 00 00 00 91 76 00 0012 6D EA 06 00   header scn: 0x0000.0006ea6d seq: 0x04 flg: 0x04 tail: 0xea6d0604
20 00 0013 22 00 0214 00 0215 0016 00 00 00 0017 00 00 00 00   frmt: 0x02 chkval: 0x42fe type: 0x06=trans data
30 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   ITL Block header dump:  0x02c2cc82
40 00 00 00 00 1018 0019 00 0020 05 00 00 0021 6322 01 C0 0323    Object id on Block? Y
50 01 0024 1225 00 03 0026 34 0027 00 00 00 0028 0029 0030 8031 0232   Common  seg/obj: 0x7691  csc: 0x00.6ea6d  itc: 2  flg: -  typ: 2 - INDEX
60 00 00 00 0033 03 0034 2A 0035 CE 0636 A4 0637 00 0038 01 0039    Index Header      fsl: 0  fnx: 0x0 ver: 0x01
70 00 00 00 0040 00 00 00 0041 20 0042 00 00 64 0743 00 00   Leaf header  
80 3244 0745 00 07 CE 06 0046 00 00 00 00 00 00 00 00 00   Row directory  Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
90 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   0x01   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   0x02   0x0010.000.00000005  0x03c00163.0001.12  ----    3  fsc 0x0034.00000000
B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   Leaf block dump
D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   ===============
E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   header address 119287900=0x71c305c
F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcolev 0
100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   KDXCOLEV Flags = - - -
110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcolok 0
120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcoopc 0x80: opcode=0: iot flags=--- is converted=Y
130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   Free space kdxconco 2
140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcosdc 0
150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxconro 3
160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcofbo 42=0x2a
170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcofeo 1742=0x6ce
180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcoavs 1700
190 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxlespl 0
1A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxlende 1
1B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxlenxt 0=0x0
1C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxleprv 0=0x0
1D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxledsz 32
1E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxlebksz 1892
1F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#0[1842] flag: ---D-, lock: 2, data:(32):
200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    00 20 03 00 00 00 00 00 01 44 00 00 00 00 00 01 02 c2 cc 7c 00 00 00 00 00
210 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    00 00 00 00 00 00 00
220 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 10; (10):  00 00 00 01 00 00 00 00 52 0a
230 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; len 4; (4):  00 00 00 00
240 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#1[1792] flag: -----, lock: 2, data:(32):
250 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    00 20 03 00 00 00 00 00 01 3c 00 00 00 00 00 01 02 c2 cc 7d 00 00 00 00 00
260 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    00 00 00 00 00 00 00
270 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 10; (10):  00 00 00 01 00 00 00 00 52 0b
280 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; len 4; (4):  00 00 00 00
290 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#2[1742] flag: -----, lock: 2, data:(32):
2A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    02 c2 cc 7c 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
2B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    00 00 00 00 00 00 00
2C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 10; (10):  00 01 43 4a 2d cd 00 00 00 00
2D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; len 4; (4):  02 c2 cc 7c
2E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   ----- end of leaf block dump -----
2F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
300 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
310 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
320 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
330 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
340 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
350 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
360 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
370 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
380 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
390 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
3A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
3B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
3C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
3D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
3E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
3F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
400 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
410 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
420 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
430 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
440 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
450 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
460 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
470 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
480 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
490 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
4A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
4B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
4C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
4D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
4E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
4F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
500 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
510 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
520 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
530 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
540 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
550 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
560 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
570 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
580 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
590 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
5A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
5B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
5C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
5D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
5E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
5F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
600 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
610 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
620 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
630 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
640 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
650 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
660 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
670 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
680 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
690 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
6A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
6B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
6C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
6D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
6E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
6F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
700 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
710 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
720 00 00 00 00 00 00 00 00 00 00 0047 0248 02 C2 CC 7C    
730 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
740 00 00 00 00 00 00 00 00 00 00 00 0049 0A50 00 01 43    
750 4A 2D CD 00 00 00 00 0451 02 C2 CC 7C 0052 0253 00 20   Row data  
760 03 00 00 00 00 00 01 3C 00 00 00 00 00 01 02 C2    
770 CC 7D 00 00 00 00 00 00 00 00 00 00 00 0054 0A55 00    
780 00 00 01 00 00 00 00 52 0B56 0457 00 00 00 00 0158 0259    
790 00 20 03 00 00 00 00 00 01 44 00 00 00 00 00 01    
7A0 02 C2 CC 7C 00 00 00 00 00 00 00 00 00 00 00 0060    
7B0 0A61 00 00 00 01 00 00 00 00 52 0A62 0463 00 00 00 00    
7C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
7D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
7E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
7F0 00 00 00 00 00 00 00 00 00 00 00 00 04 06 6D EA64    
 
 
SQL> select segment_name,segment_type,header_file,header_block  
 from dba_segments where tablespace_name='TEST';  
 
SEGMENT_NAME     SEGMENT_TYPE HEADER_FILE   HEADER_BLOCK  
TEST_LOB TABLE 11 183393  
SYS_IL0000030349C00001$$ LOBINDEX 11 183409  
SYS_IL0000030349C00002$$ LOBINDEX 11 183425  
LOB_1 LOBSEGMENT 11 183401  
LOB_2 LOBSEGMENT 11 183417  
 
SQL> alter system dump datafile 11  block 183426;  
1
Block types.
type:0x06
2
The format of the cache header was changed for Oracle8. Under Oracle8 and 9, the value is always 2. Previously, it was 1.
frmt:0x02
3
spare1
4
spare2
5
The tablespace relative database block address (RDBA). This is constructed from the tablespace relative file number (10 bits), and
the block number of the data block within that file (22 bits)
RDBA:0x02C2CC82
6
The SCN at which the block was last changed. The low-order 4 bytes are called the SCN base, and the high-order
2 bytes are called the SCN wrap.
scn: 0x0000.00939110
7
A sequence number incremented for each change to a block at the same SCN. If the sequence
number wraps, a new SCN must be allocated.  The value 0xff is reserved. When present it
indicates that the block has been marked as corrupt by Oracle.
seq:0x04
8
Flag.
1 - virgin block
2 - last change to the block was for a cleanout operation
4 - checksum value is set
8 - temporary data
flg:0x04
9
An optional checksum of the block contents. When a block is written, the checksum is either cleared or set depending on the
setting of the db_block_checksum parameter. When a block is read, the checksum is verified if present and if the
parameter is set to TRUE. Checksums are always calculated and checked for blocks in the SYSTEM tablespace. The
checksum is the XOR of all the other 2-byte pairs in the block. Thus when a block with a checksum is checked, the XOR of all
the 2-byte words in the block should be 0.
chkval:0x42FE
10
spare3
11
Flag for data or index block.
 1 - Data
 2 - Index
 type:02
12
The object number of the segment in OBJ$.
seg/obj: 0x00007691
13
Cleanout system change,used to show when block cleanout was last performed.
csc: 0x0006EA6D
14
Count of the ITLs on the block.
 itc:2
15
Flag (no ASSM) :
'-' means that the block is not on the freelist,
'O' - in freelist
Object id on Block? Y flg: - ver: 0x01

16
Index to the first slot on the ITL freelist.
 fsl:0
17
The RDBA of the next block on the segment freelist.Null if this block is not on a freelist. 
fnx: 0x00000000
18
The ITL is used to mark the row locked until the transaction completes.
XID is  the  pointer to the rollback segment transaction table slot  -  Undoseg#.slot#.wrap
The  Undoseg# is the rollback segment, the slot# refers to  a slot in trunsaction  table, and  wrap refers to the number of times that the
slot has been used  in  a trunsaction.
0x0010.000.00000005
19
Rollback segment
XID:undoseg 16
20
Refers to a slot in the transaction table XID:slot#  0
21
Refers to the number of times that the slot has been used (i.e. incarnation or version) in a transaction.
XID:wrap 0x00000005
22
The UBA is the pointer to the tail of the undo chain for the block.
UBA:(undodatablockaddr.sequence#.record#): 0x03c00163.0001.12
23
DBA of the rollback segment.
0x03c00163
24
Sequence number.
1
25
Record number for the change in that undo block.
18
26
Lck Flag
---- transaction is active, or committed pending cleanout    
C--- transaction has been committed and locks cleaned out  
-B-- this undo record contains the undo for this ITL entry   
--U- transaction committed (maybe long ago); SCN is an upper bound   
---T = transaction was still active at block cleanout SCN  
Lck Flag: ----
Lck
The number of row-level locks held in the block by this transaction
Lck: 3
(0000 - 0000 0000 0011)
27
If the transaction has been cleaned out, this is the commit SCN or an upper bound thereof. Otherwise the leading two
bytes contain the free space credit for the transaction - that is, the number of bytes freed in the block by the transaction
(free space credit)
Fsc:0x0034
28
SCN or freespace credit.
If the transaction has been cleaned out, this is the commit SCN or an upper bound thereof. Otherwise the leading two bytes contain the free space credit for
the transaction - that is, the number of bytes freed in the block by the transaction.
(SCN of commited TX )  - no commited
29
Index level (0 represents leaf blocks).
kdxcolev: 0
30
Denotes whether structural block transaction is occurring.
kdxcolok:0
31
Internal operation code.
kdxcoopc: 0x80:  opcode=0: iot flags=--- is converted=Y
32
Iindex column count.
kdxconco:2
33
Count of index structural changes involving lock.
kdxcosdc:0
34
Number of index entries -does not include kdxbrlmc pointer.
kdxconro:3
35
Free space begin offset.
kdxcofbo:002A
36
Free space end offset.
kdxcofeo:06CE
37
Available space in the block.
kdxcoavs:1700
38
 Bytes of uncommitted data at time of block split that have been cleaned out.
 kdxlespl:0
39
Number of deleted entries.
kdxlende:1
40
Pointer to the next leaf block in the index structure via corresponding RDBA .
41
Pointer to the previous leaf block in the index structure via corresponding RDBA.
 kdxleprv: 0x00000000
42
Usable block space (by default less than branch due to the additional ITL entry).
kdxledsz:32
43
kdxlebksz:1892
44
 Begin data row address.
45
offset (1842).
46
 Begin free space.
47
row =2  flag: -----
48
 lock: 2
49
Stores inodes  for old chunk versions for providing read consistency.
data:(32)
Only RDBAs: 0x02c2cc7c (file - 11, block -183420)

50
col 0.
len 10
51
col 1.
len 4
52
row =1 flag: -----
53
 lock: 2
54
LOB inode information  kept in LOB index. LOB inode is a structure for keeping track of
chunks belonging to a LOB item: requires 16 bytes (kdlinode) + 4 bytes (relative DBAs)  per chunk in lobitem.
data:(32):
kdlinode: 00 20 03 00 00 00 00 00 01 3c 00 00 00 00 00 01
RDBAs: 0x02c2cc7d (file - 11, block -183421)
55
col 0.
len 10
56
LobId: 0001000052B
57
col 1.
len 4
58
row =0 flag: ---D-
59
 lock: 2
60
LOB inode information  kept in LOB index. LOB inode is a structure for keeping track of
chunks belonging to a LOB item: requires 16 bytes (kdlinode) + 4 bytes (relative DBAs)  per chunk in lobitem.
data:(32):
kdlinode: 00 20 03 00 00 00 00 00 01 44 00 00 00 00 00 01
RDBAs: 0x02c2cc7c (file - 11, block -183420)
61
col 0.
len 10
62
LobId: 0001000052A
63
col 1.
len 4
64
Tail is comprised of the low-order two bytes of the SCN base followed by the block type and the sequence number. The consistency
of the header and tail is checked whenever a block is read. This detects most block corruptions, in particular split blocks from hot
backups.
tail:0xEA6D0604