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

Hi Ivo,

>>> On 6/14/2011 at 2:59 PM, Ivo Libal <[email protected]> wrote:
> Would there be a way how to do the CPU limitation on Linux level?
> Is there a way how to reserve some resources only for daemons or root
> processes?

You can look into Ch 10 Kernel Control Groups (cgroups) : http://www.novell.com/documentation/sles11/pdfdoc/book_sle_tuning/book_sle_tuning.pdf 

Arun

> Ivo
> 
> 
> Dne 14.6.2011 16:59, Martin Berg napsal(a):
>> 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-d 
> atabase-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 
> _______________________________________________
> 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