Re: fetch size too big causes hang

From: Michael Austin <>
Date: Thu, 26 Mar 2009 19:39:14 -0500
Message-ID: <9dVyl.10713$>

Michael Austin wrote:
> Jim 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
> Not sure if it matters or not, but check to make sure your 
> "auto-negotiate" is doing so correctly.  I have seen real funky things 
> happen when the switch screws up and does not negotiate in good faith.. :)

Oh. and it would be helpful if you were to provide actual version numbers... Received on Thu Mar 26 2009 - 19:39:14 CDT

Original text of this message