topic Re: Performance on Oracle to Oracle load in Data Engineering

Performance on Oracle to Oracle load

caomayan — Fri, 17 Jan 2025 15:32:56 GMT

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!

Re: Performance on Oracle to Oracle load

v-achippa — Tue, 21 Jan 2025 08:42:06 GMT

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

Re: Performance on Oracle to Oracle load

caomayan — Wed, 22 Jan 2025 20:17:33 GMT

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

Re: Performance on Oracle to Oracle load

v-achippa — Mon, 27 Jan 2025 15:14:22 GMT

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

Re: Performance on Oracle to Oracle load

v-achippa — Fri, 31 Jan 2025 12:42:01 GMT

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

Re: Performance on Oracle to Oracle load

v-achippa — Mon, 03 Feb 2025 15:25:31 GMT

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