Re: Running many instances of Oracle per server
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: adb@xxxxxxxxxxxx
- Date: Thu, 6 May 2010 08:24:57 -0500
I am not trying to give you a hard time at all, but in my experience Oracle
performance is much more dependent on user load than amount of data in the
database. That being said, how busy are the CPU's in the servers you
currently have, and what does the memory usage look like? If you have
significant physical IO, you will have to worry about overloading your IO
paths also.
On Thu, May 6, 2010 at 8:20 AM, 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.
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
