"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 ?
I had an analyst ask if the system was production and when hearing that it
was say 'OK we won't update X$... directly' recently. Is that good or bad?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Jan 29 2004 - 06:06:56 CST
