Re: Effects of framentation

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 29 Jan 2004 23:57:34 +1100
Message-ID: <4019033f$0$15135$afc38c87@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...

> Whilst on Oracle Support, is it just me, or has the quality of advice and
> information from Oracle Support on their forums slumped to diabolical
> proportions ?

"Slumped" implies degeneration over time, which itself implies that at one time it was good. Not entirely convinced that that was ever really the case... but you can call me an old cynic if you wish!

Regards
HJR

-- 
------------------------------------
Oracle insights at www.dizwell.com
------------------------------------

Received on Thu Jan 29 2004 - 06:57:34 CST