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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
