Re: Oracle on Windows Server - a lil' help?

SQLNET.EXPIRE_TIME didn't work on older versions of Oracle on windows - I think 9.2 fixed it, but it may have been 10.1.

On Wed, Oct 8, 2008 at 3:22 PM, Taylor, Chris David < Chris.Taylor_at_ingrambarge.com> wrote:

> 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_at_ingrambarge.com
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l