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

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