Re: Performance problem

I experienced something similar.

It was on a PIII with loads of memory (1GB I believe) and just Oracle running. Our mistake was that we let a few VB programs run on the server as well. In itself lightweight VB apps but they were polling the database all the time hence processor as busy about70-80% all of the time.

We learned that on a PC architecture CPU needs to drop below 30% or so to let at low level data caches to be flushed to disk. If CPU keeps above this point the data will build up and the database will get progressively show. We saw processor time being 80% at first, slower and slower database as we went along over a 5 minutes period say, then everything got soo slow virtually halting everybodies sessions (25-50 users). CPU dropped on the server below 30% and data was flushed to disk. After that performance was ok again for a few minutes before the whole things started again.

We learned to have nothing on the server running apart from the DB itself. Give the DB nice disks each with its own controller and large cache.

Hope this helps,

--
Gerrit-Jan Linker
SQL*XL: addin for Excel for easy access to Oracle databases
http://www.oraxcel.com


"Solo" <bsddd_at_hotmail.com> wrote in message
news:9hv0jh$1ade$1_at_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

>

>