Forum Discussion

alessandro_horsa's avatar
alessandro_horsa
Copper Contributor
Dec 18, 2023

Copy data to Oracle destination

We are trying to copy data to an Oracle DWH, and we are facing issue when trying with different setups on the “Write Batch Size” parameter.   The copy activity works when we set the “Write Batch Si...
Kidd_Ip's avatar
Kidd_Ip
MVP
Feb 21, 2026

You are right, Azure Data Factory (ADF) behaves differently depending on the WriteBatchSize setting when writing to Oracle, in short, you may consider small batch sizes as safe but slow while large batch sizes require extra Oracle privileges because the connector uses optimized bulk insert logic.

You may get your DBA involved to grant the necessary privileges or configure the connector to use a mode compatible with your current rights.

 

https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?tabs=data-factory

 

https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-performance-troubleshooting

 

  • alessandro_horsa's avatar
    alessandro_horsa
    Copper Contributor
    Feb 23, 2026

    Hi Kidd_Ip​ 
    thank you for your kind reply.

    We resolved the issue connecting to Oracle with a user named with the same name as the Oracle schema.

    I know it could sound weird, but in this way we can leave the default value on WriteBatchSize parameter and getting optimal performances.

    As you suggest that user probably has the required privileges for larger batch size.

    Thanks

    Alessandro