Performance problem

From: Solo <bsddd_at_hotmail.com>
Date: Sat, 21 Jul 2001 21:26:40 GMT
Message-ID: <9hv0jh$1ade$1@as201.hinet.hr>

First let me say I am new in Oracle;

Here is problem:

I have a machine server :2*400MHz Intel Xeon, 640MB ,3*4GB HDD, WinNT 4.0 sp6, Oracle Server 7.3.4, about 100 users connecting on it....

Recently we got incresed amount of job and data, and performance of server are significantly decresed.

Most of the time processors are about 60-80% busy in peaks, RAM is only about 35%used,
but hard disks are working like crazy.

My question is:
What can I do to make better performance ? Should I do something to use big amount of RAM wich I have free?
Increase "Shared pool size" maybe? Or something else?

I understand this is complex thing to manage, and I am sure that for any opinion much more information is needed, but I kindly asking you for some tips in which directions I should search for solutions.

Any help is highly appreciated !

Tanks,
Tony Received on Sat Jul 21 2001 - 16:26:40 CDT