4 Replies Latest reply: Aug 6, 2013 4:36 AM by Spicer RSS

    Slowness in 11 1 2 1 calculations vs 9 3 1

    Gabi
      Hi,
      Since we upgraded to 11.1.2.1, 64 bit (from 9.3.1 32 bit), we are having performance problems in calculations.
      We did a lot of checkings with Oracle Support help, and we didn't manage to solve the problem.
      Those checkings included System Preferences, apples to apples comparision (exactly the same DB in the same application, with the same definitions and the same data), running calc as HBR, calc, from eas and from planning.

      We noticed that the performance problem is only in "sparse calculations", minning that the left side of the formula is a sparse member. For example:

      Period and Accont are Dense
      Region and Year are Sparse

      This calc runs ok (same time an both 11.1.2.1 and 9.3.1):

      FIX(FY12, America)
      JUN=JUN->FY11
      ENDFIX

      This calc doesn't run ok (20 min in 9.3.1, hours in 11.1.2.1, or 1 sec in 9.3.1 and 2 min in 11.1.2.1)

      FIX(FY12)
      America=America->FY11
      ENDFIX

      Somebody knows what is the solution to this problem?

      (PLEASE NOTE THAT WE SEE AS A PROBLEM ONLY THE DIFFERENCES IN PERFORMANCE BETWEEN SYSTEMS, WE DON'T LOOK FOR ADVISES SUCH AS "USE DENSE CALC").

      Thanks,

      Gabriel