RE: Oracle issue with Ultrasparc CPU's

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 18 Jul 2006 15:56:09 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410507E434F5@usahm236.amer.corp.eds.com>

I have experienced going from 12 Cpu SMP to 4 CPU Numa and 4 was better though much of the improvement was most likely due to the fact we also replaced the disk farm from 150 small disks to 16 disks in an EMC unit. On the old system 2.5 hours to rebuild one index. On the new system 15 minutes.

---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams

	Sent: Tuesday, July 18, 2006 3:28 PM
	To: paulastankus_at_yahoo.com
	Cc: oracle-l_at_freelists.org
	Subject: Re: Oracle issue with Ultrasparc CPU's
	
	
	Paula,
	 
	So, you are saying you went from 8 CPUs to 4 faster CPUs? In

itself I could see that might cause performance to degrade. For most Oracle databases, there are many simultaneous processes. With fewer CPUs, as the server moves from process to process, there must be more CPU context switches. Having faster CPUs reduces the impact somewhat, but it might still not balance out to a net zero change in performance.          

        Dennis Williams

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

Received on Tue Jul 18 2006 - 14:56:09 CDT