From Stephen_Karniotis@compuware.com Wed, 16 Jan 2002 07:06:03 -0800 From: "Karniotis, Stephen" Date: Wed, 16 Jan 2002 07:06:03 -0800 Subject: RE: Why doesn't Oracle kill dead connections? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Much of this is controlled through Oracle’s SQL*Net product.  It needs to be configured.  It also depends on what version of the database you are using.  Oracle8.0/8i and beyond have mechanisms called profiles (oracle7 had them as well but didn’t work well) that can assist in dead connection detection.   The problem with Web-based dead connection is that if the application server retains the connection, the stuff will work.  However, if the application server has started the SQL/PL/SQL process and then goes off to do other work, and return back, the dead connection stuff may disconnect you by accident.   Guess it is trial and error.