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/6c.html
Title: 6.Trans data-index (branch block)  •  Size: 258547  •  Last Modified: Thu, 04 Feb 2010 15:48:32 GMT
6   TRANS DATA (index\branch block) extract data
 
  0 1 2 3 4 5 6 7 8 9 A B C D E F   Start dump data blocks tsn: 16 file#: 15 minblk 1794 maxblk 1794
00 061 022 003 004 02 07 C0 035 B8 91 93 00 00 006 017 048   buffer tsn: 16 rdba: 0x03c00702 (15/1794)
10 D6 EB9 00 0010 0211 00 00 00 9B 7A 00 0012 07 91 93 00   Transaction scn: 0x0000.009391b8 seq: 0x01 flg: 0x04 tail: 0x91b80601
20 00 0013 00 00 0114 00 0215 0016 00 00 00 0017 FF18 FF19 00 0020    header frmt: 0x02 chkval: 0xebd6 type: 0x06=trans data
30 00 00 00 0021 0022 00 00 0023 00 0024 0025 00 00 8026 00 0027   ITL Block header dump:  0x03c00702
40 07 91 93 0028 0229 0030 8031 0232 00 00 00 0033 08 0034 2C 0035   Common Ind.H.  Object id on Block? Y
50 BB 0636 8F 0637 4D 07 C0 0338 00 00 00 0039 7C 0740 00 00   Branch header  seg/obj: 0x7a9b  csc: 0x00.939107  itc: 1  flg: -  typ: 2 - INDEX
60 7041 0742 49 07 26 07 11 07 03 07 F1 06 DA 06 BB 0643   Row directory      fsl: 0  fnx: 0x0 ver: 0x01
70 0044 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    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   0xffff.000.00000000  0x00000000.0000.00  C---    0  scn 0x0000.00939107
A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    
B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   Branch block dump
C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   =================
D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   header address 59387972=0x38a3044
E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcolev 2
F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   KDXCOLEV Flags = - - -
100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcolok 0
110 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
120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxconco 2
130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcosdc 0
140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxconro 8
150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcofbo 44=0x2c
160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcofeo 1723=0x6bb
170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxcoavs 1679
180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxbrlmc 62916429=0x3c0074d
190 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxbrsno 0
1A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   kdxbrbksz 1916
1B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#0[1904] dba: 62916511=0x3c0079f
1C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 6; (6):  2f 34 61 30 66 33
1D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; TERM
1E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#1[1865] dba: 62916588=0x3c007ec
1F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 30; (30):
200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    2f 38 38 37 34 38 62 61 65 5f 50 4e 47 49 6d 61 67 65 44 65 63 6f 64 65 72
210 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    50 4e 47 45 78
220 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; len 3; (3):  03 c0 03
230 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#2[1830] dba: 62916672=0x3c00840
240 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 26; (26):
250 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    2f 63 37 34 37 63 33 66 5f 42 69 6e 61 72 79 43 6c 61 73 73 4c 6f 61 64 65
260 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    72
270 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; len 3; (3):  03 c0 04
280 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#3[1809] dba: 62916764=0x3c0089c
290 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 12; (12):  41 4c 4c 5f 53 59 4e 4f 4e 59 4d 53
2A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; len 3; (3):  03 c0 04
2B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#4[1795] dba: 62916851=0x3c008f3
2C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 8; (8):  4d 45 54 41 58 53 4c 50
2D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; TERM
2E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#5[1777] dba: 62916914=0x3c00932
2F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 12; (12):  6a 61 76 61 2f 62 65 61 6e 73 2f 56
300 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; TERM
310 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#6[1754] dba: 62916973=0x3c0096d
320 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 17; (17):  6f 72 61 63 6c 65 2f 6a 6d 73 2f 41 51 6a 6d 73 46
330 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; TERM
340 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   row#7[1723] dba: 62916993=0x3c00981
350 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 0; len 22; (22):
360 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   Free space  73 75 6e 2f 69 6f 2f 43 68 61 72 54 6f 42 79 74 65 43 70 39 35 30
370 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   col 1; len 3; (3):  03 c0 05
380 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   ----- end of branch block dump -----
390 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   End dump data blocks tsn: 16 file#: 15 minblk 1794 maxblk 1794
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   alter session set events 'immediate trace name treedump level 31387'
3C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ----- begin tree dump
3D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   branch: 0x3c00702 62916354 (0: nrow: 9, level: 2)
3E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      branch: 0x3c0074d 62916429 (-1: nrow: 73, level: 1)
3F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         leaf: 0x3c00703 62916355 (-1: nrow: 42 rrow: 42)
400 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         leaf: 0x3c00704 62916356 (0: nrow: 40 rrow: 40)
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         leaf: 0x3c0074b 62916427 (71: nrow: 43 rrow: 43)
430 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      branch: 0x3c0079f 62916511 (0: nrow: 81, level: 1)
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    ----- end tree dump
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 8145    
700 09 C0 0346 1647 73 75 6E 2F 69 6F 2F 43 68 61 72 54    
710 6F 42 79 74 65 43 70 39 35 30 0348 03 C0 0549 6D50 09    
720 C0 03 11 6F 72 61 63 6C 65 2F 6A 6D 73 2F 41 51    
730 6A 6D 73 46 FE 3251 09 C0 03 0C 6A 61 76 61 2F 62    
740 65 61 6E 73 2F 56 FE F352 08 C0 03 08 4D 45 54 41    
750 58 53 4C 50 FE 9C53 08 C0 03 0C 41 4C 4C 5F 53 59    
760 4E 4F 4E 59 4D 53 03 03 C0 04 4054 08 C0 03 1A 2F    
770 63 37 34 37 63 33 66 5F 42 69 6E 61 72 79 43 6C    
780 61 73 73 4C 6F 61 64 65 72 03 03 C0 04 EC55 07 C0   Row data  
790 03 1E 2F 38 38 37 34 38 62 61 65 5F 50 4E 47 49    
7A0 6D 61 67 65 44 65 63 6F 64 65 72 50 4E 47 45 78    
7B0 03 03 C0 03 9F56 07 C0 03 06 2F 34 61 30 66 33 FE    
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 01 06 B8 9157    
 
 SQL>create index test.idx$heap_table  ON test.heap_table(object_name);  
 SQL>select Object_id from dba_objects where  owner='TEST' and  
