Re: PUBLIC:Re: 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!

You might be running into the 7.3 EPC problem. Ensure EPC_DISABLED is TRUE for the instance and for SQLNET. Oracle has a bulleting on this topic. Received on Mon Feb 09 1998 - 00:00:00 CST