Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.glorb.com!indigo.octanews.net!green.octanews.net!news-out.octanews.net!authen.white.readfreenews.net.POSTED!not-for-mail Date: Fri, 09 Sep 2005 17:06:47 +0200 From: Umberto User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Stripe Width References: <1126265747.757730.271130@g14g2000cwa.googlegroups.com> In-Reply-To: <1126265747.757730.271130@g14g2000cwa.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 13 Message-ID: <4321a511$0$32202$892e7fe2@authen.white.readfreenews.net> Organization: Read Free News NNTP-Posting-Date: 09 Sep 2005 10:06:57 CDT NNTP-Posting-Host: 9b9b8985.authen.white.readfreenews.net X-Trace: DXC=T]joB@=M0LGJQZ6GiNcdgMb_[jUcf=dBGPH=X44`;MPI4S9AW9NmNEL05idTa2@M?J\1fk>QH1kVDdT:n6QNEM`CWV39Uj5DfEN?lgcWfC2[ME X-Complaints-To: abuse@readfreenews.net Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251166 sushil wrote: > What are the advantages/disadvantages of using a bigger stripe width > for datafiles at the storage level. > IIRC, striping is used to distribute data across spindles in a RAIDset (sort of 1Mb on spindle 1, then 1 Mb on spindle 2, etc.) to avoid localization of data on a single spindle, which may impact RAID performance. Apart from that, I don't think it makes a lot of difference, as far as Oracle is concerned, whether you choose 1Mb or 4Mb. So, I'd simply choose the value recommended by the RAID manufacturer, it's more storage dependent than database dependent, IMO.