| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> A peculiar problem with connections
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFFB29.B89CFBF0
Content-Type: text/plain;
charset="iso-8859-1"
Hi All,
We have 8.1.6 database on an NT server and we have webserver which accesses database. Due to some problems with the application on the webserver we have to bounce it once a week. When we bounce the connections to the database are still existing with the database forever. Over a period of time this connections pile up. Has anyone see this behavior. When we talked to oracle support they suggested us to put the sqlnet.timeout parameter to timeout the session. This would be a big overhead on the already exhausted system.
Any pointers on how this could be resolved would be appreciated.
Thx
Gautam
------_=_NextPart_001_01BFFB29.B89CFBF0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=262514619-31072000>Hi All,</SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=262514619-31072000></SPAN></FONT> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=262514619-31072000>We have 8.1.6 database on an NT server and we have
webserver which accesses database. Due to some problems with the application
on the webserver we have to bounce it once a week. When we bounce the
connections to the database are still existing with the
database forever. Over a period of time this connections pile up. Has
anyone see this behavior. When we talked to oracle support they suggested us to
put the sqlnet.timeout parameter to timeout the session. This would be a big
overhead on the already exhausted system. </SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=262514619-31072000></SPAN></FONT> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=262514619-31072000>Any pointers on how this could be resolved would be
appreciated. </SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2>Thx</FONT></DIV>
<DIV><FONT face="Comic Sans MS" size=2><STRONG>Gautam
</STRONG></FONT></DIV></BODY></HTML>
Received on Mon Jul 31 2000 - 14:58:39 CDT
 |
 |