object_name='IDX$HEAP_TABLE';  
 
OBJECT_ID            
31387  
 
 SQL>alter session set events 'immediate trace name treedump level 31387';  
 SQL>select dbms_utility.data_block_address_file(62916354)as file_,  
dbms_utility.data_block_address_block(62916354) as  block_ from dual;  
 
FILE_     BLOCK_      
15 1794  
 
SQL> alter system dump datafile 15  block 1794;  
SQL> alter system checkpoint;  
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:0x03C00702
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.009391B8
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:0x01
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:0xEBD6
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: 0x00007A9B (31387)
13
Cleanout system change,used to show when block cleanout was last performed.
 csc: 0x00939107
14
Count of the ITLs on the block.
 itc:1
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.
0xFFFF.0000.00000000
19
Rollback segment.
XID:undoseg
20
Refers to a slot in the transaction table.
XID:slot#
21
Refers to the number of times that the slot has been used (i.e. incarnation or version) in a transaction.
XID:wrap
22
The UBA is the pointer to the tail of the undo chain for the block.
UBA:(undodatablockaddr.sequence#.record#):   0x00000000.0000.00
23
DBA of the rollback segment
24
Sequence number
25
Record number for the change in that undo block
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: C---
Lck
The number of row-level locks held in the block by this transaction
Lck: 0
(1000 - 0000 0000 0000 )
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) Scn/Fsc:0
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 ) Scn/Fsc: 0x00939107
29
Index level (0 represents leaf blocks).
kdxcolev: 2
30
Denotes whether structural block transaction is occurring.
kdxcolok:0
31
Iinternal operation code.
kdxcoopc: 0x80:  opcode=0: iot flags=--- is converted=Y
32
Iindex column count.
kdxconco:2
33
Ccount of index structural changes involving lock.
kdxcosdc:0
34
Number of index entries -does not include kdxbrlmc pointer.
kdxconro:8
35
Free space begin offset. kdxcofbo:0x002C (44)
36
Free space end offset.
 kdxcofeo:0x06BB (1723)
37
Available space in the block.
 kdxcoavs:1679
38
RDBA  if index value is less than the first (row#0) value).
kdxbrlmc: 0x03C0074D
39
 Size of usable block space.
 kdxbrsno:0
40
Last index entry to be modified.
kdxbrbksz:1916
41
 Begin data row address.
42
offset @0x770 (1904)
43
offset @0x6bb (1723)
44
 Begin free space
45
Row =7
46
The pointer to the  second leaf node in index. All value greater then or egual to col 0  belong in this leaf node.
RDBA: 0x03C00981 (file 15, block 2433)
47
len 22
48
"sun/io/CharToByteCp950"
49
RDBA
50
row =6
51
row =5
52
row =4
53
row =3
54
row =2
55
row =1
56
row =0
57
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:0x91B80601