Delays in .net app when connecting to oracle db using Oracle.DataAccess
- by chris
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?