How can I keep Oracle SQL Developer from closing the DB connection?

oracle oracle10g oracle-sqldeveloper
Kevin Babcock picture Kevin Babcock · Aug 21, 2009 · Viewed 79.8k times · Source

Is there any way to keep Oracle SQL Developer from closing my DB connections, or to increase the timeout? Sometimes during a long-running query SQL Dev will just close the connection, leaving my query running on the server but me with no results. If I RDP into the server and run SQL Dev locally it never seems to have this problem.

Answer

DelGurth picture DelGurth · Jan 6, 2010

Answer

It's most likely a firewall between SQL Developer and the database that breaks things. You can solve that from SQL Developer using the SQL Developer Keepalive plugin.

You can also fix this from the Database Server by using the answers by Thomas and David Mann.

Oracle Net can be configured with Dead Connection Detection (SQLNET.EXPIRE_TIME) to workaround this problem. Set EXPIRE_TIME on the database server to a value less than the firewall connection timeout so that DCD keeps the connection to the database alive. See Note 151972.1 "Dead Connection Detection (DCD) Explained"

Original answer

I don't have the answer for this, but I'm experiencing the same problem.

The firewall between my SQL Developer and the database automaticly closes "inactive" sessions. A long running query is according to the firewall an inactive session, so he closes it. I've not, yet, found how to make SQL Developer send packets over a connection with a long running query, so that the firewall doesn't close the connection. And I don't know if this is possible at all.

So I don't think it is a SQL Developer problem, but a firewall issue.

-- UPDATE

There is an extension for SQL Developer that allows you to keep the connections active: http://sites.google.com/site/keepaliveext/

It's not totally finished yet (for example the notification you get states the same timeout no matter what timeout you have specified) but it does the trick. I've not, yet, tested it against the latest SQL Developer pre-release, but it worked with SQL Developer 2.2.x

-- UPDATE

For SQL Developer 4+ you can use: http://scristalli.github.io/SQL-Developer-4-keepalive/

Related questions

How to see refcursor result/output in Oracle SQL Developer?

Possible Duplicate: Best way/tool to get the results from an oracle package procedure Oracle SQL Developer: Show REFCURSOR Results in Grid? I am new to Oracle SQL Developer. I am using Oracle SQL Developer Version 3.0. I was trying to …

Read More
Run 2 queries at the same time on Oracle SQL Developer?

I need to retrieve quite a bit of data from our oracle DB and to do so I need to run 20+ queries. Is there any way to run more than one query at a time on the same connection? I …

Read More
Need to count records and group count by date on oracle db using sql developer

I have a table like the following ID created sent type ----------------------------------------------------- 0001463583000051783 31-JUL-12 1 270 0081289563000051788 01-AUG-12 1 270 0081289563000051792 01-AUG-12 1 270 0081289563000051791 01-AUG-12 1 270 0081289563000051806 01-AUG-12 1 270 0001421999000051824 06-AUG-12 1 270 0001421999000051826 06-AUG-12 1 270 0001464485000051828 06-AUG-12 1 270 0082162128000051862 09-AUG-12 2 278 0082162128000051861 09-AUG-12 2 278 0022409222082910259 09-AUG-12 3 278 I would like to have the following for output created Count --------------------- 31-JUL-12 1 01-AUG-12 4 06-AUG-12 3 09-AUG-12 3 How …

Read More