[olug] Closing Socket Connections

[Terry]

Try the 'timeout' parameter in your listener.ora.  It
is the time in minutes that an inactive prespawned
dedicated server process waits for the next
connection. The value should be greater than 0. (A
value of 0 enables an inactive shadow process to
continue indefinitely, thus wasting machine
resources.) Set a short time-out value. The time out
is activated only after a prespawned dedicated server
process has carried a connection and been
disconnected. In other words, prespawned dedicated
servers that are waiting for their first connection do
not time out. 

The key phrase here is 'the time out is activated only
after a prespawned dedicated server process has
carried a connection and been disconnected.'.  If you
have a web application that does not handle closing
connections properly, then this could be your culprit.

You could cron up a restart of the listener every
night.  :)  How about that for a crappy resolution? 




--- Dave Hull <dphull at insipid.com> wrote:
> Quoting Terry <td3201 at yahoo.com>:
> 
> > Are all of the established connections you are
> > referring to related to Oracle?
> > netstat -anp might be useful too.
> 
> Yes. I actually did a netstat -aepn. All of the
> connections I'm concerned about
> are to the tnslistener. I have talked to the
> user/developer who the connections
> belonged to and he says it may be a problem with his
> code, but he's also the one
> who told me about the setting on Sun systems where
> one can automatically close
> idle connections.
> 
> >From what I've read the SO_KEEPALIVE option will
> start sending probes to the
> client connection after it's been idle for so long.
> If the client doesn't
> respond in a timely manner and after the set number
> of probes have been sent,
> then the connection is closed.
> 
> Now I need to find out where to enable this feature.
> 
> -- 
> Dave Hull
> http://insipid.com
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> http://lists.olug.org/mailman/listinfo/olug


=====
Terry

__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster
http://search.yahoo.com