Does Toad have a keep alive / interval time / ping setting so that the network will not timeout? (4242671)

Does Toad have a keep alive / interval time / ping setting so that Toad will continuously ping the database and not have a connection time out?  Can we add a "Keep Alive" setting to regularly ping the DB to prevent network or database server timeout?

Keeping database connections alive is generally not recommended and may violate your company's policies. Some of the reasons are it is not possible to maintain resources forever and the security threat of keeping ports open forever (some firewall policies do not allow this).

If you would still like to force connectivity at all times, you can do so by doing one of the following two suggestions.

A) 

Turn ON the DBMS Output (Polling) in Toad, which is similar to Toad pinging the database. Go to the Editor Window | DBMS Output Tab (lower half of the Editor window) | click on the "Turn Output On" red icon, which will make the icon turn green.

NOTE:  Starting Toad version 12.1, it’s little different.  Please also ensure the “Interval Polling” icon (4th icon) is 'depressed' as that is the one that sends the polling at i.e. every 5 seconds. You can set the Frequency field up to the max of every 60 seconds.

B) 

Start Database | Monitor | Session Browser, which has an auto refresh feature (max is every 1000 seconds), which should cause some activities to occur on the database.

NOTE: The Session Browser feature requires DBA privileges.

NOTE: All the above may still not work if you have the "Execute queries in threads" option check marked. The is because each window in Toad will have their own session / thread, and some of those windows would be unaffected by the above settings.  One example is the Schema Browser window, which will have its own session and can still expire.