Re: Performance problem

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

Look at the waits in the system:

select * from v$system_event;

Look at memory allocation:

select * from v$sga;
select * from v$sgastat;

purchase Performance Tuning 101 by Gaja & Kirti.

have fun reading.

Paul Received on Sat Jul 21 2001 - 16:28:54 CDT