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:6开发者_StackOverflow55] 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?
Have you traced your networks? If you have problem in your network you could run in to this.
精彩评论