I am using Talend 6.4. We noticed, that when Talend is getting data from the Oracle database it does it in many very small packets, which causes poor read performance.
We've got better performance on tOracleInput components by using the "Use cursor" option.
But the problem persists with tOracleSP component.
Is there any way to change tOracleSP component behavior, to return data in larger packets? When the database returns larger BLOB there is a lot of network overhead when using small packets and this causes poor flow performance.
I'm not certain, but I've got a feeling you might be looking to use the "InsensitiveResultSetBufferSize" parameter which is described here https://docs.oracle.com/cd/E13222_01/wls/docs81/jdbc_drivers/oracle.html. Look at the Additional JDBC Parameters on the Advanced tab. As I said, I am not certain and cannot test it myself at the moment. Let me know if it works
