title: IDLE timeout parameter in Oracle
body: <p>We are stuck in a situation where one of our processes is taking 3 hours of computing without touching the database. The connection that was taken before calling the process gets closed by the <a href="http://en.wikipedia.org/wiki/Oracle_Database" rel="noreferrer">Oracle</a> server and any subsequent query or commit throws connection closed exception.</p>
  
  <p>It appears to us that the problem is related to Oracle closing the connection that is idle for that long for some reason.</p>
  
  <p>We tried changing EXPIRE_TIMEOUT in sqlnet.ora but that didn't help either.</p>
  
  <p>What can we do to resolve this problem?</p>