I always believe in loading them up with as much memory as possible, since Oracle doesnt charge extra licensing fees for memory. I suspect your CPU usage will be ok, as someone noted the speed of CPU's has increased dramatically, however to me, and this is really without sufficient information other than personal experience, it appears that IO may be your biggest problem. You might try and increase the number and bandwidth of your HBA's or whatever you are using as much as possible. On Thu, May 6, 2010 at 9:06 AM, Juan Miranda <jcmiranda@xxxxxxxxx> wrote: > Hello > > > > I think you can have a great ratio of consolidation because 3 years are a > looong time in “CPU time”. > > You can use this xls to compare and estimate server power. > > http://dl.dropbox.com/u/1308790/Benchmarks_ene2010.xls > > > > There is a lot of bechmarks in these worksheet that you can use to estimate > the future load one server can support. > > The worksheet don´t have any Xeon 56xx and this CPUs are 40% faster than > 55xx… > > > > Some docs about Oracle consolidation: > > http://dl.dropbox.com/u/1308790/Oracle%20Server%20Consolidation.pdf > > http://dl.dropbox.com/u/1308790/HP_linux_consolidation.pdf > > > > Regards. > > Juan. > > > ------------------------------ > > *De:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > *En nombre de *Andrew Bryant > *Enviado el:* jueves, 06 de mayo de 2010 15:21 > *Para:* Oracle-L@xxxxxxxxxxxxx > *Asunto:* Running many instances of Oracle per server > > > > 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. > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'