you could try running utlbstat and utlestat and posting the report.txt - or
better still post a url to the report.txt. Leave a decent interval between
starting the stats collection and finishing it
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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 Sat Jul 21 2001 - 16:28:40 CDT
