PUBLIC:Re: database slowing down after few hours

Prosibel wrote:
>
> We have a lan with one NT4 Server and a few Win95 workstations. We use
> TCP/IP and Netbeui, CentreCOM 3624TR 10Base-T HUB/repeater and UTP cable.
> The server is running : Oracle7 Workgroup Server 7.3.2.2.1 and a database
> written in Visual Basic.
> The Win95 workstation is running : database clients software, Oracle7 16bit
> ODBC Driver 2.0.3.1.1 and Oracle SQL*Net Client 2.3.2.1.4.
> First, the database works fine but after a few hours the responses are
> getting very slow. When using TNGPing : every 7th ping i receive something
> of 3400 or 9700 ms ! (regular Ping gives 1-10ms tho...)
> The server has enough memory and the processor activity is normal.
> The strange thing is : when i REBOOT the server, everything is back to
> normal ! TNGPing gives 0 - 60ms. The database is working fine. After a few
> hours ... everything slows down again!
>
> Anyone got a clue ?
>
> Kris

Hi Kris

Did you look at the memory (used up, increased swapping, etc.) ? I had once a system (unix) where the application used up the memory (and didn'r release it).
That fact that after a reboot everything is "fine" , but after several hours of running the response is almost nill, seems to me a clasic memory problem.

rgds
eugen Received on Fri Feb 06 1998 - 00:00:00 CST