Re: help:how to disconnect from db?

From: Fraser McCallum <fmcc_at_removetoemail_odbaguru.com>
Date: Tue, 23 Apr 2002 10:01:28 +1000
Message-ID: <Tp1x8.47072$uR5.107630@newsfeeds.bigpond.com>

Joe,

You could try setting Dead Connection Detection in your sqlnet.ora file on the server using the SQLNET.EXPIRE_TIME. This is documented here http://documentation.oracle.com/cd_a87860/doc/index.htm or in your Net 8 documentation.

Kind Regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"Joe Sath" <dbadba62_at_hotmail.com> wrote in message news:ta1x8.14170$t65.9831_at_nwrddc02.gnilink.net...
> Most applications, like sqlplus, when you close it, the session will be
> disconnected as well even though the query is still running.
>
> But one of our homemade application, written in JAVA,using thin layer,
> getting the data based on how many days, will get a time out error message
> if the end user enter too many days. But the database session is still
> there, so the end user will restart the application and restart the
> application, untill the database got too many connections and crashes.
>
> How can I do, as a DBA, to make sure that if the application is closed,
the
> database session is also disconnected? Is there any setting I should
> implement?
>
> Thanks for your help.
>
>
Received on Mon Apr 22 2002 - 19:01:28 CDT