Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: "Goldilocks" repost, please?
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.
-- 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
![]() |
![]() |