how can i set timeout option in toad?

Toad for Oracle & DevOps Toolkit
1

Suppose i have 10 servers and some of them are down. When i am trying to reconnect that server’s when reconnection reaches to the down one it waits to much time. how can i skip or set timeout time for that connection?

Thanks

1 Like
2

That's not a Toad setting, that's a SQL*Net setting.

go here and search the page for "timeout"

https://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#NETRF427

There are several timeout parameters.

Edit, October 2024: This is now possible using Toad version 24.2 without an Oracle client:

  • Options -> Oracle -> Connections -> Connection Timeout
    • This is the amount of time before Toad will give up when trying to make a connection.
  • Options -> Oracle -> Connections -> Auto-disconnect after a period of inactivity
    • You can use this so Toad disconnects from the DB after, before the database does. This will prevent the long hang/delay that sometimes happens when the disconnect happens from the database side.