Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Automatic or Uniform allocation
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
-- 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