Re: My Ora is so slooooow...

"sean" <sean_at_kistem.po.my> wrote in message news:ars7qe$a5n$1_at_news5.jaring.my...
> Hi All,
>
> I have a little problem with my Oracle 7.3.4 running on Win NT4 platform.
>
> The client users are having intermittent slowness when retrieving data
from
> oracle. It can go as slow as 3minutes. I have just double the size of all
> the 3 datafiles. That does not seem to improve data retrieval at all.
>
> Whatelse can I do to speed-up ? Is there datafile alignment utility ? or
> recreate indexes ? Where to check to see where is the lock-up ?
>

There's very little to go on here, Sean (apart from the obvious that you are working on a woefully out of date version of Oracle).

I just wanted to ask why you've only got three datafiles and why you would think that increasing their size would speed things up? You should have at the very minimum six: SYSTEM, TEMP, RBS, DATA, INDXS, OTHER (sometimes called TOOLS). ARe the files on the same hard disk? How many redo log groups do you have, how big are they, and how often are they switching? Are you archiving, and how is ARCH coping if so?

And what do you mean by, and expect from, a datafile alignment utility?

Indexes very rarely need to be rebuilt, so that's a non-starter, probably.

Have things always been this bad? Or is it only since you increased the size of the datafiles (which actually won't make the slightest bit of difference). How's your SQL code? Has it changed of late? Have you checked the explain plan for common SQL statements? Are there any major processes running when the intermittent slowdown happens?

What are the specs. of the machine. When was the machine last rebuilt? What's its current uptime?

What does your report.txt look like, after having run utlbstat and utlestat? What did www.oraperf.com make of your report.txt?

And so on and on.

Regards
HJR
> --
> Regards,
> Sean_at_Denote
> 25-Nov 11.47a
>
>
Received on Mon Nov 25 2002 - 02:20:14 CST