Performance on Oracle to Oracle load

[caomayan]

Happy New Year!

I am using the on-prem gateway to load Oracle data into Oracle database, the load speed is really slow, the insert process is just 5kb/s which is not acceptable. Is there any configuration or suggetions? 

Thank you!

[v-achippa]

Hi @caomayan,

We support for Microsoft Fabric and Power BI related issues, we are not the community for Oracle.

Thanks and regards,

Anjan Kumar Chippa

[caomayan]

Thanks Anjan, but our solution in within Microsoft Fabric data pipeline to load Oracle data, is there any suggestions?

[v-achippa · Accepted solution]

Hi @caomayan,

Thanks for confirming that your issue is in fabric.

As per my observation, there is no error here but there is a performance latency issue. So I suggest you to please follow the below steps:

• Check for table indexes and constraints that might slow down inserts. Temporarily disable them during bulk loads.
• Partition target tables if dealing with large datasets.
• Reduce Data Volume, only transfer the data you need by applying filters at the source query level.

If the issue still persists, I suggest you to please raise a support ticket 

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @caomayan,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or have you raised any support ticket?
If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @caomayan,

We wanted to kindly follow up to check if the solution I have provided for the issue worked? or have you raised any support ticket?
If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa