Dennis I dont have the MEtalink note that says this but here is a clip from one of the forums
<begin quote> Jonathan has given good advice. Also, on Solaris, Oracle db_block_size is limited to 16K. There are some other unix platforms that you can use 32K, but not Solaris. Regards Tom Villane Oracle Support Metalink Analyst <end quote> What version of Oracle are u talking abt ? I was talking abt 8.1.7.4 Babu ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 15, 2003 4:44 PM > Babu - I created a 32K block size database on Solaris. What is the issue? > > Jake - We are doing the same. Nothing big to report. In our case we saw this > coming so we hadn't put any resources in the T64 in several years. The new > Solaris system has newer technology, so it really screams. I had asked list > members for suggestions on rapid data movement to reduce downtime. It turns > out the new box can actually import much faster than the old box can export. > > > > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Wednesday, October 15, 2003 11:39 AM > To: Multiple recipients of list ORACLE-L > > > We moved from a T64 (ES40 4 CPU) to a Sun (6800 2 blades 8 CPU) recently. > There were no problems with the export/import of the 1/2 TB database. > > One big thing was that the max block size on Sun for 8174 is 16K. We had > used 32K on T64. So we had to rethink our multi_block_read_counts, etc. FTS > became kind of slower but I cant say it was due to this move. We were > undertaking a big change that time anyway and we tuned the SQL to get a > better performance. > > One another thing to keep in mind is are you going to change the underlying > filesystem also - meaning are you planning to move from Compaq Storage Works > to some other ? We did that (moved from StorageWorks to Hitachi) and took a > performance beating initially. The problem was due to a misconfiguration on > the Hitachi side and once the rectified it it has become acceptable. Still I > dont see the IO rates the StorageWorks used to deliver.. :-( > > Babu > > ----- Original Message ----- > To: Multiple <mailto:[EMAIL PROTECTED]> recipients of list ORACLE-L > Sent: Wednesday, October 15, 2003 10:54 AM > > Our CIO is pushing a platform change from Tru64 to Sun. We are currently > running a VLDB (~1.5 TB) on Tru64. Does anyone have feedback on the > following: > 1) Experiences with either/both, preferred platform? > 2) Experiences with platform changes? (Time required for migration?) > 3) Any other thoughts? > > Thanks for your feedback. I am just starting to research the issue so I am > interested in any input. > > > > _____ > > Do you Yahoo!? > The > <http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext > %2Csec%3Amail> New Yahoo! Shopping - with improved product search > > -- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle-L 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).
