Re: RAID system max throughput

I'm not sure that I understand the question. Is it:

1. Under max load the RAID does not perform up to its specs?

or

B. Oracle does not stress the RAID enough for it to reach its max performance.

If A, then have the RAID vendor fix whatever the problem is.

If B, then good for you. You have a well designed system.                                                                                             

                    DENNIS                                                             
    
                    WILLIAMS             To:     Multiple recipients of list ORACLE-L  
    
                    <DWILLIAMS           <ORACLE-L_at_fatcity.com>                        
    
                    @LIFETOUCH.CO        cc:                                           
    
                    M>                   Subject:     RAID system max throughput       
    
                    Sent by: root                                                      
    
                                                                                       
    
                                                                                       
    
                    12/07/2001                                                         
    
                    11:40 AM                                                           
    
                    Please                                                             
    
                    respond to                                                         
    
                    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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: tday6_at_csc.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).