Resending the email (it bounced back with a "locking" problem) at fatcity. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd ----- Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on 19/12/2001 11:48 AM ----- CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group 19/12/2001 11:07 AM
Where are you putting the RDBMS and application code ? Best mirror the two internal disks and put the RDBMS and application code there. You could also consider putting your Redo Logs --- particularly if you have a RAID-5 array, it would definitely be better to put your Redo Logs on mirrored disks seperate from the database files. How naive and honest the engineer was .... Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "Steve McClure" <[EMAIL PROTECTED]> 19/12/2001 10:25 AM Sent by: [EMAIL PROTECTED] Well we had our meeting with the Hitachi Sales "critter", and engineer. I discovered that they were trying to push a 5 disk raid array and one hot spare at us, because my IT director was really trying to squeeze them on the price of my 10 18GB disk configuration. After the sales guy and engineer went on about how their 4 separate IO paths would make our raid 5 perform as well as any mirrored pair, I got to ask a few questions. Well it turns out that their RAID performs that well with extra large database block sizes. When I pointed out that we currently have a block size of 2k(I didn't build the db), and would be rebuilding the database on the new platform with 8k blocks, he said that "with a small block size like 8k you will really get the best performance out of mirrors or a 1+0". I am sure the sales guy kicked him under the table ;-). The end result is this. We will probably go with the 6 36 GB DISKS. It flat out comes down to the cost of the whole system is just a little over budget, and the drives are where the adjustment gets made. I suspect that I will have much less trouble getting a few extra disks once the system is in the building. I may also mess with things a bit and configure a 1+0 and a mirrored pair. So after that discussion, and all your helpful input I still have two questions. First what use are the two internal drives that aren't in the disk array? Someone suggested to "WRT" them, and I am not familiar with that term. Again I am not sure I want to mirror them, and if they aren't redundant how useful can they really be? Second. If an 8k database block size is tiny, what is a large database block size? 8k is as large as I can go without raw file systems, isn't it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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).
