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

Hi Richard

Last week I had a nasty experience with some Oracle support dude following the current trend in the industry to always blame someone else and covering your ass as soon as possible. Basically he refused to analyze a systemstate dump made to investigate locking issues, 'because it's the application,stupid'.
I could talk what I wanted, it seemed to me quite clear he didn't knew what he was talking about (There where no table locks present, but library cache locks all over the place). Strange thing is: I am more and more avoiding to submit iTars. Usually, if the problem is not already described on Metalink, they don't know how to help you out.

Regards
Sybrand Bakker
Senior Oracle DBA Received on Thu Jan 29 2004 - 09:21:09 CST