Re: fetch size too big causes hang
From: <johnbhurley_at_sbcglobal.net>
Date: Thu, 26 Mar 2009 17:25:43 -0700 (PDT)
Message-ID: <100a83d5-093c-4528-9304-b23ba5176ee7_at_q9g2000yqc.googlegroups.com>
On Mar 26, 2:27 pm, Jim <j..._at_trainplayer.com> wrote:
> I once had a good connection from my machine to our Oracle server, but
> something has gone wrong lately apparently with transferring packets
> over the network. Here's the symptom:
>
> I connect in SQLPlus and do a large select. Records scroll by. I
> then fool with SET ARRAYSIZE and do the same select. When I set the
> value to 400 or below, no problem. If I set it to 450 or above, it
> hangs and never comes back.
>
> Another symptom: I have an app which connects via ADO. I can set
> FETCHSIZE in the connect string to 100 with no problem, but if I set
> it to 500 or above, it hangs. (The default value is 1000, which works
> fine for everyone else.)
>
> This is after a clean new install of the 10g client. I don't have any
> other network speed or connection issues. The problem has been going
> on for months now, and as I say, it used to work fine from this
> machine (no, I don't exactly know when it started or what I happened
> to be doing that day). I am finally so desperate as to ask for help
> from you fine folks. Please suggest something I might try.
>
> -- Jim
Date: Thu, 26 Mar 2009 17:25:43 -0700 (PDT)
Message-ID: <100a83d5-093c-4528-9304-b23ba5176ee7_at_q9g2000yqc.googlegroups.com>
On Mar 26, 2:27 pm, Jim <j..._at_trainplayer.com> wrote:
> I once had a good connection from my machine to our Oracle server, but
> something has gone wrong lately apparently with transferring packets
> over the network. Here's the symptom:
>
> I connect in SQLPlus and do a large select. Records scroll by. I
> then fool with SET ARRAYSIZE and do the same select. When I set the
> value to 400 or below, no problem. If I set it to 450 or above, it
> hangs and never comes back.
>
> Another symptom: I have an app which connects via ADO. I can set
> FETCHSIZE in the connect string to 100 with no problem, but if I set
> it to 500 or above, it hangs. (The default value is 1000, which works
> fine for everyone else.)
>
> This is after a clean new install of the 10g client. I don't have any
> other network speed or connection issues. The problem has been going
> on for months now, and as I say, it used to work fine from this
> machine (no, I don't exactly know when it started or what I happened
> to be doing that day). I am finally so desperate as to ask for help
> from you fine folks. Please suggest something I might try.
>
> -- Jim
Start over with a fresh os install and proceed from there?
Have you asked your dba staff for help? Received on Thu Mar 26 2009 - 19:25:43 CDT