| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle on Sun vs Tru64
According to the 9.2 admin guide for Solaris the limits on db block size
are...
Parameter Default Value Range of Values DB_BLOCK_SIZE 2048 2048 to 16384 (Linux, Solaris 32-bit) 2048 to 32768 (AIX, HP,
Page 1-22 @ http://download-east.oracle.com/docs/pdf/A97297_01.pdf
But, the 8.1.7 admin guide for Solaris says...
Parameter Default Value Range of Values DB_BLOCK_SIZE 2048 2KB - 16KB
Page 1-24 @ http://download-east.oracle.com/docs/pdf/A85349_01.pdf
Dennis, what version are you running?
Tim
-----Original Message-----
Sent: Wednesday, October 15, 2003 5:44 PM
To: Multiple recipients of list ORACLE-L
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.
dwilliams_at_lifetouch.com
-----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
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: DWILLIAMS_at_LIFETOUCH.COM
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Wed Oct 15 2003 - 17:34:25 CDT
 |
 |