Re: Oracle Performance on Sunfire T2000

From: ~Jeff~ <jifjif_at_gmail.com>
Date: Fri, 13 Feb 2009 12:42:04 +1300
Message-ID: <363634910902121542t74816000ye4ff5813297e13f6_at_mail.gmail.com>

Hi all
We've also been benchmarking for a provisioning app on m5000 vs t5120.  While the database hasn't been driven particularly hard for this we're still seeing some surprising metrics, like "log file sync" taking twice as long on the t5120 (same configuration on backend SAN). Curiously the (multithreaded, non-oracle) app improved performance on the t5120 when the LDOM had it's "CPUs" reduced from 8 to 4. We think this might be to do with time slices or something, but are still investigating with the Sun guys. This reduced the context switching, and isn't relevant to the RDBMS.
On another project individual response sucked, but aggregate throughput was acceptable especially after changing FILESYSTEMIO_OPTIONS to SETALL. On the whole they can be a great little server, but it's not always a plug'n'play proposition - it seems a degree of optimisation is needed: http://blogs.sun.com/glennf/tags/cmt
http://blogs.sun.com/mandalika/entry/running_batch_workloads_on_sun regards,
Jeff Wong
2009/2/13 Bobak, Mark <Mark.Bobak_at_proquest.com>

> Brandon,
>
>
>
> We went through something very similar. In our case, we also moved from an
> old V440 to a new server w/ the new "Coolthreads" CPU. We also ended up
> moving back to the old server.
>
>
>
> -Mark
>
>
>
> *--
> Mark J. Bobak*
> *Senior Database Administrator, System & Product Technologies*
> ProQuest
> 789 E. Eisenhower, Parkway, P.O. Box 1346
> Ann Arbor MI 48106-1346
> +1.734.997.4059 or +1.800.521.0600 x 4059
> mark.bobak_at_proquest.com <mark.bobak_at_il.proquest.com>
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Allen, Brandon
> *Sent:* Thursday, February 12, 2009 12:37 PM
>
> *To:* oracle-l_at_freelists.org
> *Subject:* RE: Oracle Performance on Sunfire T2000
>
>
>
> I just found Metalink note 781763.1 that addresses this exact issue and
> unfortunately the only solution appears to be moving to different hardware.
>
>
>

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

Received on Thu Feb 12 2009 - 17:42:04 CST