Re: Question - Pro*C / OCI binary on Linux -set FETCHSIZE parameter?
Date: Tue, 18 Jun 2024 09:21:51 +0200 (CEST)
Message-ID: <465495530.166536.1718695311154_at_ox.hosteurope.de>
Hello Chris,
depending on the exact code and used OCI implementation (you need to use OCIStmtPrepare2() and this can be verified with an OCI trace) you can adjust it with OCI client-side deployment parameters using oraaccess.xml - for more details see here: https://docs.oracle.com/en/database/oracle/oracle-database/23/lnoci/build-and-configure-oci-applications.html#GUID-9D12F489-EC02-46BE-8CD4-5AECED0E2BA2
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: www.soocs.de
Twitter: _at_OracleSK
> Chris Taylor <christopherdtaylor1994_at_gmail.com> hat am 17.06.2024 15:27 CEST geschrieben:
>
> 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 - 09:21:51 CEST