This content has been marked as final. Show 7 replies
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.
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
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?
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
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 ?
Thank you for this very interesting and useful presentation
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
I think it is old. Is there a new alternative?