Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Stop defragmenting and start ...
I don't think 160KB is silly given that _bump_highwater_mark_count (sp?)
defaults to 5. I know it looked weird to a lot of people, but once you
consider that Oracle moves the highwater mark moves in increments of 5 (and
this is a sensible value), the silly thing is how people set their
multiblock read count to a power of 2.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 6/22 Pittsburgh, 7/20 Cleveland, 8/10 Boston - SQL Optimization 101: 5/24 San Diego, 6/14 Chicago, 6/28 Denver - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Mogens Nørgaard
Sent: Thursday, June 10, 2004 4:39 PM
To: oracle-l_at_freelists.org
Subject: Re: Stop defragmenting and start ...
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
> -----------------------------------------------------------------
-- 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 - 21:06:23 CDT
![]() |
![]() |