Re: Striping Disks

In my opinion you should ONLY stripe disks when you have or can achive 7+ separate volumes, and here is why. On a striped volume you (the DBA) lose all ability to control the "hot spots". In a striped volume Oracle only "sees" & reports activity against the single striped volume. You have NO way of identifying the cause of "hot spindle(s)" because you have no way of "mapping" what data physically resides on which physical volume. For myself I only use RAID-1 volumes.

HTH & YMMV! Ashish Shah wrote:
>
> Hi All,
>
> I have 6 * 9 GB disks on Sun solaris. Any
> recomendations abouts how do I go about
> striping them for better I/O.
>
> Make sure you include redo,system,data,indx,arch,temp,
> and backup files..
>
> Should I strip all 6 disks equally and place files
> accross???
>
> Thanks.
>
> =====
> Ashish
> Toronto, Canada
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: Ashish Shah
> INET: ar_shah_at_yahoo.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).

-- 
Charlie Mengler                               Maintenance Warehouse  
charliem_at_mwh.com                              5505 Morehouse Drive   
858-552-6229                                  San Diego, CA 92121    
Always be sincere about your enthusiasm, whether you mean it or not.