I'm trying to run a long query in SQL Developer but the query can never finish. I always get
IO Error: An existing connection was forcibly closed by the remote host
or some other error along those lines. This always happens after exactly 15:00 min.
How can I figure out what is causing the connection to be closed? And, how can I make sure the connection stays open until the query finishes?
SQL Developer version: 18.3.0.277
This is a timeout issue, probably set on the server. It could be set on the client slide. I would look at your settings on your SQL Developer and see if that corresponds with the client connection duration that you are seeing. If it is the same amount of time, then make it longer and try again. I'm thinking more than likely, it is on the database server side and will need to be changed with Database owner privileges.
Of course, because I don't know what the configuration of your set up is, it could be the windows/Unix server itself that is closing the connection. It could also be a timeout setting in the network.
Lastly, there could be an application setting (that is, the application that is connected to the database could have a timeout setting) that could be forcing the connection to close.
Good luck and let us know if one of these worked.
Please go through these options and see which