Reconnect session

[iraklisvai]

Hello,
I have PL/SQL Developer version 12.0.7.1837.

Is there an option to reconnect to a session?

For example if I have connected to user contr@db1

and after 20 minutes that i am idle, database losts connection
Is there an option to test connection (Reconnect) ?

Thank you very much.

 

[jhughes]

If you go to Preferences -> Connection, there is an option called "Check connection". I would advise to check that to avoid idle time-outs like you are seeing. Per documentation, this option
"When this option is enabled, PL/SQL Developer checks every 60 seconds if the main session of
your database connection is still alive. If the session is killed or the server is shutdown, PL/SQL
Developer will automatically logoff."
Their is no option in any Oracle tool I know of to re-connect to a session on the DB. That is also assuming it is a network device dropping the connection and not the DB closing your connection due to it being idle.

 

[iraklisvai]

Thank you, Toad has an option Session-- > Test Connection (Reconnect)