Re: Running many instances of Oracle per server
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: adb@xxxxxxxxxxxx
- Date: Fri, 7 May 2010 17:21:45 +0800
Hi Andrew,
I agree with Juan.. this document is a good read for Oracle database
consolidation
http://dl.dropbox.com/u/1308790/Oracle%20Server%20Consolidation.pdf<https://docs.google.com/viewer?url=http%3A%2F%2Fdl.dropbox.com%2Fu%2F1308790%2FOracle%2520Server%2520Consolidation.pdf>
That white paper is also one of the reasons why I wrote this script..
http://karlarao.wordpress.com/2010/01/31/workload-characterization-using-dba_hist-tables-and-ksar/
for easy collection of the database requirements, capacity, and
utilization
for IO and CPU...
... the white paper also highlighted using an "Oracle-based CPU speed test"
(there's a script) that will determine the server's "Speed Unit". This will
be useful if you are migrating to a machine with faster CPUs.. you'll be
using the "Speed Unit" of the old & new machine and the Utilization formula
(Utilization=Requirements/Capacity) to get the forecasted Utilization on the
new server.
the "Speed Unit" of some servers are posted here
http://resources.orapub.com/ProductDetails.asp?ProductCode=CPU_SPEED_TEST&Show=ExtInfo
Regarding the SPEC ratings..
the issue is to get the correlation of the current CPU speed (given the
current requirements) with the CPU speed that I will be migrating to. And
sometimes I can't find the same hardware make on SPEC and also these are
measurements based on non-Oracle system.. so you've got to be extra careful
with the predictions and document why you are using the SPEC numbers..
But if there's anyone using SPEC for consolidation.. I'd like to learn more
and be enlightened :)
- Karl Arao
karlarao.wordpress.com
karlarao.tiddlyspot.com
<https://docs.google.com/viewer?url=http%3A%2F%2Fdl.dropbox.com%2Fu%2F1308790%2FOracle%2520Server%2520Consolidation.pdf>
On Thu, May 6, 2010 at 9:20 PM, Andrew Bryant <adb@xxxxxxxxxxxx> wrote:
> Hello oracle-l,
>
>
>
> With licensing costs in mind, I’m interested to hear just how many Oracle
> server instances people have been able to run on the current generation of
> 8-core servers (and what their total CPU and IO loads are).
>
>
>
> The context of the question is that our institute has had a generous
> site-license for the last decade, but things will be changing when we
> re-negotiate soon. We will be migrating 50 instances onto a small number of
> servers. On the basis of total memory requirements and AWR reports of IO
> and CPU usage we think we can run 10 to 25 instances per server, but this is
> well beyond what we’ve run on our current, 3-year old servers. Are there
> context-switching, or other issues with a large number of instances per
> server? We will also be consolidating to a smaller number of instances.
>
>
>
> Data volume per instance is tens/hundreds GB per database, plus one 200TB
> warehouse (which will be staying where it is!)
>
>
>
> Regards,
>
>
>
> Andy Bryant PhD
>
> Oracle and Mysql administrator
>
> Wellcome Trust Sanger Institute, UK
>
> -- The Wellcome Trust Sanger Institute is operated by Genome Research
> Limited, a charity registered in England with number 1021457 and a company
> registered in England with number 2742969, whose registered office is 215
> Euston Road, London, NW1 2BE.
>
Other related posts:
