Oracle-L: RE: Locally Managed Tablespaces

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 16 Apr 2003 17:53:36 -0800
Message-ID: <F001.00583934.20030416175336@fatcity.com>

I guess that's true too. Let's suppose I have for example 20 tables that would fit into a 64K extent (the smallest extent size in an autoallocate tablespace), but for each of those I use 1M. The wasted space would be 20 * (1024K - 64K) = approx. 19M Is that "a little" wasted space? Depends on your point of view.

-----Original Message-----

Then again, with Conner's suggestion of having just the one extent size of 1m, you only have the choice of one tablespace. A little wasted space for tiny tables and partitioned tables for the real biggies.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Wed Apr 16 2003 - 20:53:36 CDT

RE: Locally Managed Tablespaces - Questions.