Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> database slowing down after few hours

database slowing down after few hours

From: Prosibel <kvdv_at_mail.dma.be>
Date: 1998/02/05
Message-ID: <6bd1ku$9cu$1@pluto.interpac.be>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US