Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sparc IV Plus upgrade

RE: Sparc IV Plus upgrade

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Thu, 16 Aug 2007 21:52:02 +0800
Message-id: <010601c7e00c$9febf960$6701a8c0@windows01>


Well I assume the Sparc IV+ CPU is faster than Sparc IV one.  

Which could mean that your shared pool fragmentation could drop as cursors are held pinned for shorter time ( credit for that info goes to Anjo Kolk )  

Which could mean that your shared pool has less memory pressure.  

Which could mean that the automatic SGA memory manager may decide to use more memory for buffer cache than before  

Which could mean that more blocks stay resident in buffer cache and for longer time  

Which could mean that CKPT decides to switch on physical read prefetching  

Which could mean that whole IO goes actually a lot slower  

Which could mean to management, that faster CPUs make systems slower, thus you need more slower CPUs :)  

Tanel.


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of fairlie rego
Sent: Thursday, August 16, 2007 16:10
To: oracle-l_at_freelists.org
Subject: Sparc IV Plus upgrade

All,  

Environment: 8 node RAC on Solaris Sun sparc 9 64 bit Database : 10.2.0.3 RAC  

Customer is upgrading CPU boards from Sparc IV to Sparc IV pluses. There is no change in the number of cpus.  

Assuming there is no collection of system stats (which could thus affect query plans) can anyone think of any other issues...in doing this upgrade...  

Also is anyone out there using Sparc IV pluses.  

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 16 2007 - 08:52:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US