Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> LMT and what is the Bitmap Header Size?

LMT and what is the Bitmap Header Size?

From: <Rajesh.Rao_at_jpmchase.com>
Date: Thu, 08 Aug 2002 10:36:05 -0800
Message-ID: <F001.004AF718.20020808103605@fatcity.com>


I have been struggling to find the right answer to the question: What is the bitmap header size for a uniform extents LMT? 64K, 1 block, 2 blocks????

I find one note on Metalink (Note: 111666.1) that says its 64K .

Mr.Jonathan Lewis says " A quirky little detail about bitmap sizes also came up recently on the Oracle-L mailing list. If you define a very small tablespace - in this context 'very small' means something between 5 blocks and '64K plus one extent' then Oracle will give you a bitmap of just one block - which still allows you to grow the file quite comfortably, of course."

Then another example on Metalink (Note: 109630.1) which goes:

                                                                                                                  
                                                                   SQL> create tablespace mult                    
                                                                     2  datafile                                  
                                                                   '/oracle2/OFA_base/u02/oradata/V816/mult1.dbf' 
                                                                   size 100k,                                     
                                                                     3                                            
                                                                   '/oracle2/OFA_base/u02/oradata/V816/mult2.dbf' 
                                                                   size 100k                                      
                                                                     4  extent management local uniform size 50K; 
                                                                                                                  
                                                                   Tablespace created.                            
                                                                                                                  
                                                                   SQL> select                                    
                                                                   tablespace_name,file_id,block_id,blocks        
                                                                     2   from dba_free_space                      
                                                                     3  where tablespace_name='MULT' ;            
                                                                                                                  
                                                                   TABLESPACE_NAME                   FILE_ID      
                                                                   BLOCK_ID     BLOCKS                            
                                                                   ------------------------------ ----------      
                                                                   ---------- ----------                          
                                                                   MULT                                   15      
                                                                   4         25                                   
                                                                   MULT                                   16      
                                                                   4         25                                   
                                                                                                                  
                                                                   BLOCK_ID=4 : In an ordinary datafile, the      
                                                                   first block where to store data is             
                                                                                block 2.  Therefore, two more     
                                                                   blocks are reserved for the header             
                                                                                bitmap of the locally managed     
                                                                   datafile.                                      
                                                                   BLOCKS=25  : The datafile has a size of 100K   
                                                                   which equals 50 blocks in this                 
                                                                                database =>                       
                                                                                There are only 25 blocks (local   
                                                                   uniform size 50K)left for data                 
                                                                                starting at block n°4, then 22    
                                                                   blocks are unused.                             
                                                                                                                  

=> Header bitmap = 2 blocks for each datafile

Moi Confused. Whats the definite word on this? Should be something like if the datafile size is x, then its n, else its some other number.

Thanks
Raj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Rajesh.Rao_at_jpmchase.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Aug 08 2002 - 13:36:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US