Re: Oracle 8 performance

Thierry-

When you say "degradation a long the time...", well, what exactly does that mean? Performance has slowly degraded over a long period of time? If so, you may be dealing with a capacity problem rather than a performance problem. Bigger box, faster CPUs, more disk, etc.

Start by checking the underlying hardware and operating system. Use the NT tools to see if you are CPU, disk or memory bound. Is there available CPU to the Oracle instance? If not, then take care of that problem first. Same with disk and memory. Also, check the network and any client workstations or application servers. If you don't know how to do these things, get help.

Then, install and run Statspack. Takes about 4 minutes if you read the doc. Run it at regular intervals, say 1/2 hour apart. From a busy period, run a report and look at the top five wait events.

Forget about buffer cache hit ratio, library cache etc. Look at wait events. The top wait event is your worst bottleneck. Deal with it first.

Read the Oracle performance manual that comes with the doc set. If you are completely lost, post a statpspack report here, zipped. Check Metalink for articles on using and analyzing performance with Statspack.

Anyway, that is a starting place. If you really don't understand this stuff, get help. And ignore the idiots who tell you to start by looking at various "hit ratios".

• ricky

Thierry wrote:
>
> Hi,
>
> I have a Oracle8i database on WNT 4.0
> I have have slow performances, with degradation a long the time...
> What are the steps to analyse it ?
>
> defragmentation ? how ?
> Index ? how ?
> Exp/imp ?
>
> Have some URL where I can find these kind of informations ....
>
> Thanks
Received on Mon Nov 12 2001 - 17:26:12 CST