| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> [oracle-l] Re: Automatic or Uniform allocation
We need to start moving these discussions to freelists per Jared's note.
Brad - I agree with Ron. I think it is critical to read "How to quit defragmenting . . ." before making the change to ensure you clearly understand the concepts and receive the benefits. If someone on the list knows of a more recent paper, please post it.
With uniform extents, you eliminate tablespace fragmentation, in addition to Ron's points.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, January 22, 2004 9:49 AM
To: Multiple recipients of list ORACLE-L
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).
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 Jan 22 2004 - 19:49:25 CST
 |
 |