Oops... Hit the send button by mistake... As I was saying... I peeked at the HPUX doc for version 8.1.7...
http://docs.oracle.com/a87032/0/unixdoc/product_0/a85346.pdf And it looks like 16K is you max... Just look up the appropriate doc for the versions you are working with to determine your max... HTH Tim -----Original Message----- Sent: Wednesday, December 19, 2001 11:12 AM To: '[EMAIL PROTECTED]' Max block size varies by platform and Oracle version... Check out the Oracle Administrators Guide for the OS you are working with... I peeked at the HP UX doc for version 8.1.7 http://docs.oracle.com/a87032/0/unixdoc/product_0/a85346.pdf -----Original Message----- Sent: Wednesday, December 19, 2001 5:30 AM To: Multiple recipients of list ORACLE-L "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?" WRT is an acronym for "With regards to" ;) And the advice about installing the O.S and patches on to these drives (maybe mirrored) seems sound to me. "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?" I *believe* (though have never seen) that you can have a 16k block size on HP, so maybe other platforms will allow this as well.. HTH Mark -----Original Message----- McClure Sent: 19 December 2001 02:25 To: Multiple recipients of list ORACLE-L 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] 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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).
