Skip to content

Oracle advanced settings

In most cases, the advanced settings will not be required however Matillion CDC do provide some additional configuration items when setting up your pipelines. Please take a moment to understand what these advanced settings are and what they achieve before incorporating them within your pipeline.

:::warning{title='Warning'} If you are unclear about a particular setting, please reach out to Matillion for support. :::

Oracle Advanced Settings

Pipeline advanced settings can be added at the end of the Add Pipeline journey via the Data Loader UI.

:::

defaultRowPrefetch

The default number of rows to prefetch from the server. Default value is "10". When there are 1000 or more records in a table. Set 'defaultRowPrefetch' to 1000 in the advanced setting. As the defaultRowPrefetch which is 10, did not allows to retrieve all records ahead of the connection timing out.