Re: Question - Pro*C / OCI binary on Linux -set FETCHSIZE parameter?
Date: Tue, 18 Jun 2024 12:26:58 +1000
Message-ID: <1fa6d88d-67bc-47c2-a721-8da8513290b7_at_Spark>
Where is the 10ms latency coming from? is the app server within the same OCI region or somewhere else?
A simple ping test between OCI compute instances on the same VCN is _at_0.25ms on average
On 17 Jun 2024 at 11:28 PM +1000, Chris Taylor <christopherdtaylor1994_at_gmail.com>, wrote:
> 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 Tue Jun 18 2024 - 04:26:58 CEST