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

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