在oracle中一直有10几个资源不释放,而且是处于非活动状态,甚至有的持续了1周多了,请问这是什么原因造成的?如下图所示:备注:程序里面所有连接数据库的地方连接完成后都已经关闭了连接。
解决方案 »
- Oracle调试过程中,怎么实时的看输出语句?
- asp.net怎么写入并读取Oracle中的clob字段
- 官网上下的linux10的Linux版本是否可以不限制节点免费使用?
- 请问我的oracle 10G怎么装不了呀
- 求sql语句。如何随即选择n条数据?
- 如何从一个表中把每个用户(一个字段)的3条之内的数据提取出来?
- sql语句的执行过程
- 急,关于oci中的OCINumberToText()与OCIDateToText()?
- 谁能解释一下在oracle中number(4),与在mysql 中int(4),中的4指的是什么?
- 跨两个ORACLE数据库的存储过程????
- 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