Oracle on Windows Server - a lil' help?

Guys & Gals,
 
I've got a situation where Oracle doesn't recognize disconnected apps on
Windows 2003 server.  Every time a machine reboots or power goes out, or
users terminate an app, it leaves the session connected to the db,
eating up our available processes (500).
 
I've check the SQLNET.ORA EXPIRE_TIME parameter and that doesn't seem to
resolve the issue.
 
I think there are some TCP parameters on the db server itself that need
to be adjusted?  Has anyone run into this and successfully corrected it?
 
Any good documents you would like to share?  I think I have the Metalink
document on tuning windows servers for Oracle databases...going to try
to dig it back up.
 
Thanks!!
 
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx

Other related posts: