| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Bitmap Header in a Uniform LMT?
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
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_at_CHA To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
SE cc:
Sent by: Subject: Bitmap Header in a Uniform LMT?
root_at_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: 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 Fri Aug 09 2002 - 15:33:28 CDT
 |
 |