Re: Re: RAID select

Thanks a Lot

On Mon, 21 Jul 2003 Thomas Day wrote :
>
>Assuming that you have 3 physical devices (NON-RAID, RAID-1, and
>RAID-0+1)
>my quick-and-dirty take on this is:
>
>NON-RAID
> redo logs - mirrored by Oracle
> control logs - mirrored by Oracle
> ORACLE_HOME
> RBS01
> RBS02
> TEMP
> STAT(For PERFSTAT)
>
>
>
>RAID-1
> SYSTEM
> RWEBCONFIG(Less Accessed)
> RTRADE(Less Accessed)
> Archive destination - move to tape
> Backups - copy to tape
>
>RAID-0+1
> USERS01(Heavily Accessd)
> INDEX01(Heavily Accessd)
> INDEX02(Heavily Accessd)
>
>I wouldn't worry about putting the indexes on the same device
>with the
>tables. It is a multi-platter device and each datafile will be
>stripped
>across multiple platters. You may want to look into the stripe
>size
>depending on the number of users who will be concurrently
>accessing the
>database. Basic rule-of-thumb, the more concurrent users the
>larger the
>stripe size.
>
>
>
>
> "bhabani s
> pradhan" To: Multiple
>recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> <bhabaniindia cc:
> @rediffmail.com> Subject: RAID
>select
> Sent by:
> ml-errors
>
>
> 07/20/2003 12:49
> PM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
>Hi
>
>I have a DB server with RAID-1
>and RAID-0+1 (There is no RAID-0).
>Also the NON-RAID diska are available.
>
>I have the tablespaces as:
>SYSTEM
>USERS01(Heavily Accessd)
>RWEBCONFIG(Less Accessed)
>RTRADE(Less Accessed)
>INDEX01(Heavily Accessd)
>INDEX02(Heavily Accessd)
>RBS01
>RBS02
>TEMP
>STAT(For PERFSTAT)
>
>What could be a suitable configuration for
>the datafiles under these tablespaces across
>the available RAIDs. Also where the backups
>and archive_dest should be.
>
>Can anybody give me some tips on this
>
>Thanks and Regards
>
>
>___________________________________________________
>Download the hottest & happening ringtones here!
>OR SMS: Top tone to 7333
>Click here now:
>http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: bhabani s pradhan
> INET: bhabaniindia_at_rediffmail.com
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting
>services
>---------------------------------------------------------------------
>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.net
>--
>Author: Thomas Day
> INET: tday6_at_csc.com
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting
>services
>---------------------------------------------------------------------
>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).