Re: fragmentation analysis

From: Keith Boulton <kboulton_at_ntlworld.com>
Date: Wed, 30 Jan 2002 09:21:53 -0000
Message-ID: <mSO58.40926$4i5.5465349@news11-gui.server.ntli.net>

Fragmentation of the database is highly unlikely to be the cause of the problem you describe.

The fact that it's only some application accounts and not others also seems to indicate an application problem, rather than a server problem.

In toad, you can use the view/trace sga option to see poorly performing sql statements which might show the cause of the problem.

If that doesn't help, you need to trace the sql statements in the logon process to see what is happening. The performance tuning manual discusses how to do this and how to analyse the results.

Of course, it may not be a sql/oracle problem at all.

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 - 03:21:53 CST