Re: "Goldilocks" repost, please?

From: <Cherie_Machler_at_gelco.com>
Date: Fri, 27 Sep 2002 13:08:31 -0800
Message-ID: <F001.004DBAAF.20020927130831@fatcity.com>

For what it's worth, we use 128k, 4m, and 128m. Those numbers were taken from the paper "How to Stop Defragmenting and Start Living". Can't remember the author but I'm sure someone will chime in as it's a well-known paper.

Cherie Machler
Oracle DBA
Gelco Information Network

                                                                                                              
                    Rachel                                                                                    
                    Carmichael           To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>  
                    <wisernet100_at_y       cc:                                                                  
                    ahoo.com>            Subject:     Re: "Goldilocks" repost, please?                        
                    Sent by:                                                                                  
                    root_at_fatcity.c                                                                            
                    om                                                                                        
                                                                                                              
                                                                                                              
                    09/27/02 03:08                                                                            
                    PM                                                                                        
                    Please respond                                                                            
                    to 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: 
  INET: Cherie_Machler_at_gelco.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:08:31 CDT