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

You can use profiles[1].

Regards,

Gilberto

[1]
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/security.htm#sthref2740


On Tue, Jun 14, 2011 at 12:31 PM, Ivo Libal <[email protected]> wrote:

> 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]
> http://listx.novell.com/mailman/listinfo/suse-oracle
>

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