Array fetch size and Batch update size

User_6LA6E

I Modified array fetch size and batch update size using ODI studio to test performance related issues. But I am not sure if these changes reflected in the environment. How can I verify if the new values are being used for ODI jobs. Are there any steps required to make the changes to be affected.

User534470-Oracle

You only need to save the settings for the data server.

https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.4/odiad/setting-topology1.html#GUID-2E6355C9-5EBB-438A-85D0-23B27B0A9DB3

Note that array fetch size and batch update is only for JDBC driver and affects only the part where data moves through the agent using JDBC driver. Depending on your mapping there could be other areas where performance tuning might be needed (like SQL code being executed).