Re: Effects of framentation

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:4019033f$0$15135$afc38c87_at_news.optusnet.com.au...
>
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:vw6Sb.33453$Wa.29653_at_news-server.bigpond.net.au...
> > "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> > news:govf10t8cir11qio2g0rr56qhjqkbb9kg6_at_4ax.com...
> > > On 28 Jan 2004 07:04:00 -0800, murat.balkas_at_o2.com.tr (Murat Balkas)
> > > wrote:
> > >
> > > > How can I do that? How can I prove that queries answer too slow
> > > >because of the fragmentation.
> > >
> > > Fragmentation has no impact on performance unless you are using full
> > > table scans all over the place.
> > >
> >
> > Hi Sybrand
> >
> > Unless you have a ridiculously small extent size, one smaller than your
> > effective multiblock read, even "full tables scans all over the place"
are
> > not impacted by multiple extents.
> >
> > 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?
>
> Sometimes, I just cry myself to sleep...
>

Hi Howard,

Oh it's so I'm afraid. Be very afraid ....

Crying is definitely an option, but I find a large scotch, with a generous splash of chilled diet coke works best.

(Don't tell Daniel ;)

Cheers (and welcome back)

Richard Received on Thu Jan 29 2004 - 07:05:48 CST