如何使用Oracle清理死连接? [英] How can I clean up dead connections using Oracle?

问题描述

现在，我有一些针对Oracle数据库的新应用程序正在开发，有时它们崩溃或无法正确结束，等等.无论如何，问题在于它们有时似乎使它们的连接保持打开状态，我需要清理在他们之后. 我的问题是，是否有一种从数据库方面的方法来确定死连接并清理它们?

Right now I have a few new applications being developed against an Oracle Database, and sometimes they crash or fail to end correctly, etc... anyways the problem is they sometimes seem to leave their connections open, and I need to cleanup after them. My question is if there is a way from the database-side of things to determine dead connections and clean them up?

推荐答案

这里是您可以在

Here's a page referring to connection timeout parameters you can set in Oracle 11g. I think the 'Abandon Connection Timeout' is what you're looking for.

这篇关于如何使用Oracle清理死连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！