Print Thread
Is there any way we can keep the connection active?
#64832 10/06/23 06:25 AM
Joined: Dec 2017
Posts: 22
K
Member
OP Offline
Member
K
Joined: Dec 2017
Posts: 22
Hello there,

I am using PLSQL developer 12.1.

The user ID that I used to connect to the database has created a timeout after a specified idle time.

Is there any setting or option to avoid such session timeouts in PLSQL developer?

Thanks.

Re: Is there any way we can keep the connection active?
Karthi S #64833 10/06/23 09:02 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
You can go to Preferences > Oracle > Connection and enable the "Check connection" and "Check all sessions" options. Now PL/SQL Developer will check once per minute if the session is still working, which will also act as a keep-alive.


Marco Kalter
Allround Automations
Re: Is there any way we can keep the connection active?
Karthi S #64834 10/06/23 01:25 PM
Joined: Dec 2017
Posts: 22
K
Member
OP Offline
Member
K
Joined: Dec 2017
Posts: 22
Thanks for your response.

I see "Check Connection" checkbox and I have it enabled. But then I dont have "Check all sections". But still my session is getting timeout.

Please note: I am using PLSQL Developer 12.1.

Re: Is there any way we can keep the connection active?
Karthi S #64836 10/09/23 08:56 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
Ah, PL/SQL Developer 12 does indeed not have the "Check all sections" option. You would need to try the latest version for this.


Marco Kalter
Allround Automations
Re: Is there any way we can keep the connection active?
Karthi S #64844 10/16/23 03:50 PM
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
Member
Offline
Member
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
I have both checked in the latest release 15 version, but the issue with sessions going in a kind of sleep state for other database connections remain. I have some windows connected to our Development database and some to Acceptance and Production. After working for a while in the Development database (say 10 minutes) the ACC and PRD windows are in a kind of frozen state and it takes more then a minute before those windows are responsive again...


Certainty of death, small chance of succes,
What are we waiting for... (Gimly)

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.130s Queries: 14 (0.049s) Memory: 2.5123 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-29 15:33:03 UTC
Valid HTML 5 and Valid CSS