Re: Performance problem

Quick'n'dirty answer:
Increase your DB_BLOCK_BUFFERS in the init.ora file. This specifies how much data is cached.

Realistic answer:
Read up on performance tuning docs, try a search engine like google.com to search on performance tutorials.

Newsgroups answers are usually best suited a specific problem, saying that the database isn't performing very well is very broad -- there are a lot of parameters you can tune.

Have fun!
- Jason

Solo wrote:

> 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

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Sat Jul 21 2001 - 16:26:46 CDT