Re: Small TNS packages

From: Troels Arvin <troels_at_arvin.dk>
Date: Tue, 24 Nov 2009 15:09:21 +0000 (UTC)
Message-ID: <hegsv1$aar$1_at_news.net.uni-c.dk>



joel garry wrote:
> Look up SDU and and SEND_BUF_SIZE (and related parameters) in the docs.

Those are server-side parameters?

As a follow-up:
The application uses JDBC. By using
((OracleConnection)connection).setDefaultRowPrefetch(10000) we experienced a dramatic speedup: Execution time was cut to 1/20 (although TNS packet sizes had only increased by a factor 5, from around 400 to around 2000).

Thanks to you and and Mladen, by the way.

-- 
Troels
Received on Tue Nov 24 2009 - 09:09:21 CST

Original text of this message