Delays in .net app when connecting to oracle db using Oracle.DataAccess

Question

I have a .net desktop app that connects to an oracle database. At times, there are very noticable delays.

I ran a trace on the code, and it was always in the DataReader.Read().

I turned on sql tracing, and found the following, which corresponds to the delays I'm seeing:

(2128) [23-MAR-2010 13:00:07:310] nsprecv: reading from transport...
(2128) [23-MAR-2010 13:00:07:310] nttrd: entry
(2128) [23-MAR-2010 13:00:24:655] nttrd: socket 676 had bytes read=2047
(2128) [23-MAR-2010 13:00:24:655] nttrd: exit
(2128) [23-MAR-2010 13:00:24:655] nsprecv: 2047 bytes from transport

There's about a 14 second pause in there.

I'm pretty sure that there's not a problem in the code, but not sure where to look at next. Is there anyone out there with experience with oracle trace that can explain what's going on?

Answer 1

Have you traced your networks? If you have problem in your network you could run in to this.

Answer 2

Hi,

I see the same issue when using jdbc and a lot of threads reading data from oracle.

havent found a solution yet. ive looked at the network, oracle side and the app code, no joy.