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@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 //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
