Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problem
Others will doubtless come up with more expert answers, but I would start by
investigating the utlbstat.sql and utlestat.sql scripts. They give you an
overall first impression of DB performance and whether there are any issues
with your instance.
Using them doesn't have a big performance hit either, which is the
disadvantage of going straight to tracing with a production system.
If you don't know what these scripts are, there's plenty of info. to be had
on the net about them. Happy reading :-)
hth
adam
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
>
>