slower fetch speed with oracle client 19c vs 11g
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Tue, 21 Feb 2023 12:45:42 +0200
Message-ID: <CA+riqSVLC0=2btOjV1K5zGusPDWGg4WSDy_jVW=GHP4z-a4qaQ_at_mail.gmail.com>
Dear colleagues,
Date: Tue, 21 Feb 2023 12:45:42 +0200
Message-ID: <CA+riqSVLC0=2btOjV1K5zGusPDWGg4WSDy_jVW=GHP4z-a4qaQ_at_mail.gmail.com>
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 - 11:45:42 CET