Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: "Goldilocks" repost, please?

RE: "Goldilocks" repost, please?

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Fri, 27 Sep 2002 13:23:38 -0800
Message-ID: <F001.004DBB67.20020927132338@fatcity.com>


Juan Loaiza, Rosanne Toohey, and Bhaskar Himatsingka. The paper's online at www.hotsos.com/catalog.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas

-----Original Message-----
Cherie_Machler_at_gelco.com
Sent: Friday, September 27, 2002 4:09 PM To: Multiple recipients of list ORACLE-L

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.


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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.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:23:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US