RE: Sparc IV Plus upgrade

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Fri, 17 Aug 2007 08:39:50 +1000 (EST)
Message-ID: <790446.53599.qm@web31901.mail.mud.yahoo.com>

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

We do not use ASMM because there is still an open bug in 10.2.0.3 where MMAN hangs and brings the whole instance to its knees and in this case with ASMM the shared pool used to grow to 20G (sga_target 60G)

Thanks
Fairlie

Tanel Poder <tanel.poder.003_at_mail.ee> wrote:

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.

          Fairlie Rego
Senior Oracle Consultant
  http://el-caro.blogspot.com/
  M: +61 402 792 405

Get the World's number 1 free email service. Find out more.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 16 2007 - 17:39:50 CDT