7 Replies Latest reply: May 13, 2013 10:05 PM by Mahmoud_Rabie RSS

    Best Performance for apex over Linux+HW RAID

    Mahmoud_Rabie
      Dear Experts,

      Given:
      -- Server Specs:
      ---- HP ProLiant ML370 G6 E5540
      ---- Processor name: Intel® Xeon® E5540 (4 core, 2.53 GHz, 8MB L3, 80W)
      ---- Storage Controller: (1) Smart Array P410i/256MB
      ---- 8 SAS HardDisks with 320 GB for each
      ---- 12 GB RAM

      Required:
      1)) What are the best practice bring the best performance to Apex for the following solution stack
      ---- Oracle Linux 6.3 x86_64
      ---- Grid Infrastructure 11g R2
      ---- Database 11g R2
      ---- Oracle Apex 4.2.1

      2)) What is the best hardware RAID configuration?

      3)) What is the maximum concurrent users of applications on apex according to the above specs+software stack ?

      Regards
      Mahmoud
        • 1. Re: Best practice in installation of Linux+HW RAID+Oracle DB/Gridinfrastrucute
          rukbat
          Moderator Action:
          Your post suggests that your ultimate expectation is to install Apex and have it function well.

          Therefore this thread has been moved from the Oracle Linux forum to the Apex forum for closer topic alignment.

          Apex users might have experienced your scenario before.
          Readers of the Oracle Linux forum are not likely to be quite so familiar with the needs of Apex.
          • 3. Re: Best practice in installation of Linux+HW RAID+Oracle DB/Gridinfrastrucute
            alvaromiranda
            For the disk performance, there is no single path or the best best practice

            so here my suggestion.

            Create a raid 10 on the 8 disks, this will avoid parity checks and will the best for performance.

            Now, when you boot the server with the smartcd on it, and you go the ACU (array configuration utility) window, you have 2 was to create disks.

            The normal is you choose the disks, the RAID level then the system will create 1 BIG c0d0 virtual disk.

            Don't do that.

            Use Logical Disk on top of the raid, in that way you can create say
            20GB c0d0 for OS
            16GB c0d1 for SWAP
            XXGB c0d2 for ASM DATA
            XXGB c0d3 for ASM FRA


            When you are on the acu:

            create new Array using “Configuration Wizards” available at right bottom of screen. In next screen, click on “Create Array” -> Begin
            * Select Drive Type of Array -> SAS
            Check “Select All”. It will “create SAS Array A” with unused space. Click on finish.
            * Click on “Create a logical drive” -> next screen has Array A selected Go “Next”

            Edited by: Alvaro Miranda on Feb 17, 2013 12:03 PM
            • 4. Re: Best practice in installation of Linux+HW RAID+Oracle DB/Gridinfrastrucute
              Mahmoud_Rabie
              Dear Alvaro

              Thank you for your response.

              The current status
              -------------------------
              When I entered HP ACU from bootable Smart Start CD, I found under the configuration of Smart Array P410i in Embedded Slot, the following:
              -Smart Array P410i in Embedded Slot
              ---Internal Drive Cage at Port 1I : Box 1
              ------300 GB 2-Part SAS Drive at Part 1I : Box 1 : Bay 1
              ------300 GB 2-Part SAS Drive at Part 1I : Box 1 : Bay 2
              ------300 GB 2-Part SAS Drive at Part 1I : Box 1 : Bay 3
              ------300 GB 2-Part SAS Drive at Part 1I : Box 1 : Bay 4
              ---Internal Drive Cage at Port 2I : Box 1
              ------300 GB 2-Part SAS Drive at Part 2I : Box 1 : Bay 5
              ------300 GB 2-Part SAS Drive at Part 2I : Box 1 : Bay 6
              ------300 GB 2-Part SAS Drive at Part 2I : Box 1 : Bay 7
              ------300 GB 2-Part SAS Drive at Part 2I : Box 1 : Bay 8

              The questions now:
              --------------------------
              1) Do you recommend the following configuration for RAID's logical arrays:
              Using Logical View:
              SAS Array A - 4 Logical Drive(s)
              --- Logical Drive 1 (50.0 GB, RAID 1+0) ---> for OS
              --- Logical Drive 2 (24.0 GB, RAID 0) ---> for SWAP
              --- Logical Drive 3 (200.0 GB, RAID 1+0) ---> for ASM DATA
              --- Logical Drive 4 (296.7 GB, RAID 1+0) ---> for ASM FRA
              SAS Array B - 1 Logical Drive(s)
              --- Logical Drive 5 (1.1 TB, RAID 0) ---> for non-critical applications and sources

              2) What are your recommendations for the following steps to reach oracle apex 4.2 installed?

              Best Regards
              Mahmoud
              • 6. Re: Best Performance for apex over Linux+HW RAID
                Kiran Pawar
                Hello Mahmoud,

                >
                Mahmoud_Rabie wrote:

                Required:
                1)) What are the best practice bring the best performance to Apex for the following solution stack
                ---- Oracle Linux 6.3 x86_64
                ---- Grid Infrastructure 11g R2
                ---- Database 11g R2
                ---- Oracle Apex 4.2.1

                2)) What is the best hardware RAID configuration?

                3)) What is the maximum concurrent users of applications on apex according to the above specs+software stack ?
                >

                The answer for the first question lies in have you used best practices for performance enhancement while developing the application itself or have you identified the performance bottlenecks:
                >
                What are the best practice bring the best performance to Apex for the following solution stack
                >
                Refer:
                http://prezi.com/gfmw8q_gstcl/n-methods-to-improve-oracle-apex-performance/

                The answer of the last question lies in the what is the average page-view time for your application:
                >
                What is the maximum concurrent users of applications on apex according to the above specs+software stack ?
                >
                Refer:
                http://www.oracle.com/technetwork/issue-archive/2007/07-jan/o17browser-083149.html

                Regards,
                Kiran
                • 7. Re: Best Performance for apex over Linux+HW RAID
                  Mahmoud_Rabie
                  Hello Kiran,

                  Thank you for this very interesting and useful presentation
                  http://prezi.com/gfmw8q_gstcl/n-methods-to-improve-oracle-apex-performance/

                  As I found ordered by importance, the factors impacting Oracle Apex performance are:
                  1) Hardware --> This is why I am concentrating in hardware RAID configuration optimum for write-intensive application and operating system Linux optimized configuration if any.
                  2) Data Distribution
                  3) Table Design
                  4) Table Size
                  5) Database Version
                  6) Server Load

                  About the second link
                  http://www.oracle.com/technetwork/issue-archive/2007/07-jan/o17browser-083149.html
                  I think it is old. Is there a new alternative?

                  Regards
                  Mahmoud