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

Question

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 1

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.

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

Answer 2

you need check 'IDLE_TIME' and 'CONNECT_TIME' setting for your user profile

select * from dba_profiles
  where resource_name in  ('IDLE_TIME','CONNECT_TIME')

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6010.htm

If a user exceeds the CONNECT_TIME or IDLE_TIME session resource limit, then the database rolls back the current transaction and ends the session. When the user process next issues a call, the database returns an error.

I have PL/SQL Developer opens for days and don't have the issue my PL/SQL Dev Tools-Prefernces-connection settings are:

• Session Mode = Multy Session
• Check connection = unchecked
• Logoff with open transaction = Commit

and TIME settings are:

    PROFILE RESOURCE_NAME   RESOURCE_TYPE   LIMIT
1   DEFAULT IDLE_TIME   KERNEL  UNLIMITED
2   DEFAULT CONNECT_TIME    KERNEL  UNLIMITED