- Community Home
- >
- Servers and Operating Systems
- >
- Legacy
- >
- Netservers
- >
- Re: RAID performance with Oracle DB
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
тАО10-01-2003 03:39 PM
тАО10-01-2003 03:39 PM
RAID performance with Oracle DB
I have a DB that's about 15GB. I have just restored the database to a fresh install on my LH 3 (2x400PII, 512MB, 8-10KRPM, 18.2GB drives in RAID5). I restored it from my laptop (P4-3.06GHz, 1GBRAM, 60GB, 5400 RPM). If I do a select count(*) on a 4.5 million record table on each machine, I get the following results.
Laptop - 10 Sec.
Netserver - ~45 Sec.
What could be causing the huge difference in DB response. I'm assuming it's a drive IO issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2003 05:10 PM
тАО10-01-2003 05:10 PM
Re: RAID performance with Oracle DB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-02-2003 12:35 AM
тАО10-02-2003 12:35 AM
Re: RAID performance with Oracle DB
The Processors in th LH3 only show about 25-30% untilization running the query.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-02-2003 01:53 AM
тАО10-02-2003 01:53 AM
Re: RAID performance with Oracle DB
A well approved writeup on keeping to RAID5
Please go thru this ----------
RAID Performance Trade-offs
Conventional RAID demands a performance versus efficiency trade-off. This trade-off is
rooted in RAID Level 5, the most frequently implemented and commercially successful
variant of RAID. RAID 5 makes efficient use of disk space but often uses four distinct
write operations to put data onto disk. This is referred to as the ├в RAID 5 Write Penalty.├в
This penalty consumes resources and impedes overall application performance.
A technique called the Block Pooling is used to avoid the RAID 5 Write Penalty. The
Block Pool is reserved space on disks that functions as ├в virtual cache├в for disk write
processes. When data is to be written to RAID 5 disk, the RAID 5 Write Penalty is
avoided by first writing that data to the Block Pool using swifter RAID 0+1. Then in a
background process, relocates the data from the Block Pool to disk using the more space
efficient RAID 5. The Block Pool eliminates performance-robbing ├в backpressure├в on the
application from sluggish RAID 5 disk write operations. Figure 3 shows the interaction of
Concatenated Writes, Write Back Cache and the Bloc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-02-2003 01:57 AM
тАО10-02-2003 01:57 AM
Re: RAID performance with Oracle DB
Please find the attachment.
Hope that helps you.
Revert,
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2003 03:52 AM
тАО10-06-2003 03:52 AM
Re: RAID performance with Oracle DB
Have been to the document ? Its provided by HP !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2003 05:09 PM
тАО10-17-2003 05:09 PM
Re: RAID performance with Oracle DB
A pair of 600Mhz will give you better performance. You might also want to consider if you have ReadAhead/Normal settings in Netraid, cachedio,writeback/thru. what are you OS drives running on Software Raid/Hardware Raid, Is the Data on different Raid adapter/array.
Your laptop is definitely better in terms of processor speed. And it is running of only one single drive with no parity,unlike your server which has parity in disks plus it is flowing thru netraid adapter memory.
your laptop would have ddr memory which is faster than normal sdram memory.