Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RAID system max throughput
Jack - Well, that's what I thought. I could see where the disk would be a lot better about streaming data off the disk if the data was arranged in a favorable manner rather than randomly located. However, I was told that was simplistic thinking and that modern RAID systems are much more sophisticated than that. And I'm willing to concede that a RAID system is more complex than simple drives. I'm just hoping that someone on this list has more experience on the database/hardware interface. Thanks.
-----Original Message-----
Sent: Friday, December 07, 2001 3:25 PM
To: Multiple recipients of list ORACLE-L
Dennis,
I'm no RAID guru, but I can sure imagine disk heads thrashing around, trying to satisfy a mix of sequential and random reads and writes, causing the DB to wait, but not getting anywhere near the rated throughput for the RAID controller or channel.
Could that possibly be the case?
Jack
-----Original Message-----
WILLIAMS
Sent: Friday, December 07, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
Whenever I discuss disk waits with my system administrator, I always get the reply that "the RAID system isn't anywhere near its rated throughput". Maybe I'm wrong, but I don't see any of the tuning books mentioning that as a relevant performance characteristic. However, I've never been able to move the discussion beyond this point. Can anyone straighten me out on this point or point me to a resource that might be applicable.
Our system is Oracle 8.1.6, Compaq Tru64. We use hardware RAID-5 with a battery-backed RAM cache, and have about 3 RAID sets (plus some extra disks for redo logs, etc.), and performance is fine, but I'm always looking as to how we can improve Oracle performance. The application is our corporate ERP system.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: japplewhite_at_inetprofit.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Dec 07 2001 - 16:39:00 CST
![]() |
![]() |