RE: Stop defragmenting and start ...

  • From: Connor McDonald <hamcdc@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 11 Jun 2004 02:44:47 +0100 (BST)

I've got a newsgroup exchange saved from Tom Kyte around 1995/1996 suggesting 
lots of equally
sized extents, the only caveat being to make them quite large since 'maxextents 
unlimited' did not
exist yet.

Cheers
Connor

 --- Lex de Haan <lex.de.haan@xxxxxxxxxxxxxx> wrote: > Robyn,
> 
> I quickly checked my courseware archives,
> and for sure Cary Millsap talked about uniform extent sizes in 1996.
> to be more precise: he probably talked about this even before 1996,
> but my private collection does not contain any hard evidence :-)
> 
> Kind regards,
> Lex.
>  
> ---------------------------------------------
> visit my website at http://www.naturaljoin.nl
> ---------------------------------------------
> 
> 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Robyn
> Sent: Thursday, June 10, 2004 16:02
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Stop defragmenting and start ...
> 
> 
> Hello,
> 
> Can someone tell me when uniform extent sizing became a recommended
> practice?  The 'Stop defragmenting and Start Living' paper has a copyright
> date of 1998, and I remember implementing it on some databases back in
> 1999, but I was wondering if it there were earlier references to this
> approach.
> 
> Robyn
> 
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> > BEGIN:VCARD
> VERSION:2.1
> N:de Haan;Lex
> FN:Lex de Haan
> ORG:Natural Join B.V.
> TEL;WORK;VOICE:+31.30.2515022
> TEL;HOME;VOICE:+31.30.2518795
> TEL;CELL;VOICE:+31.62.2955714
> TEL;WORK;FAX:+31.30.2523366
> ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
> LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 
> 3583
> SK=0D=0ANetherlands
> URL;WORK:http://www.naturaljoin.nl
> EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
> REV:20040224T160439Z
> END:VCARD
>  

=====
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@xxxxxxxxx

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, 
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------


        
        
                
___________________________________________________________ALL-NEW Yahoo! 
Messenger - sooooo many all-new ways to express yourself 
http://uk.messenger.yahoo.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: