1 Reply Latest reply on May 7, 2019 2:03 PM by Nico Heinze

    Decrease in performance after the powercenter upgrade from 9.5 to 10.1

    Vidya M C New Member

      Hi All,

       

      Recently i have upgraded the informatica powercenetr from version 9.5 to 10.1 after the upgrade i see the major slowness in the DB procedure execution  . GRID Db version is ''Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production''

       

      Both the db's are on cloud systems

       

      GRID DB Details

       

      Target DB details

       

       

       

      Can anyone tell why the queries are taking long after upgrade?

        • 1. Re: Decrease in performance after the powercenter upgrade from 9.5 to 10.1
          Nico Heinze Guru

          There's no general answer to such a question. You will have to analyse using the standard techniques where exactly the performance decrease shows up; this may be because the source DB delivers records slower than before; it may be that the network (for whatever reason) transports the data slower than before; it may be that the session runs slower than before.

          Please consult the Performance Tuning guide for PowerCenter and find out whether you have a source bottleneck or a transformation bottleneck. Then follow the guidelines provided in this PDF file to find out how to remedy this situation.

           

          Regards,

          Nico