Rich - The paper that started it all (as far as I know), "How to Stop Defragmenting and Start Living" posted at: http://otn.oracle.com/deploy/availability/pdf/defrag.pdf Suggests for Oracle 8 and above that the uniform extents be one of three sizes: 128k, 4m, and 128m, and it explains why you should stick to those sizes. The hard part is getting away from your old habit of trying to keep to the minimum number of extents. If your table is 3-meg, you tend to want to stick it in a tablespace with the 4m extents so it all fits in a single extent. But then if the file expands past 4m, you get another 4m extent that is mostly empty.
Old habits are hard to change. Or is it just old DBAs? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Friday, September 27, 2002 3:08 PM To: Multiple recipients of list ORACLE-L I'm here.. was away for a day but you guys flood my inbox :) goldilocks was the name I gave to the methodology of "small"/"medium"/"large" tablespace sizing. There was no hard and fast rule for how big each of these tablespaces should be, nor was there one for the extent sizes. Just that if a table was too big for "small" and too small for "big" then medium would be "just right", just like Goldilocks. --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > Can someone please repost the Goldilocks LMT Sizing Guideline? I > can't find > it in the fatcity.com archives (search is subject-only!), and I'm > guessing > that Rachel's offline, given Her recent post. > > As I'm delving into this, I seem to remember from those posts that > we're too > small for a Papa Bear LMT, but I don't remember what the posted > guidelines > were. > > TIA! > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, > WI USA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).