Re: Performance problem

Tuning is a complicated process, but you signs are pretty convincing that DB_BLOCK_BUFFER needs increased.

Get these parameters from v$sgastat
select name,value from V$SGASTAT where name class =8;

Find the consistent gets, db block gets and phyical reads. 100-100*(physical reads/(consistent gets+db block gets + physical reads)) if less than 95% increase db_block_buffers.

If less than 70% (I suspect you are below that) Double the number you have. Keep increasing this number (one bouce at a time) until you are greater than 95% for 1 full day.

You can use utlbstat/utlestat to monitor snapshots during the day.

"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
>
>
Received on Mon Jul 09 2001 - 11:17:04 CDT