Re: Running many instances of Oracle per server
Date: Fri, 7 May 2010 15:33:08 -0500
Message-ID: <y2y9a600bbf1005071333x7108b89ehb440c2b5c4694c3e_at_mail.gmail.com>
If you put multiple instances of 10g (or newer) on a host, you might want to consider, if possible, shifting some of their maintenance windows so that they all don't start their nightly maintenance at 10pm, all at the same time. Or at least be aware of possible performance problems at that time. --Scott
On Thu, May 6, 2010 at 8:20 AM, Andrew Bryant <adb_at_sanger.ac.uk> 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.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 07 2010 - 15:33:08 CDT