If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: TOAD Timeout issue

TOAD Timeout issue
When I connect to a Oracle database(remote) using TOAD client, because of the settings of timeout done at the server end(in Oracle), the TOAD session gets time out in 5 minutes
I want to know how I can increase the timeout interval or if I can keep on pinging the database server so that the TOAD connection does not gets timeout

San

PS: When we connect to a unix server using putty, we can keep on pining the server at regular timeout interval by going to Change Settings->Connection->Set KeepAlive
Is there a similar way for TOAD?

Well, I will contact them
I also observed that even from SQL*Plus( of Oracle), it gets timeout in 5 minutes
Is there anything like running something from background which will call say "select * from dual" to keep the session alive?

Although you do not mention it, I assume it is your firewall that is dropping the connections after an interval of inactivity of 5 minutes.

Perhaps the dead connection detection mechanism in Oracle Net might help.
Set SQLNET.EXPIRE_TIME to 4 minutes to ensure network traffic between the server and client within the 5 minute timeout interval.

Actually, I would suspect the idle timeout in the default oracle profile. If it is that, simply setup a different profile for the user and assign a different or unlimited idle timeout value under time limits.

Bill
You do not need a parachute to skydive. You only need a parachute to skydive twice.