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.
