Strange remote networking behaviour

From: Rod J. Stewart <rstewart_at_eucalypt.net.au>
Date: 8 Jul 2002 23:55:01 -0700
Message-ID: <dd07ce52.0207082255.2af1bfff@posting.google.com>

Hi,

I have a situation where I am connecting to an Oracle database instance on a remote site (interstate) via a 2Mb internet connection. When I login via sqlplus to an account and do a simple query, everyting appears to work fine. When I issue any sort of query that will return a greater volume of data, the connection appears to hang. For example, connected for a schema with 100 tables in it, I can select (using SQL*Plus) the names of the tables from user_tables ok, but if I attempt to select * from user_tables, the connection appears to hang. The same behavious seems to occur regardless of whatever tool or application I am connecting with.

I can measure throughput to the remote server of between 20 and 30 kBps, so I don't think that the size of the pipe should be the problem. Doing a traceroute to the remote server reveals 14 hops. Both ends have a firewall in between, but the appropriate permissions seem to be in place as I can connect ok.

Any ideas on what might be causing this or has anyone seen this kind of behaviour before?

TIA Rod Received on Tue Jul 09 2002 - 01:55:01 CDT