Re: Effects of framentation

The funny thing is people think of oracle attached to san the same as their pc with one drive and M$ disk defrag. Try to explain the SAME SAN config to these people (usually management) and the fact that, even with one extent on the SAN, you're on many disks with many controllers, and your "single scan, one read pass through" is actually hitting several different physical platters. It's actually enough to blow their minds.

But, they enjoy the pretty pictures (OEM Tablespace map) of one "contiguous" extent. Go figure.

<snip for bandwidth>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:4019033f$0$15135$afc38c87_at_news.optusnet.com.au...
>

 > > I've just had (yet another) "disagreement" with an Oracle Support dude on a
> > metalink forum who suggested that multiple extents are bad, one extent is
> > optimal.
>
> You're kidding me, right?? Say it ain't so!!
>
> What in God's name is Oracle doing allowing that sort of version 5 rubbish
> to be spouted these 10g days?
Received on Thu Jan 29 2004 - 12:56:48 CST