You need to get a book on tuning and do a little reading. There are a lot
of different possibilities. For example,you could start out with plenty of
room in the shared pool but have it fill up to the point where page swapping
was occurring after a few hours of operation.
<mcui_at_cc.usu.edu> wrote in message news:$un2HlmtetjS_at_cc.usu.edu...
> We have a Oracle Database running at varying speed. Sometimes it is
running
> fast and sometimes it is running very slow. When the NT server is
restarted,
> it is running faster. Is there any tool for me to monitor the network
traffic
> and monitor the Oracle server. What kind of procedure should I follow to
solve
> this speed variations?
>
> Thanks in advance,
>
> Muyi Cui
> Dentrix Inc
> l
Received on Tue Jul 20 1999 - 17:48:06 CDT
