Re: fetch size too big causes hang
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 26 Mar 2009 19:39:14 -0500
Message-ID: <9dVyl.10713$%54.157_at_nlpi070.nbdc.sbc.com>
Michael Austin 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 19:39:14 -0500
Message-ID: <9dVyl.10713$%54.157_at_nlpi070.nbdc.sbc.com>
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