Re: [suse-oracle] Fwd: Re: Linux system overloaded by oracle and not responding

Instance caging would require Oracle 11.2 and Enterprise Edition

Before that Oracle does not use the Database Resource Manager to limit the
CPU-consumption (controlled by session CPU_COUNT)

In 10.2 Oracle mostly uses the CPU_COUNT to determine DOP (degree of
parallelism)
and influence some latching functionality.

Best regards
Martin Berg

On 06/14/2011 09:43 PM, Ivo Libal wrote:
>
>
> Hi Yann,
> very interesting post. We have 10gR2 and cannot change it now.
> Do you know if CPU_COUNT parameter realy says to oracle how many CPUs to
> use? And that it would be possible to reduce CPU usage by specifying
> cpu_count=15 on 16CPU system?
> thx and regards
> Ivo
>
>
> Dne 14.6.2011 15:05, Yann Neuhaus napsal(a):
>   
>> Hi Ivo,
>>
>> May be you can have a look on that :
>>
>> http://www.dbi-services.com/index.php/blog/entry/oracle-11g-instance-caging-limit-database-cpu-consumption
>>
>> Best Regards
>>
>> Yann
>>
>> -------
>>
>>
>> 2011/6/14 Ivo Libal <[email protected] <mailto:[email protected]>>
>>
>>     Hi,
>>     i would like to ask you about the following issue.
>>     We have systems having 4 CPUs (4core, intel xeon) and quite a lot of ram
>>     (32G or more). it happens that if application (application server jboss
>>     for java and our own application system having connection pool handling
>>     as well for GUI) starts a lot of requests (maybe a lot of complicated
>>     select statemets, or some plsqls) the system gets overloaded and does
>>     not respond for some time. We are using failover cluster (lifekeeper)
>>     and this situation ends in the failover or other symptoms when some
>>     parts of the system dont respond.
>>     We use orarun to set kernel parameters, huge pages, async I/O (increased
>>     max-io-nr) etc.
>>     Is there a way how to control that situation that even if oracle has a
>>     lot of requests that system stays responding in some reasonable way?
>>     Is there any reswource, which could be limited for such situations?
>>     Can you please share your experience how to work with such systems?
>>     Is there any way in Oracle itself how to control it?
>>     Thank you in advance
>>     Ivo
>>     _______________________________________________
>>     suse-oracle mailing list
>>     [email protected] <mailto:[email protected]>
>>     http://listx.novell.com/mailman/listinfo/suse-oracle
>>
>>
>>     
> _______________________________________________
> suse-oracle mailing list
> [email protected]
> http://listx.novell.com/mailman/listinfo/suse-oracle
>
>   

_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle