Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Automatic or Uniform allocation

Re: Automatic or Uniform allocation

From: <chris_at_thedunscombes.f2s.com>
Date: Fri, 23 Jan 2004 00:59:25 -0800
Message-ID: <F001.005DDED8.20040123005925@fatcity.com>


Ron,

I agree, uniform sizing is best. I hardly ever use automatic except for small development databases and small "MISC" tablespaces and even then I think "Why didn't I use use uniform 64K ?"

Cheers,

Chris

Quoting Ron Rogers <RROGERS_at_galottery.org>:

> Brad,
> For LMT's I prefer uniform sizing that I can define to meet the needs
> of the data. If you use automatic the extend sizes will change
> drimatically as the number if extends increase. With a little planning
> you can have little waste in the tablespace and use the tablespace for
> multiple tables of the same size requirements.
> We have used the partitioning and LMT's for the yearly data we have,
> about 5 gig per table per year and the extend count is only around 100
> with minimal free space. It makes it easier in the planning stage if you
> can keep it simple.
> Ron
>
> >>> Brad.Odland_at_qtiworld.com 01/22/2004 10:14:34 AM >>>
> for LMTs...
>
> Advantages in uniform versus automatic?
>
> Uniform 5 MB? 10 MB.....100MB etc....
>
>
> thoughts would be appreciatd....
>
> Thanks
>
> Brad
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Odland, Brad
> INET: Brad.Odland_at_qtiworld.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: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> 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).
>

Chris Dunscombe

chris_at_thedunscombes.f2s.com



Everyone should have http://www.freedom2surf.net/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: chris_at_thedunscombes.f2s.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 Fri Jan 23 2004 - 02:59:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US