Peter Welcome to the modern DBA's challenge. - Consider RAID - Pay attention to your cache size (battery-backed, of course) - Test - Eternally the System administrator would prefer you to use fewer devices, makes his/her life easier. The DBA wants many devices. Negotiate. Share. - What performance is required of this database? As was discussed yesterday on this list, a lower-performance database will be okay on a single device. Put control files, redo on separate devices. If really good performance / high transaction rates are required, then lobby for more devices.
Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, March 27, 2003 8:49 PM To: Multiple recipients of list ORACLE-L Hi Friends Now a days the disks are coming with 36/73Gb sizes for AIX, How can I make small filesystems to put data and indexes separately?? Although I have FastT700 controller, Is it okay putting all dbf files under one filesytem?? Does it affect performance, How about putting rbs/temp/redo?? Do I need to put under different filesystems?? Suppose I have two controller, How can I know, How many channels are there?? I have 25Gb table, what is the methodology for setting initial and next extents?? My DB is OLTP its conitousely growing on AIX 5L with Oracle 817. TIA peter. _________________________________________________________________ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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: DENNIS WILLIAMS 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).
