Getting no responses on this, I created a test 9.0 database on my NT 4.0 workstation, with a block size of 4K. My observations are :
While creating a LMT with uniform extents of size 16K, the minimum datafile size has to be 25K. With uniform extents of size 32K, the datafile size has to be more than 41K, and with uniform extents of size 64K, the minimum datafile size is 73K. Thus, the size of the datafile should be atleast 2 blocks more than the uniform extent size. SQL> create tablespace mult 2 datafile 'd:\mult7.dbf' size 10M, 3 'd:\mult2.dbf' size 41K, 4 'd:\mult3.dbf' size 73K, 5 'd:\mult4.dbf' size 128K, 6 'd:\mult5.dbf' size 1024K, 7 'd:\mult6.dbf' size 2048K 8 extent management local uniform size 32K 9 / Tablespace created. SQL> select * from dba_free_space where tablespace_name='MULT'; TABLESPACE_NAME FILE_ID BLOCK_ID BYTES -------------------- ---------- ---------- ---------- ---------- ------------ MULT 9 17 10420224 2544 MULT 10 4 32768 8 MULT 11 4 65536 16 MULT 12 17 65536 16 MULT 13 17 983040 240 MULT 14 17 2031616 496 6 rows selected. And right now, I have the answer to all my questions. Also, I strongly recommend visiting http://www.performance-insight.com/ora3_back.html and look at the topics on locally managed tablespaces. I was impressed. That was what helped me get to the right answers. Regards Raj Rajesh Rao/CHASE@CHA To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> SE cc: Sent by: Subject: Bitmap Header in a Uniform LMT? root@fatcity. com August 09, 2002 02:28 PM Please respond to ORACLE-L I asked this question the other day, but got no replies. I make one more attempt and rephrase the question. A curious mind wants to know " Assuming a block size of 2K, what would be the size of the bitmap header if I create a uniform LMT with datafiles of size 32K, 64K, 100K, 1M and 64M?" Metalink has not given me any definite answer as yet, and the notes there have confused moi. Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
