How to keep alive the connection in PL/SQL Developer?

oracle session time plsqldeveloper
Mehmet Akif Güzey picture Mehmet Akif Güzey · Nov 20, 2015 · Viewed 21.8k times · Source

I am using PL/SQL Developer 11.0.4.1774. In my work, I need to use database whole day. Sometimes, during 30-60 minutes, I do not use ide and when I need to use it again, it requires reconnection.

I do not want to reconnect, is there any way to keep the connection alive whole day?

Answer

Jon Heller picture Jon Heller · Nov 20, 2015

Go to Tools --> Preferences and click "Check connection". It pings the database every 60 seconds, making the session active and avoids idle session disconnects caused by profiles.

enter image description here

NOTE: This question and answer are for Allround Automations PL/SQL Developer. See this question if you're looking for Oracle SQL Developer.

Related questions

oracle - what statements need to be committed?

What are the list of statements that need to be committed before further action on the table in order to avoid a lock? I am not talking about full transactions with multiple statements and transaction integrity; instead I am referring …

Read More
How can I kill all sessions connecting to my oracle database?

I need to quickly (and forcibly) kill off all external sessions connecting to my oracle database without the supervision of and administrator. I don't want to just lock the database and let the users quit gracefully. How would I script …

Read More
ORA-12519, TNS:no appropriate service handler found

I am closing the hibernate connection properly but i am getting this error after some clicks or after some page refreshes. whats the problem i cant understand. I have also checked the number of sessions its also increasing by the …

Read More