Re: fragmentation analysis

From: Yang <yg.yang_at_wanadoo.fr>
Date: Wed, 30 Jan 2002 19:30:15 +0100
Message-ID: <a39ds7$omg$1@wanadoo.fr>

Fragmentation pose problem of disk usage, not database perfomance. So Oracle suggests using SAFE method to database administration.

first, try to know what the 'user' is doing (sql query) when you feel "performance is slow"...
then, analyze his sql query
compare elapsed time to your hope (a long time dosn't mean poor performance) consider factors like disk i/o, network, OS parameter, Oracle parameter, index, statistiques, algorithme, ...

HTH
Yang

> A Wong <ajkwong5_at_hotmail.com> wrote in message
> news:OXM58.27240$jb.1418105_at_news2.calgary.shaw.ca...
> > what can I run to determine if the database is fragmented?
> > I've used TOAD, and analysed the tablespaces, and it seems okay...but
not
> > sure how indepth this goes into everything... performance is slow, and
I
> > can't figure out why.
> >
> >
>
>
Received on Wed Jan 30 2002 - 12:30:15 CST