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/26.html
Title: 26.LOB segment space usage bitmap block  •  Size: 150527  •  Last Modified: Thu, 04 Feb 2010 15:48:32 GMT
26     BITMAP 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 183419 maxblk 183419
00 1A1 022 003 004 7B CC C2 025 2E 97 06 00 00 006 047 048   buffer tsn: 12 rdba: 0x02c2cc7b (11/183419)
10 BE D29 00 0010 01 00 00 0011 04 00 00 0012 00 00 00 00   scn: 0x0000.0006972e seq: 0x04 flg: 0x04 tail: 0x972e1a04
20 00 00 00 00 00 00 00 00 00 00 00 00 E113 FF FF FF   frmt: 0x02 chkval: 0xd2be type: 0x1a=BITMAP BLOCK
30 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    begin:1 number:4
40 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   E1FFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFF
50 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF   FFFFFFFFFFFFFFFF 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
430 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 183419 maxblk 183419
440 FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF FF    
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 04 1A 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 183419;  
1
Block types.
 type:0x1A
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:0x02C2CC7B
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: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:0xD2BE
10
spare3
11
begin:1
12
number:4
13
Bitmap begin.
(1110 0001)
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:0x972E1A04