oracle – 如何防止toad在一段时间后断开其会话?

前端之家收集整理的这篇文章主要介绍了oracle – 如何防止toad在一段时间后断开其会话?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我正在使用toad为oracle客户端.

会话在一段时间后断开连接.
如何在任何时候启用它.

解决方法

Dell website

Keeping database connections alive is generally not recommended

If you would still like to force connectivity at all times,you can do so by doing one of the following two suggestions.

A)

Turn ON the DBMS Output (Polling) in Toad,which is similar to Toad pinging the database. Go to the Editor Window | DBMS Output Tab (lower half of the Editor window) | click on the “Turn Output On” red icon | then the icon will turn green.

NOTE: Starting Toad version 12.1,it’s little different. Also ensure the “Interval Polling” button or icon is ‘depressed’ as that is the one that sends the polling at every i.e. 5 seconds. You can set this to 60 seconds,which is the max.

B)

Start Database | Monitor | Session Browser,which has an auto refresh feature,which should cause some activities to occur on the database.

NOTE: The Session Browser feature requires DBA privileges.

猜你在找的Oracle相关文章