Re: fetch size too big causes hang

From: Jim <>
Date: Fri, 27 Mar 2009 06:12:37 -0700 (PDT)
Message-ID: <>

You're dealing with a non-expert here. I am consulting with our dba, but he's run out of ideas too.

> Not sure if it matters or not, but check to make sure your "auto-negotiate" is doing so correctly.

Can you tell me how to check this?

> tcp.nodelay is a parameter that defaults to yes, if for some reason it is set to no you might suffer from delays in sending the last tcp package

I take it the way to set this is to create a protocol.ora file and enter a line in it? I don't know how to see the current setting. This applies to SDU also.

> provide actual version numbers...

SQL*Plus: Release - Production on Fri Mar 27 05:38:31 2009 Connected to:Oracle Database 10g Enterprise Edition Release - Production With the Partitioning, OLAP and Data Mining options

> Start over with a fresh os install and proceed from there?

This may be the only way. I have to decide whether I want to spend the weekend dismantling my machine, or reading the Net Services manual :-)

  • Jim
Received on Fri Mar 27 2009 - 08:12:37 CDT

Original text of this message