Forum Discussion

caomayan's avatar
caomayan
Helper I
1 year ago
Solved

Performance on Oracle to Oracle load

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 conf...
Data Engineering
  • v-achippa's avatar
    v-achippa
    1 year ago

    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

     

caomayan's avatar
caomayan
Helper I
1 year ago

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

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    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's avatar
      v-achippa
      Community Support
      1 year ago

      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's avatar
        v-achippa
        Community Support
        1 year ago

        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