Re: cpu_count per instance in a hard partition

Hello Patrice,

> does the Oracle software know that five instances are running from the same home?

Short answer - no. However you can use OS implementations like cgroups (Linux) or WLM (AIX) to control the resources over all Oracle instances. Oracle RDBMS also has an integration into some of these OS features like cgroups.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Patrice sur GMail <patrice.boivin_at_gmail.com> hat am 23. November 2018 um 14:53 geschrieben:
>
> Hi, 
>  
> a possibly dumb question:
>  
> If you have a hard partition with 2 cores but 8 threads total but are running five Oracle instances within that hard partition, does the Oracle software know that five instances are running from the same home?  Or is each instance oblivious to the fact that it is sharing resources with other instances.
>  
> I ask because if we set cpu_count=8 in each of five instances, doesn't that mean the instances expect the hard partition to provide a total of 40 threads?
>  
> If they are aware of their environment then each instance could say "well obviously they are lying to me, I only really have 8/5 threads available to me, though we are sharing resources so sometimes I will have more time slices, other times, not as many."
>  
> Overloading may not cause major problems other than each instance not getting as many time slices as it expects, i.e. each one would end up running slower than optimal.   (reminds me of when I was a student working on an overloaded mainframe which had more dumb terminals than recommended, each dumb terminal had to wait for time slices)  Meanwhile there would be nearly no wasted time slices because the CPUs are very busy. 
>  
> -- Patrice
>
> My profiles: [](http://www.facebook.com/home.php#!/profile.php?id=100000206805521)[](http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9)[](http://www.twitter.com/PatriceBoivin)

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