Re: CPU_COUNT

From: RB <burton.rob_at_gmail.com>
Date: Sat, 5 Sep 2009 04:42:42 -0700 (PDT)
Message-ID: <c2d971e2-442d-4f9b-9e69-485d441cb75f_at_y36g2000yqh.googlegroups.com>

11.2 has introduced instance caging where you can limit cpus used by an instance by setting cpu_count

From New Features Guide
1.5.1.2 Instance Caging

Instance Caging allows the DBA to limit the CPU usage of an Oracle instance by setting the CPU_COUNT initialization parameter and enabling CPU resource management.

With Instance Caging, users can partition CPU resources among multiple instances running on a server to ensure predictable performance.

On 4 Sep, 19:24, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> On Sep 4, 2:09 pm, Sue <suesch..._at_gmail.com> wrote:
>
> snip
>
> > Does anyone know what CPU_COUNT means on a mulit-core machine?  Say
> > you have a four core cpu.  Does setting CPU_COUNT to 1 use all 4 cores
> > on 1 CPU or 1 core on a CPU?
>
> Each core looks like to oracle a cpu ... this is not a throttling or
> hard/soft partitioning mechanism.
>
> Never heard of anyone trying to set it directly ... oracle picks it up
> from the operating system.
>
> If you have a system that does some kind of hard partition of cpu
> resources then oracle only see's what is available in that partition
> ( so sets CPU_COUNT correctly ).
>
> There's a bunch of info in metalink on this ...
>
> http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initpa...
Received on Sat Sep 05 2009 - 06:42:42 CDT