RE: Question - Pro*C / OCI binary on Linux -set FETCHSIZE parameter?

There is a “bulk” syntax (which may or may not be easy as a modification to your app).  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris Taylor Sent: Sunday, June 23, 2024 10:52 AM
To: oracle-l_at_freelists.org
Subject: Re: Question - Pro*C / OCI binary on Linux -set FETCHSIZE parameter?  

To close this loop, I was able to get access to the application and profile the SQLs being executed (and how). Unfortunately, each SQL execution is done in a loop and returns 1 row. So, let's say the app wants to pull details for 1500 crew members, it issues 1500 select statements :( And it does this for many SQLs involved in any particular screen.  

So, tuning fetchsize doesn't really help us and basically we're forced to pick up the application and move it to OCI VMs to be closer to the database.  

Thanks,

Chris    

On Mon, Jun 17, 2024 at 8:27 AM 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-l