- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Best disk RAID configuration for Oracle 8.0.X OLTP...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2002 01:05 PM
тАО04-22-2002 01:05 PM
Now i have an Oracle's instance resident on HP4000 server. To day the data are on HP Surestore XP512 with RAID 5 configuration. Any idea who are the best RAID configuration for OLT? Data Bases, RAID 5 or RAID 0 + 1?
Thanks in advance for your comments.
OTV.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2002 01:08 PM
тАО04-22-2002 01:08 PM
Re: Best disk RAID configuration for Oracle 8.0.X OLTP Data Base
But I have no benchmarks to prove, This is just what I have been told.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2002 01:14 PM
тАО04-22-2002 01:14 PM
SolutionIt depends on the $$ you want to spend , incase you want a cost effective and better through put and redundancy then RAID 5 is the the best thing , hoever if you have $$$ then Raid 0+1 will be the solution . Please not that in bothe cases the response time would be same but in case of RAID 5 if you ahve moer than one disk going down then the data is gone however this is very rare.
Manoj Srivastava
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2002 01:27 PM
тАО04-22-2002 01:27 PM
Re: Best disk RAID configuration for Oracle 8.0.X OLTP Data Base
We can go round and round on this performance issue. Because there are some many diffrent varibles involved.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2002 11:22 PM
тАО04-22-2002 11:22 PM
Re: Best disk RAID configuration for Oracle 8.0.X OLTP Data Base
What Oracle themself recommend these days is SAME; Stripe And Mirror Everything.
Andreas
(I miss OFA!)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2002 03:49 AM
тАО04-23-2002 03:49 AM
Re: Best disk RAID configuration for Oracle 8.0.X OLTP Data Base
From what i have seen ,
If you are using EMC symm, go for RAID 0/1.
IF Xp512, go for RAID5.
WIth EMC, you can also use Metavolumes (which spreads luns across physical disks ,thereby giving an additional level of striping).
Physical disk config is only part of the solution. The lv stripe size should be set appropriate to your requirements. I normally set the distributed 1Mb extend and it works well.
HTH
raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2002 04:39 AM
тАО04-23-2002 04:39 AM
Re: Best disk RAID configuration for Oracle 8.0.X OLTP Data Base
Generally, RAID-5 on an XP will outperform RAID 0/1 in most cases, except for small block random writes, where RAID-5 is about 15-20% slower. In most databases, this is hardly noticable.
Compared to EMC's RAID-S, (which is rated by EMC at 15% of the performance of RAID-1), the XP's RAID-5 is viable alternative with about 85% (overall) the performance of RAID 0/1.
A more important choice is drive size. It's faster when you keep logs on the 18GB/15k drives. RAID-5 is OK for logs because it's mostly sequential writes, which are highly optimized in the XP.
RAID-0/1 is suggested in databases where you have a high insertion rate - use them for indices and dataspaces, as your budget allows. Insertions into the database cause small block random writes.
Cache is another important item. Adding more cache can significantly increase your performance.
80-90% of all XP's out there (about 4000 now!) are running 100% RAID-5. Most all of them are used with databases.
Good Luck!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2002 12:28 PM
тАО04-23-2002 12:28 PM
Re: Best disk RAID configuration for Oracle 8.0.X OLTP Data Base
I see you're with HP. Is the staement:
"80-90% of all XP's out there (about 4000 now!) are running 100% RAID-5. Most all of them are used with databases."
Is this a fact that can be backed up with data? Just curious as I may have to justify my use of 100% RAID 5 on my XP512 for multiple Oracle DB's.
Thanks,
Tom