Re: fetch size too big causes hang
From: <johnbhurley_at_sbcglobal.net>
Date: Sun, 29 Mar 2009 13:12:41 -0700 (PDT)
Message-ID: <dd1ba81a-d43e-4fb2-be77-ae63cb69622a_at_f19g2000yqo.googlegroups.com>
On Mar 29, 4:01 pm, Jim <j..._at_trainplayer.com> wrote:
> Latest update: I installed a clean new 10.2.0.3 client on a new
> machine which had never had Oracle client on it before. The problem
> persists.
>
> One thing I didn't mention before: I am going through a VPN to get to
> the server.
>
> It seems to me since I see the same thing on two different client
> machines, that it must be a problem somewhere between me and the
> server, maybe in the VPN. Could be I need to go to some other forum
> to continue on this problem.
>
> -- Jim
Date: Sun, 29 Mar 2009 13:12:41 -0700 (PDT)
Message-ID: <dd1ba81a-d43e-4fb2-be77-ae63cb69622a_at_f19g2000yqo.googlegroups.com>
On Mar 29, 4:01 pm, Jim <j..._at_trainplayer.com> wrote:
> Latest update: I installed a clean new 10.2.0.3 client on a new
> machine which had never had Oracle client on it before. The problem
> persists.
>
> One thing I didn't mention before: I am going through a VPN to get to
> the server.
>
> It seems to me since I see the same thing on two different client
> machines, that it must be a problem somewhere between me and the
> server, maybe in the VPN. Could be I need to go to some other forum
> to continue on this problem.
>
> -- Jim
Guess one test would be to talk with the dba and see if you can do your testing somehow first connected ( somehow ) not thru the VPN.
If it works smoothly without the VPN but starts burping using the VPN well at least you isolated something?
Guess taking shots in the dark here but perhaps a byproduct of how much bandwidth you have useable from your machine when going thru the VPN causing some timeouts/hiccups etc? Received on Sun Mar 29 2009 - 15:12:41 CDT