How to keep in touch in PL / SQL Developer?

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

I don’t want to connect again, is there a way to keep in touch all day?

+4
source share
3 answers

Go to the "Tools → Settings" section and click "Test Connection." It binds the database every 60 seconds, making the session active and avoiding downtime caused by profiles.

enter image description here

+5
source

'IDLE_TIME' 'CONNECT_TIME'

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

CONNECT_TIME IDLE_TIMElimit, . , .

PL/SQL Developer, PL/SQL Dev Tools-Prefernces-connection:

  • =
  • =
  • = Commit

TIME:

    PROFILE RESOURCE_NAME   RESOURCE_TYPE   LIMIT
1   DEFAULT IDLE_TIME   KERNEL  UNLIMITED
2   DEFAULT CONNECT_TIME    KERNEL  UNLIMITED
+1
  • Reconnect, , , .

  • , ( /), ( / ..) 25 .

: - Bar Solutions Reconnect "" " ". , , .

0

Source: https://habr.com/ru/post/1616740/


All Articles