oracle删除异常连接,oracle – 如何清除ODP.NET连接池中的连接错误?

Connection Pool Management

ODP.NET connection pool management provides explicit connection pool

control to ODP.NET applications. Applications can explicitly clear

connections in a connection pool.

Using connection pool management, applications can do the following:

Note: These APIs are not supported in a .NET stored procedure. Clear

connections from connection pools using the ClearPool method.

Clear connections in all the connection pools in an application

domain, using the ClearAllPools method.

When connections are cleared from a pool, ODP.NET repopulates the pool

with new connections that have at least the number of connections set

by Min Pool Size in the connection string. New connections do not

necessarily mean the pool will have valid connections. For example, if

the database server is down when ClearPool or ClearAllPools is called,

ODP.NET creates new connections, but these connections are still

invalid because they cannot connect to the database, even if the

database comes up a later time.

It is recommended that ClearPool and ClearAllPools not be called until

the application can create valid connections back to the database.

.NET developers can develop code that continuously checks whether or

not a valid database connection can be created and calls ClearPool or

ClearAllPools once this is true.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值