Is their any connection timeout?

[SaKa]

Hi,
I am using PLSQLD Version 13.0.5.1908 (32 bit). It seems if i don't use PLSQLD for about an hour or so, while i am logged in to a database, the PLSQLD hangs for about 2-3 minutes and the commit/rollback icons lit up. If i select logout then it takes about 2-3 minutes before it logs out. Then after that it works normally.

While it hangs if i just disconnect wifi on my laptop it shows connection lost message and this way i can come out of the hanging situation quickly.

So wondering whats happening. This is not something happened in recent updates, i think it was there since i started using PLSQLD13.

Thanks
Sak

 

[Marco Kalter]

There can be an idle_time defined in the profile of your Oracle account. This should not cause any 2-3 minute delays though. It seems more likely that this is a network related issue.

To prevent time-out issues you can go to Preferences > Oracle / Connection and enable the "Check Connection" option. When enabled, PL/SQL Developer will check once per minute if a connection is still working, which can also act as a keep-alive for connections that would otherwise time-out.

 

[SaKa]

Ok Thanks, will try that setting.

 

[josegante]

Hi,

I have the same issue since a lot of time (both with r12 and r13) and already tested that this "Check Connection" doesn't solve it.

Regards,
Jose.