Please resend link?
-----Original Message-----
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 10, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bitmap Header in a Uniform LMT?
Rajesh,
I did visit the link you mentioned.
Nice and concise information on LMT (and other things as well).
Thanks for posting the link.
- Kirti
-----Original Message-----
Sent: Friday, August 09, 2002 3:33 PM
To: Multiple recipients of list ORACLE-L
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
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).
