This discussion is archived
4 Replies Latest reply: Sep 22, 2013 10:40 PM by http://essbase.ru/ RSS

Enhancing Essbase performance using Exalytics box

62b280cd-d927-48da-b091-49781527f445 Newbie
Currently Being Moderated

Hy,

 

I moved my essbase platform to Exalytics. But, I'm disappointed. My calculation times still the same.

It's a Hyperion Planning cube therefore it's a BSO.

I put the ORACLEHARDWAREACCELERATION TRUE in the CFG. Changed data caches and commit blocks settings.

 

I saw something about RAMDISK. But, if the power shutdown I lost my database !!!

 

What is the infrastructure recommended ? Any help ?

 

Thanks

Marcos Botelho

  • 1. Re: Enhancing Essbase performance using Exalytics box
    GlennS_3 Oracle ACE Director
    Currently Being Moderated

    You should really work with someone who knows exalytics. Yes you should use a RAM disk to improve performance

    look at the presentations from kscope Edward Roske did a session on exalytics as did a few others.

  • 2. Re: Enhancing Essbase performance using Exalytics box
    TimG Guru
    Currently Being Moderated

    Since you're looking for relative improvement, what was your hardware spec before Exalytics?  What kind of concurrency / load?

     

    I'm going to bet that the OP works for an implementation partner - I doubt many end customers buy Exalytics speculatively without any pre-sale benchmarking / PoC.

  • 3. Re: Enhancing Essbase performance using Exalytics box
    CL Oracle ACE Director
    Currently Being Moderated

    I think of Exalytics as an incredibly broad river.  Or very big pipe.  That also happens to be pretty darn quick.

     

    Or maybe a better analogy is (I am putting on my have-always-been-fascinated-by-warships hat):  Exalytics is a really fast battleship (BB).  There are destroyers (DDs) out there might be faster, but when you want to project power, BBs are the answer, not DDs.  So clawing my way back to relevancy, Exalytics seems to provide fast performance and extremely large capacity.  Other servers may offer roughly equivalent performance when it comes to completely isolated calculation tests, but then fall over when more than a few people use the box.  <--I think TimG was alluding to this when he asked about concurrency.

     

    Did you try this out using a RAM drive? (There are ways of mitigating Planning in RAM data.) What was your RAM disk performance vs. the physical disks?  Do you have the flash pack? http://looksmarter.blogspot.com/2013/05/ExalyticsWithFlash.html

     

    Regards,

     

    Cameron Lackpour

  • 4. Re: Enhancing Essbase performance using Exalytics box
    http://essbase.ru/ Explorer
    Currently Being Moderated

      I am not believe in Exalytics because

          Essbase it is old man - and can't do utilisation  for all newest hardware.

                  --  Essbase CalcParallel - can't work correctly since 5 years from first implementation

                  -- Essbase Don't Really need in the RamDrive. in all performance test - it's getting only 20%  vs SATA II drive.

                 Because Can't Calc more data block in single CPU mode.

     

     

    My opinion it's simple

          -If you need real decision for getting better performance

            u have only one way -   It's redesign application:

                           Use simplest Essbase calculation

                            NEVER use CREATENONMISSINGBLK and other

                                   - create calculation from source slice

                                          FIX (Source)

                                             MBR1(

                                               target->MBR1=MBr1;

                                               )

                                           ENDFIX

     

                           If u realy need big  complex essbase calculation - use Essbase Custom Relation Calculation.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points