Re: Decyphering LMT space bitmap

Thanks Jonathan.

>I think you'll find that generally the initial amount
>of file allocated is 64K (including the two header
>blocks) - the fact that you noted the bitmap was in
>the "next 6 blocks" suggests you were using an
>8K block size.

>The actual space allocated at file creation time
>is dependent on the file size, block size, and
>extent size.

I did the tests about 2 years ago and did notice that as you indicated that it depends on file size, block size and extent size and yes it was an 8K block and I did do the test for 16K block size and got the first 2 blocks for the header and then the next 2 for bitmaps

>If you have a very small block size, very small extents,
>and extremely large files then Oracle may allocate
>an extra 64K (and I guess further multiples of 64K
>if necessary).

I noticed that I got the maximum free extents tracked when I added an extra 64K to the file size. Unfortunately at that time I did not have enough disk space to create areal large file and a table with lots of extents.

>I have yet to find out what the typical behaviour is
>for a tablespace with a 32K block. I would guess
>that the total file header would be 128K rather than
>64K - 2 blocks for the general file header, 2 blocks
>for the bitmap. Could anyone confirm that, thanks ?

I will try and test that to see how Oracle allocates blocks.

Thanks once again.
Regards,

Madhavan

See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Madhavan Amruthur
  INET: mad5698_at_lycos.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).