RE: "Goldilocks" repost, please?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 27 Sep 2002 13:18:32 -0800
Message-ID: <F001.004DBB1C.20020927131832@fatcity.com>

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.
dwilliams_at_lifetouch.com

-----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" <Rich.Jesse_at_qtiworld.com> 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
  > Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex,
  > WI USA
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Jesse, Rich
  > INET: Rich.Jesse_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).
  

  ---

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: wisernet100_at_yahoo.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.com
-- 
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 Fri Sep 27 2002 - 16:18:32 CDT