This discussion is archived
2 Replies Latest reply: Oct 31, 2012 12:33 PM by Jeff Smith SQLDev PM RSS

Can I run a periodic query to keep Orcale SQL Developer connection alive?

842235 Newbie
Currently Being Moderated
Our SQL database is configured to terminate any connections that haven't been used in the last 30 minutes. If I wait longer than that and try to do something with one of those dead connections, it takes forever for SQL Developer to realize it's gone, and I need to close that worksheet and open a new one.

So I wondered if I could configure SQL Developer to just do a "select * from dual" every 20 minutes or something. Obviously I don't want to have to initiate that...I want it to do it on it's own, so when I come back to the session, it's ready to go, and I don't need to establish another session.

Dale

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points