RE: slower fetch speed with oracle client 19c vs 11g
Date: Tue, 21 Feb 2023 07:45:48 -0700
Message-ID: <005c01d94603$305a97f0$910fc7d0$_at_gmail.com>
We had an issue a few years back when we upgraded the Oracle client for a Federation Server from 11g to 12c relating to Doc ID 2247689.1. The SQL seemed to perform the same in the database but the number of discreet connections times the increased connection time led to a dramatic slowdown.
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Laurentiu Oprea Sent: Tuesday, February 21, 2023 3:46 AM To: ORACLE-L (oracle-l_at_freelists.org) <oracle-l_at_freelists.org> Subject: slower fetch speed with oracle client 19c vs 11g
Dear colleagues,
It started like a performance investigation where DB was blamed that after an application upgrade queries started to be slower. We managed to isolate the issue to only the oracle client.
They are using an application (qlikview) using OLEdb for oracle driver. When they configure it with the oracle client 19c is fetching almost 50% slower compared with the 11g client. Everything is identical in rest. I saw from the sql monitor report that the same fetch size is used, probably this is dictated by the driver which is the same in both cases.
Anyone have any idea what could be the issue here?
Appreciate your help,
Laurentiu.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 21 2023 - 15:45:48 CET