Re: Need help with TOAD for Oracle

On Wed, 25 Jul 2007 02:14:02 -0700, sybrandb <sybrandb_at_gmail.com> wrote:

>On Jul 25, 11:07 am, Limner <pendrago..._at_gmail.com> wrote:
>> Hi to all
>>
>> i've a small problem with Toad for Oracle, the tool i use to connect to
>> my Database:
>> Toad lost connection after about 40 minutes of non-utilization.
>>
>> Is there a way to prevent this? something like a "tnsping" from Toad to
>> Oracle server
>> to prevent the "connection lost" problem?
>>
>> Thanks in advance for your help!
>> Danilo
>
>Likely your DBA has enabled dead connection detection at the server
>side,or set an idle_time in your profile.
>And rightly so!!
>Why waste resources on a session which is doing nothing for 40
>minutes?
>You can relogin with the reconnect button in Toad, so what is your
>problem?
>There is no "connection lost" problem. The problem is you, doing
>nothing for 40 minutes, and wasting resources.

The only problem with TOAD (at least the version I last used) is that when the connection is dropped on the DB side you may well have to wait 1 or 2 minutes for TOAD to "get it" and display a message. (or it may crash, depending on the weather or something) Also, if you have TOAD open for 40 minutes w/o doing anything it's to be hoped that it's a connection to a developer DB and there the "waste of resources" shouldn't matter.
Anyways ... you've provided the search-terms 'dead conn. detection' and 'idle_time' so the OP can go search from there ... if he isn't too scared now, that is :-)

cheers,
Martin Received on Wed Jul 25 2007 - 06:08:30 CDT