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

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?
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-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
_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle