Hello,
could it be possible to implement feature to keep ALL connections alive using periodical ping (select * from dual) ?
Most of preformace issues are caused by timeouts.
If PLSQL is leaved (for a while) alone, after that there're a lot of "not responding" situations (when connections are trying to be used)
I know there're two checkboxes (options)
"Check connections" and
"Check all sessions"
but it doesn't help to check both. Connections are timeouted when you don't use PLSQL developer for a while, then lags happens
It is for us (our developers) actually the most crucial issue. It has been discussed here plenty of times in different threads and different scenarios, but it's all the same issue:
Poor multiple connection handling. Connection is lost, then there's attempt to use this connection -> mostly leads to about 30 sec lag.
Seems to be easy to implement, but it has to cover really all connections...I dont know what "Check all sessions" does, but obviously it does not checks all connections...
Thank you very much.