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.
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.
-- TroelsReceived on Tue Nov 24 2009 - 09:09:21 CST