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 <[EMAIL PROTECTED]> > <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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). ___________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
