ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle.DataAccess.Client.OpsSql::ExecuteReader() never returns

718583Aug 21 2009 — edited May 10 2010

Within a single day I have experienced twice a peculiar problem with Oracle.DataAccess.Client.OpsSql::ExecuteReader()

Calling ExecuteReader() blocks indefinitely on a simple select query (it was a different query the two times). The CPU of the Oracle Server was low, so it is not likely that it has been too busy (and moreover at least 10 minutes passed, and it was still blocked)

Strangely in v$session there was no session entry for the particular process+thread that made the call. There was an inactive session from the same process, but different thread

My guess is that somehow the Oracle executed the query, but the Oracle Client was not notified and remained waiting. The issue happened on a virtual machine with not stable network connection. Could it be that some packets were lost and the Oracle Client just kept waiting?

Can anybody recommend a course of action?

Btw, I use ODP.NET 2.111.6.20

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2010

Added on Aug 21 2009

#odp-net

5 comments

3,081 views