Re: Heterogenous Service much slower in Oracle 9 than in Oracle 8

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 19 Aug 2006 16:29:29 +0200
Message-ID: <1t7ee255mlgd4cs447vvdo1jefrrq13gu4@4ax.com>

On 18 Aug 2006 11:59:28 -0700, "Ray Saltrelli" <reymundo514_at_gmail.com> wrote:

>P.S. When it refers to "Client" in this trace, does that mean the
>external data source or the hsolesql agent?

in 'sqlnet messqge to client' client means 'the program which submitted the sql'.
Also your 'fetch' lines always seem to have r=15, which means 15 rows are fetched, which happen to be the default sql*plus array size. You could consider increasing array size provided the total packet (arraysize * recordsize) doesn't exceed 2048 bytes, the default SDU of sqlnet.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Aug 19 2006 - 09:29:29 CDT