Re: My Ora is so slooooow...

Thank you for your inputs...

Besides the three DATA datafiles I have mentioned, yes, there were 3 other files ie, IND, TMP and SYS datafiles. And because the data retrieval was intermittently slow on the client side, so I just give a try by increase the size of the DATA datafiles. From a total of 600MB to 1.2GB.

All these datafiles sit on ONE "Volume Set" (ie, one hard drive across 2 HDD). Is it ok to delete all the ARC files from the RdoLog folder ?

How get the "explain plan" ? What is the "last rebuilt" means ? How to get the report.txt from utlbstat and utlestat ?

--
Regards,
Sean_at_Denote
26-Nov 8.35a

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<wWkE9.83412$g9.235203_at_newsfeeds.bigpond.com>...


> 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