When a session connection has been severed, it takes several minutes for the client to realize that the connection has been lost.
What setting can be changed to decrease the response time, or is there a timeout setting in Toad?
There is no session timeout setting in Toad for Oracle, but there is one in Oracle.
Have your DBA modify the following parameters in the SQLNET.ORA file of Oracle Net Manager:
SQLNET.SEND_TIMEOUT
SQLNET.RECV_TIMEOUT
SQLNET.INBOUND_CONNECT_TIMEOUT
SQLNET.EXPIRE_TIME
For more information, refer to "Configuring Advanced Profile Information" in the Oracle Administration Guide.
For further details, see:
http://forums.oracle.com/forums/thread.jspa?messageID=851551
http://www.stanford.edu/dept/itss/docs/oracle/10g/network.101/b10775/profile.htm
