Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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?

like image 331
Mehmet Akif Güzey Avatar asked Nov 20 '15 12:11

Mehmet Akif Güzey


2 Answers

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.

like image 107
Jon Heller Avatar answered Sep 18 '22 20:09

Jon Heller


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
like image 39
are Avatar answered Sep 21 '22 20:09

are