Keep-Alive on multisession

[Paulo Andre]

I have a problem with my vpn. Queries after a long inactivity period time out and I can't see the result. The check connection is marked, but from my understanding this only keeps one session alive (thus pl/sql developer always keeps connected). I needed a per session keep-alive, something like putty, that implements keep-alive at tcp level and not making a query to the database. Could you please add this?

 

[Marco Kalter]

I'm not sure if this is technically possible. The TCP/IP connection is handled by Oracle Net, and is not visible to the application.

 

[F. van Boven]

We had some problem with sessions timing out (because of a weird hardware problem somewhere in the netwerk).

I've just created a plugin that executes a (select * from dual) each x minutes. (It took too long to fix the hardware issue )

Works like a charm...

Or is there a specific reason that you don't want to make a query to the DB?

 

[Sergey]

I have the same issue with my VPN.

You can also open: Tools->Sessions and turn on "Auto refresh timer", BUT it "not always" works because of "...this only keeps one session alive ... "

 

[Paulo Andre]

you misunderstood my problem. If I check "check connection", my main connection to the database stays on, but all other sql windows I have open get timeout. This is because pl/sql developer is in multisession mode, every windows creates a separate connection to the database. Inside a long running query I cannot perform another query, so I need a method to keep-alive without resorting to queries, that's why I talked about tcp keep-alives.

 

[NgocTrung]

Hello Boven,

Could you share me your plugin? Or tell me how to create it?

Many thanks