在oracle中一直有10几个资源不释放,而且是处于非活动状态,甚至有的持续了1周多了,请问这是什么原因造成的?如下图所示:备注:程序里面所有连接数据库的地方连接完成后都已经关闭了连接。
解决方案 »
- 执行存储过程报ORA-00372错误
- 用命令exp和imp执行oracle数据库导出导入时总是出现EXP-00056:遇到ORACLE错误12560 ORA-12560:TNS:协议适配器错误 EXP-000000
- Oracle中的SQL语句如何转到Access下
- 几个初学者的问题
- 高分求:Oracle8i到Oracle9i的升级方案
- 初学ORACLE,有使用SQL SERVER的基础,请帮忙介绍基本学习ORACLE的书籍
- penitent(只取一瓢), 弱水三千 大哥来看一眼,这是调用存储过程的进化的问题
- ORACLE 9i for AIX问题:我的listener不能启动
- Oracle 11g数据导入指定表空间问题
- 小白求助SQL题目答案,急!!!
- Linux删除oracle实例的正常步骤
- 急急急!!!!!在线等!!!!
程序已经做了处理:包括正常退出和不正常退出都进行了数据库的关闭。 stmt.close();
conn.close();
if(conn!=null&&!conn.isClosed()){
conn.close();
}
}catch(Exception err){ if(conn!=null&&!conn.isClosed()){
conn.close();
} err.printStackTrace();
out.println("错误是 "+err.getMessage());
}
sqlnet.expire_time = 1(1是分钟数)
OCISessionEnd
OCIServerDetach
OCIHandleFree
看看你调用的函数中,是否包含了这几个方法。
关闭方法在二楼。6楼能详细点吗?
sqlnet.expire_time = 1(1是分钟数)经过测试这个方法无效。
Purpose
Use parameter SQLNET.EXPIRE_TIME to specify a the time interval, in minutes, to send a probe to verify that client/server connections are active. Setting a value greater than 0 ensures that connections are not left open indefinitely, due to an abnormal client termination. If the probe finds a terminated connection, or a connection that is no longer in use, it returns an error, causing the server process to exit. This parameter is primarily intended for the database server, which typically handles multiple connections at any one time.Limitations on using this terminated connection detection feature are:•It is not allowed on bequeathed connections.•Though very small, a probe packet generates additional traffic that may downgrade network performance.•Depending on which operating system is in use, the server may need to perform additional processing to distinguish the connection probing event from other events that occur. This can also result in degraded network performance.Default0
Minimum Value0
Recommended Value10
ExampleSQLNET.EXPIRE_TIME=10