DSXchange

HI There,

What should be the Ideal value for properties "Prefetch row count" and "Prefetch buffer size " in Orcale Connector stage?

No such thing as "ideal values" there.

I am also curious about the "Prefetch row count" setting. It defaults to 1. Never really paid any attention to it before. The help hover text just says to enter the number of rows to prefetch. It kind of sounds like a bonus French fry.

Well, there's always something like this but it isn't all that helpful IMHO. And any official Oracle documentation I could find back then like this one all discuss its use in the JDBC drivers, so not sure how valid changing it is unless you are using them. Seems like a question for support. And no, not anything like a bonus French Fry.

I actually found both those links quite helpful. Thank you. They give a more detailed explanation. I had searched and not found that explanation.

I think we can disregard the JDBC driver part and see that it's an Oracle Client feature that the Connector stage supports. Am going to have to test it out to see if there's any noticeable difference...

I await the outcome with baited breath!