oracle 如何在 PL/SQL Developer 中保持连接活跃？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/33826571/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to keep alive the connection in PL/SQL Developer?
提问by Mehmet Akif Güzey
I am using PL/SQL Developer 11.0.4.1774. In my work, I need to use database whole day. Sometimes, during 30-60 minutes, I do not use ide and when I need to use it again, it requires reconnection.
我正在使用 PL/SQL Developer 11.0.4.1774。在我的工作中，我需要整天使用数据库。有时，在 30-60 分钟内，我不使用 ide，当我需要再次使用它时，它需要重新连接。
I do not want to reconnect, is there any way to keep the connection alive whole day?
我不想重新连接，有什么办法可以保持连接一整天？
回答by Jon Heller
Go to Tools --> Preferences and click "Check connection". It pings the database every 60 seconds, making the session active and avoiding idle session disconnects caused by profiles.
转到工具 --> 首选项，然后单击“检查连接”。它每 60 秒 ping 一次数据库，使会话处于活动状态并避免由配置文件引起的空闲会话断开连接。
回答by are
you need check 'IDLE_TIME' and 'CONNECT_TIME' setting for your user profile
您需要检查您的用户个人资料的“IDLE_TIME”和“CONNECT_TIME”设置
select * from dba_profiles
where resource_name in ('IDLE_TIME','CONNECT_TIME')
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6010.htm
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6010.htm
If a user exceeds the
CONNECT_TIMEorIDLE_TIMEsession resource limit, then the database rolls back the current transaction and ends the session. When the user process next issues a call, the database returns an error.
如果用户超过
CONNECT_TIME或IDLE_TIME会话资源限制，则数据库回滚当前事务并结束会话。当用户进程下一次发出调用时，数据库返回错误。
I have PL/SQL Developer opens for days and don't have the issue
my PL/SQL Dev Tools-Prefernces-connectionsettings are:
我的 PL/SQL Developer 打开了几天，但我的 PL/SQL DevTools-Prefernces-connection设置没有问题：
- Session Mode = Multy Session
- Check connection = unchecked
- Logoff with open transaction = Commit
- 会话模式 = 多会话
- 检查连接 = 未检查
- 使用打开的事务注销 = 提交
and TIME settings are:
和时间设置是：
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
1 DEFAULT IDLE_TIME KERNEL UNLIMITED
2 DEFAULT CONNECT_TIME KERNEL UNLIMITED
回答by William Robertson
Install the Reconnect plug-in so at least reconnecting can be a simple button-press.
Possibly against the intention of the DBA (if the issue is due to profile/resource manager settings), but you might try setting a Sessions window (or other report/query etc) to auto-refresh every 25 minutes or so.
安装重新连接插件，以便至少重新连接可以是一个简单的按钮按下。
可能违反 DBA 的意图（如果问题是由于配置文件/资源管理器设置引起的），但您可以尝试将会话窗口（或其他报告/查询等）设置为每 25 分钟左右自动刷新一次。
Edit: I see on the Bar Solutions websitethe developer has moved Reconnect from "Plugins" to "Old Plugins". At my current client site I can't install plugins, so I can't tell whether it still works at the moment.
编辑：我在Bar Solutions 网站上看到开发人员已将重新连接从“插件”移至“旧插件”。在我当前的客户端站点上，我无法安装插件，所以我不知道它目前是否仍然有效。
