Oracle-L: RE: Locally Managed Tablespaces

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 17 Apr 2003 06:16:50 -0800
Message-ID: <F001.00583CAB.20030417061650@fatcity.com>

Connor - Yeah, it wasn't the end of the world, just a humorous surprise that your posting reminded me of. That's about as humorous as things get around here. But I think you've made a good point, that even 1m uniform extents wouldn't take up all that much room.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, April 17, 2003 4:49 AM
To: Multiple recipients of list ORACLE-L

Isn't that "only" 1G though ? If that's "all his disk space", your SA needs to talk to the purchasing department

:-)

Connor

DENNIS WILLIAMS <DWILLIAMS_at_lifetouch.com> wrote:
> Jacques
> When we were first trying LMT, we got the extent
> size set wrong at 1M. We
> installed an ERP that creates about 1,000 tables.
> The SA wondered where all
> his disk space went!
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Wednesday, April 16, 2003 8:54 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).
>

Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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 Thu Apr 17 2003 - 09:16:50 CDT

RE: Locally Managed Tablespaces - Questions.