Oracle-L: RE: Bitmap Header in a Uniform LMT?

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Sat, 10 Aug 2002 08:33:56 -0800
Message-ID: <F001.004B1512.20020810083356@fatcity.com>

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: kirti.deshpande_at_verizon.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 Sat Aug 10 2002 - 11:33:56 CDT