Re: My Ora is so slooooow...

"sean" <sean_at_kistem.po.my> wrote in message news:d4a915.0211251839.55b251fb_at_posting.google.com...
> 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.

That would be SYSTEM, I think. Not SYS.

> 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.
>

Despite what you may hear in other fields, size isn't important. The size of the datafiles has no bearing on speed of data retrieval.

> All these datafiles sit on ONE "Volume Set" (ie, one hard drive across 2
> HDD).
So you've got RAID 0? Two spindles (=hard disks) isn't that many, even so.

>Is it ok to delete all the ARC files from the RdoLog folder ?
>

No. You can safely delete only those archives which you know are not going to be needed for future recoveries. That means, if you perform a new, verified, backup, then archives produced prior to that archive are "dispensible". Still doesn't mean you can delete them, though: what happens if your last backup is lost/corrupted/deleted/trashed? You'll want to go back to the previous backup... and then you'll need the archives produced since *that* backup. Presumably, you're backing up your archives, though. Aren't you?

> How get the "explain plan" ?

I think you might need to do some reading of the documentation, since this is fairly basic (not meaning to be rude or imply anything). Take a trip to http://tahiti.oracle.com, and have a look around.

The short answer to your question is: explain plan for select * from emp;, followed by select * from plan_table; ...but that begs the question of how you get an explain plan, and how you interpret the results (have you got a week?).

>What is the "last rebuilt" means ?

I mean, NT is not the most stable platform in the world, and if this is a sudden and recent turn-down in performance (a question which you haven't answered) the answer could as much lie in the vagaries of NT as in anything you've done with the Oracle software. Nice clean fresh installs of NT tend to perform better than ragged old heaps of year-old NT installs that have had all manner of abuse at the hands of system administrators.

>How to get
> the report.txt from utlbstat and utlestat ?
>

Nope... we're really into basics here, and I can't give you the answer to that one. Report.txt is the output from running utlbstat and utlestat. And I could tell you where those scripts are (%ORACLE_HOME%\rdbms\admin as it happens) but it would get you nowhere. You *need* to know this stuff. Please visit tahiti.oracle.com and have a read of the Concepts manual and the Performance Tuning Manual at the very least.

Sorry if I seem curmudgeonly: the real point is that an unacceptable slowdown in the performance of your queries could be due to pretty much anything (except datafile size). You need to know how to diagnose such things. That's a week-long course at Oracle just for starters... so it's not possible to do it justice in a newsgroup post. Get the concepts under your belt, and you'll be able to produce output which, even if you can't make much headway with it, other people (here and elsewhere on the Internet) can, if it's posted.

Regards
HJR  --
> 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
Received on Tue Nov 26 2002 - 05:47:45 CST