Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need help with TOAD for Oracle
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.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Jul 25 2007 - 04:14:02 CDT