On Wed, Oct 8, 2008 at 1:25 PM, Taylor, Chris David < Chris.Taylor@xxxxxxxxxxxxxxx> wrote: > Doesn't seem to work on 10.2 on Windows 2003 either :) Supposedly > EXPIRE_TIME=1 is supposed to work, but doesn't seem to. > > > *Chris Taylor* > *Sr. Oracle DBA* > Ingram Barge Company > Nashville, TN 37205 > Office: 615-517-3355 > Cell: 615-354-4799 > Email: chris.taylor@xxxxxxxxxxxxxxx > Chris, Environment: Server OS MS Windows 2003 R2 SP2 32 bit Oracle 10g R2 Standard Edition, 10.2.0.4 patchset, 32 bit. No one-off patches. sqlnet.ora for the server: sqlnet.expire_time=1 This in fact does enable the timer functionality for dead connection detection. It does not work for values such as sqlnet.expire_time=10 that is referred to in the metalink documentation. If you set the trc_level = support you will be able to observe the timer being set in the trace file. Do you have the 10.2.0.4 patchset in place on the database server on the ORACLE_HOME of interest, including the ORACLE_HOME for the listener, if it runs out of a different home than the database instance of interest? hth. Paul > <chris.taylor@xxxxxxxxxxxxxxx> > > > ------------------------------ > *From:* Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx] > *Sent:* Wednesday, October 08, 2008 12:18 PM > *To:* Taylor, Chris David > *Cc:* ORACLE-L > *Subject:* 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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx >> >> > > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info > -- http://www.completestreets.org/faq.html http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf