Re: Stop defragmenting and start ...

From: Mogens Nørgaard <mln_at_miracleas.dk>
Date: Thu, 10 Jun 2004 23:39:15 +0200
Message-ID: <40C8D503.8080504@miracleas.dk>

Cary thought about it, and argued for many equally sized extents. Another guy - Stern? Stein? - inside Oracle wrote an excellent article where he used the metaphor of tiles on the bathroom floor, I think. Did not Tim Gorman also mumble about this stuff on the Oracle HelpKern list?

The trouble with Juan's paper initially was the rather silly 160K sizes, etc. to compensate for the rounding stuff. With LMT's that need disappeared and we could go back to 128, etc. At least that's how I remember it.

Mogens

Lex de Haan 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Robyn
> Sent: Thursday, June 10, 2004 16:02
> To: oracle-l_at_freelists.org
> 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_at_freelists.org
> 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
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org 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
-----------------------------------------------------------------

Received on Thu Jun 10 2004 - 16:36:06 CDT