开发者

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

开发者 https://www.devze.com 2022-12-23 17:27 出处:网络
I have a .net desktop app that connects to an oracle database.At times, there are very noticable delays.

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号