Question - Pro*C / OCI binary on Linux -set FETCHSIZE parameter?
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Mon, 17 Jun 2024 09:27:06 -0400
Message-ID: <CAP79kiQ+adXLiZ=yKb8WM-AOYjBB=x1aJ5iAh7Fki1UoKvNcxA_at_mail.gmail.com>
We recently migrated to OCI (last night) from AWS.
Date: Mon, 17 Jun 2024 09:27:06 -0400
Message-ID: <CAP79kiQ+adXLiZ=yKb8WM-AOYjBB=x1aJ5iAh7Fki1UoKvNcxA_at_mail.gmail.com>
We recently migrated to OCI (last night) from AWS.
One of our applications is quite old and built in pro*c (I think - not positive) and uses OCI libraries to connect to the database.
Due to the new latency 10ms between hosts, this application is suffering due to number of roundtrips required to answer some queries. (>5000 round trips in some cases)
Does anyone know if its possible to set a system variable in Linux to control the fetchsize/arraysize for an OCI compiled binary that the binary might possibly pick up and use?
Thanks,
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 17 2024 - 15:27:06 CEST