Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> database slowing down after few hours
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 Received on Thu Feb 05 1998 - 00:00:00 CST