2 Replies Latest reply: Oct 31, 2012 2:33 PM by Jeff Smith Sqldev Pm-Oracle RSS

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

      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.