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/33.html
Title: 33.ASSM level 2 bitmap block  •  Size: 199015  •  Last Modified: Thu, 04 Feb 2010 15:48:32 GMT
33 SECOND LEVEL BITMAP BLOCK
 
  0 1 2 3 4 5 6 7 8 9 A B C D E F   Start dump data blocks tsn: 17 file#: 16 minblk 34 maxblk 34
00 211 022 003 004 22 00 00 045 C3 45 98 00 00 006 877 048   buffer tsn: 17 rdba: 0x04000022 (16/34)
10 B2 399 00 0010 00 00 00 00 00 00 00 00 00 00 00 00   HEADER scn: 0x0000.009845c3 seq: 0x87 flg: 0x04 tail: 0x45c32187
20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   frmt: 0x02 chkval: 0x39b2 type: 0x21=SECOND LEVEL BITMAP BLOCK
30 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   Dump of Second Level Bitmap Block
40 00 00 00 00 00 00 00 00 00 00 00 00 23 00 00 0411      number: 136     nfree: 1       ffree: 135    pdba:     0x04000023
50 88 00 00 0012 01 00 00 0013 87 00 00 0014 0015 00 00 00     opcode:0
60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    xid:
70 00 00 00 00 2116 00 00 0417 01 0018 01 0019 31 00 00 04     L1 Ranges :
80 01 00 01 00 41 00 00 04 01 00 01 00 51 00 00 04   L1 RANGES   --------------------------------------------------------
90 01 00 01 00 61 00 00 04 01 00 01 00 71 00 00 04      0x04000021  Free: 1 Inst: 1
A0 01 00 01 00 81 00 00 04 01 00 01 00 91 00 00 04      0x04000031  Free: 1 Inst: 1
B0 01 00 01 00 A1 00 00 04 01 00 01 00 B1 00 00 04      0x04000041  Free: 1 Inst: 1
C0 01 00 01 00 C1 00 00 04 01 00 01 00 D1 00 00 04      0x04000051  Free: 1 Inst: 1
D0 01 00 01 00 E1 00 00 04 01 00 01 00 F1 00 00 04      0x04000061  Free: 1 Inst: 1
E0 01 00 01 00 01 01 00 04 01 00 01 00 11 01 00 04      0x04000071  Free: 1 Inst: 1
F0 01 00 01 00 21 01 00 04 01 00 01 00 31 01 00 04      0x04000081  Free: 1 Inst: 1
100 01 00 01 00 41 01 00 04 01 00 01 00 51 01 00 04      0x04000091  Free: 1 Inst: 1
110 01 00 01 00 61 01 00 04 01 00 01 00 71 01 00 04      0x040000a1  Free: 1 Inst: 1
120 01 00 01 00 81 01 00 04 01 00 01 00 91 01 00 04      0x040000b1  Free: 1 Inst: 1
130 01 00 01 00 A1 01 00 04 01 00 01 00 B1 01 00 04      0x040000c1  Free: 1 Inst: 1
140 01 00 01 00 C1 01 00 04 01 00 01 00 D1 01 00 04      0x040000d1  Free: 1 Inst: 1
150 01 00 01 00 E1 01 00 04 01 00 01 00 F1 01 00 04      0x040000e1  Free: 1 Inst: 1
160 01 00 01 00 01 02 00 04 01 00 01 00 11 02 00 04      0x040000f1  Free: 1 Inst: 1
170 01 00 01 00 51 02 00 04 01 00 01 00 91 02 00 04      0x04000101  Free: 1 Inst: 1
180 01 00 01 00 D1 02 00 04 01 00 01 00 11 03 00 04      0x04000111  Free: 1 Inst: 1
190 01 00 01 00 51 03 00 04 01 00 01 00 91 03 00 04      0x04000121  Free: 1 Inst: 1
1A0 01 00 01 00 D1 03 00 04 01 00 01 00 11 04 00 04      0x04000131  Free: 1 Inst: 1
1B0 01 00 01 00 51 04 00 04 01 00 01 00 91 04 00 04      0x04000141  Free: 1 Inst: 1
1C0 01 00 01 00 D1 04 00 04 01 00 01 00 11 05 00 04      0x04000151  Free: 1 Inst: 1
1D0 01 00 01 00 51 05 00 04 01 00 01 00 91 05 00 04      0x04000161  Free: 1 Inst: 1
1E0 01 00 01 00 D1 05 00 04 01 00 01 00 11 06 00 04      0x04000171  Free: 1 Inst: 1
1F0 01 00 01 00 51 06 00 04 01 00 01 00 91 06 00 04      0x04000181  Free: 1 Inst: 1
200 01 00 01 00 D1 06 00 04 01 00 01 00 11 07 00 04      0x04000191  Free: 1 Inst: 1
210 01 00 01 00 51 07 00 04 01 00 01 00 91 07 00 04      0x040001a1  Free: 1 Inst: 1
220 01 00 01 00 D1 07 00 04 01 00 01 00 11 08 00 04      0x040001b1  Free: 1 Inst: 1
230 01 00 01 00 51 08 00 04 01 00 01 00 91 08 00 04      0x040001c1  Free: 1 Inst: 1
240 01 00 01 00 D1 08 00 04 01 00 01 00 11 09 00 04      0x040001d1  Free: 1 Inst: 1
250 01 00 01 00 51 09 00 04 01 00 01 00 91 09 00 04      0x040001e1  Free: 1 Inst: 1
260 01 00 01 00 D1 09 00 04 01 00 01 00 11 0A 00 04      0x040001f1  Free: 1 Inst: 1
270 01 00 01 00 51 0A 00 04 01 00 01 00 91 0A 00 04      0x04000201  Free: 1 Inst: 1
280 01 00 01 00 D1 0A 00 04 01 00 01 00 11 0B 00 04      0x04000211  Free: 1 Inst: 1
290 01 00 01 00 51 0B 00 04 01 00 01 00 91 0B 00 04      0x04000251  Free: 1 Inst: 1
2A0 01 00 01 00 D1 0B 00 04 01 00 01 00 11 0C 00 04      0x04000291  Free: 1 Inst: 1
2B0 01 00 01 00 51 0C 00 04 01 00 01 00 91 0C 00 04      0x040002d1  Free: 1 Inst: 1
2C0 01 00 01 00 D1 0C 00 04 01 00 01 00 11 0D 00 04      0x04000311  Free: 1 Inst: 1
2D0 01 00 01 00 51 0D 00 04 01 00 01 00 91 0D 00 04      0x04000351  Free: 1 Inst: 1
2E0 01 00 01 00 D1 0D 00 04 01 00 01 00 11 0E 00 04      0x04000391  Free: 1 Inst: 1
2F0 01 00 01 00 51 0E 00 04 01 00 01 00 91 0E 00 04      0x040003d1  Free: 1 Inst: 1
300 01 00 01 00 D1 0E 00 04 01 00 01 00 11 0F 00 04      0x04000411  Free: 1 Inst: 1
310 01 00 01 00 51 0F 00 04 01 00 01 00 91 0F 00 04      0x04000451  Free: 1 Inst: 1
320 01 00 01 00 D1 0F 00 04 01 00 01 00 11 10 00 04      0x04000491  Free: 1 Inst: 1
330 01 00 01 00 51 10 00 04 01 00 01 00 91 10 00 04      0x040004d1  Free: 1 Inst: 1
340 01 00 01 00 D1 10 00 04 01 00 01 00 11 11 00 04      0x04000511  Free: 1 Inst: 1
350 01 00 01 00 51 11 00 04 01 00 01 00 91 11 00 04      0x04000551  Free: 1 Inst: 1
360 01 00 01 00 D1 11 00 04 01 00 01 00 11 12 00 04      0x04000591  Free: 1 Inst: 1
370 01 00 01 00 51 12 00 04 01 00 01 00 91 12 00 04      0x040005d1  Free: 1 Inst: 1
380 01 00 01 00 D1 12 00 04 01 00 01 00 11 13 00 04      0x04000611  Free: 1 Inst: 1
390 01 00 01 00 51 13 00 04 01 00 01 00 91 13 00 04      0x04000651  Free: 1 Inst: 1
3A0 01 00 01 00 D1 13 00 04 01 00 01 00 11 14 00 04      0x04000691  Free: 1 Inst: 1
3B0 01 00 01 00 51 14 00 04 01 00 01 00 91 14 00 04      0x040006d1  Free: 1 Inst: 1
3C0 01 00 01 00 D1 14 00 04 01 00 01 00 11 15 00 04      0x04000711  Free: 1 Inst: 1
3D0 01 00 01 00 51 15 00 04 01 00 01 00 91 15 00 04      0x04000751  Free: 1 Inst: 1
3E0 01 00 01 00 D1 15 00 04 01 00 01 00 11 16 00 04      0x04000791  Free: 1 Inst: 1
3F0 01 00 01 00 51 16 00 04 01 00 01 00 91 16 00 04      0x040007d1  Free: 1 Inst: 1
400 01 00 01 00 D1 16 00 04 01 00 01 00 11 17 00 04      0x04000811  Free: 1 Inst: 1
410 01 00 01 00 51 17 00 04 01 00 01 00 91 17 00 04      0x04000851  Free: 1 Inst: 1
420 01 00 01 00 D1 17 00 04 01 00 01 00 11 18 00 04      0x04000891  Free: 1 Inst: 1
430 01 00 01 00 51 18 00 04 01 00 01 00 91 18 00 04      0x040008d1  Free: 1 Inst: 1
440 01 00 01 00 D1 18 00 04 01 00 01 00 11 19 00 04      0x04000911  Free: 1 Inst: 1
450 01 00 01 00 51 19 00 04 01 00 01 00 91 19 00 04      0x04000951  Free: 1 Inst: 1
460 01 00 01 00 D1 19 00 04 01 00 01 00 11 1A 00 04      0x04000991  Free: 1 Inst: 1
470 01 00 01 00 51 1A 00 04 01 00 01 00 91 1A 00 04      0x040009d1  Free: 1 Inst: 1
480 01 00 01 00 D1 1A 00 04 01 00 01 00 11 1B 00 04      0x04000a11  Free: 1 Inst: 1
490 01 00 01 00 51 1B 00 04 01 00 01 00 91 1B 00 04      0x04000a51  Free: 1 Inst: 1
4A0 01 00 01 00 D1 1B 00 04 01 00 01 00 11 1C 00 04      0x04000a91  Free: 1 Inst: 1
4B0 05 00 01 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000ad1  Free: 1 Inst: 1
4C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000b11  Free: 1 Inst: 1
4D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000b51  Free: 1 Inst: 1
4E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000b91  Free: 1 Inst: 1
4F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000bd1  Free: 1 Inst: 1
500 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000c11  Free: 1 Inst: 1
510 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000c51  Free: 1 Inst: 1
520 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000c91  Free: 1 Inst: 1
530 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000cd1  Free: 1 Inst: 1
540 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000d11  Free: 1 Inst: 1
550 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000d51  Free: 1 Inst: 1
560 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000d91  Free: 1 Inst: 1
570 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000dd1  Free: 1 Inst: 1
580 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000e11  Free: 1 Inst: 1
590 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000e51  Free: 1 Inst: 1
5A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000e91  Free: 1 Inst: 1
5B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000ed1  Free: 1 Inst: 1
5C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000f11  Free: 1 Inst: 1
5D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000f51  Free: 1 Inst: 1
5E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000f91  Free: 1 Inst: 1
5F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04000fd1  Free: 1 Inst: 1
600 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001011  Free: 1 Inst: 1
610 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001051  Free: 1 Inst: 1
620 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001091  Free: 1 Inst: 1
630 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x040010d1  Free: 1 Inst: 1
640 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001111  Free: 1 Inst: 1
650 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001151  Free: 1 Inst: 1
660 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001191  Free: 1 Inst: 1
670 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x040011d1  Free: 1 Inst: 1
680 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001211  Free: 1 Inst: 1
690 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001251  Free: 1 Inst: 1
6A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001291  Free: 1 Inst: 1
6B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x040012d1  Free: 1 Inst: 1
6C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001311  Free: 1 Inst: 1
6D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001351  Free: 1 Inst: 1
6E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001391  Free: 1 Inst: 1
6F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x040013d1  Free: 1 Inst: 1
700 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001411  Free: 1 Inst: 1
710 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001451  Free: 1 Inst: 1
720 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001491  Free: 1 Inst: 1
730 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x040014d1  Free: 1 Inst: 1
740 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001511  Free: 1 Inst: 1
750 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001551  Free: 1 Inst: 1
760 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001591  Free: 1 Inst: 1
770 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x040015d1  Free: 1 Inst: 1
780 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001611  Free: 1 Inst: 1
790 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001651  Free: 1 Inst: 1
7A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001691  Free: 1 Inst: 1
7B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x040016d1  Free: 1 Inst: 1
7C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001711  Free: 1 Inst: 1
7D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001751  Free: 1 Inst: 1
7E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00      0x04001791  Free: 1 Inst: 1
7F0 00 00 00 00 00 00 00 00 00 00 00 00 87 21 C3 4520      0x040017d1  Free: 1 Inst: 1
   0x04001811  Free: 1 Inst: 1
   0x04001851  Free: 1 Inst: 1
   0x04001891  Free: 1 Inst: 1
   0x040018d1  Free: 1 Inst: 1
   0x04001911  Free: 1 Inst: 1
   0x04001951  Free: 1 Inst: 1
   0x04001991  Free: 1 Inst: 1
   0x040019d1  Free: 1 Inst: 1
   0x04001a11  Free: 1 Inst: 1
   0x04001a51  Free: 1 Inst: 1
   0x04001a91  Free: 1 Inst: 1
   0x04001ad1  Free: 1 Inst: 1
   0x04001b11  Free: 1 Inst: 1
   0x04001b51  Free: 1 Inst: 1
   0x04001b91  Free: 1 Inst: 1
   0x04001bd1  Free: 1 Inst: 1
   0x04001c11  Free: 5 Inst: 1
 
  --------------------------------------------------------
End dump data blocks tsn: 17 file#: 16 minblk 34 maxblk 34
1
Block types.
type:0x21
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:0x04000022
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.009845C3
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:0x87
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:0x39B2
10
spare3
11
Parent  L3 BMB DBA.
pdba:0x04000023

12
Number of  L1 BMBs.
number:136
13
Number of  L1 BMBs with free blocks.
nfree:1
14
Number of L1 BMB no  free  blocks.
ffree:135
 
15
opcode:0
16
L1 DBA array:
-L1 data block address
-Instance it is mapped to
-Maximum freeness in any block

17
DBA:0x04000021
18
0000 - unformatted
0001 - logically full
0010 - <25% free space
0011 - 25-50%
0100 - 50-75%
0101 - >75%
Free: 0001 (1) -all  blocks  logically full

19
Inst: 1
20
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:0x45C32187