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/25.html
Title: 25.LOB segment space usage index block  •  Size: 147050  •  Last Modified: Thu, 04 Feb 2010 15:48:32 GMT
25    BITMAP  INDEX   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 183418 maxblk 183418
00 191 022 003 004 7A CC C2 025 2E 97 06 00 00 006 017 048   buffer tsn: 12 rdba: 0x02c2cc7a (11/183418)
10 A6 D19 00 0010 00 00 00 0011 00 00 00 0012 00 00 00 00   scn: 0x0000.0006972e seq: 0x01 flg: 0x04 tail: 0x972e1901
20 00 00 00 00 FE13 FF FF FF FF FF FF FF FF FF FF FF   frmt: 0x02 chkval: 0xd1a6 type: 0x19=BITMAP INDEX BLOCK
30 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    free blocks:0
40 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    first free bmb:0
50 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FEFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
60 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
70 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
80 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
90 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
A0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
B0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
C0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
D0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
E0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
F0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
100 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
110 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
120 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
130 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
140 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
150 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
160 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
170 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
180 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
190 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
1A0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
1B0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
1C0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
1D0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
1E0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
1F0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
200 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
210 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
220 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
230 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
240 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
250 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
260 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
270 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
280 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
290 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
2A0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
2B0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
2C0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
2D0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
2E0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
2F0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
300 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
310 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
320 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
330 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
340 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
350 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
360 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
370 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
380 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
390 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
3A0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
3B0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
3C0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
3D0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
3E0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
3F0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
400 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
410 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
420 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
430 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
440 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   End dump data blocks tsn: 12 file#: 11 minblk 183418 maxblk 183418
450 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
460 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
470 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
480 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
490 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
4A0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
4B0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
4C0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
4D0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
4E0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
4F0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
500 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
510 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
520 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
530 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
540 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
550 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
560 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
570 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
580 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
590 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
5A0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
5B0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
5C0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
5D0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
5E0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
5F0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
600 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
610 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
620 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
630 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
640 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
650 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
660 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
670 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
680 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
690 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
6A0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
6B0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
6C0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
6D0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
6E0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
6F0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
700 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
710 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
720 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
730 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
740 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
750 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
760 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
770 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
780 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
790 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
7A0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
7B0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
7C0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
7D0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
7E0 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
7F0 FF FF FF FF FF FF FF FF FF FF FF FF 01 19 2E 9714    
 
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 183418;  
1
Block types.
type:0x19
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:0x02C2CC7A
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.0006972E
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:0xD1A6
10
spare3
11
Free blocks:0
12
first free bmb:0
13
Bitmap  begin.
14
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:0x972E1901