Re: Effects of framentation

"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.
>
> 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 ?
>
> Cheers
>
> Richard

Richard, as someone who browses the metalink forum on a regular basis I am of the opinion that the quality of the responses has dropped. There was a definite noticable change sometime last year. I seem to think it was 3 to 6 months back.

Another problem is that the Oracle support ID pattern does not seem to be protected as I have seen very basic questions posted by users with Oracle style IDs. It is possible the users were new developers, but it makes you wonder.

IMHO -- Mark D Powell -- Received on Thu Jan 29 2004 - 09:00:02 CST