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

Looks as you run out of memory and so have a swap (esp if you use huge pages which are not swappable).

Recommendations are common
 - separate serevrs if possible
- set up both JBoss and Oracle so that they do not compete for the memory 
- profile system using - iostat, vmstat, then moe complicated profilers.

You can send the output of vmstat 5 and iostat -x 5 during this highh load here, so we can look.


  ----- Original Message ----- 
  From: Gilberto 
  To: [email protected] 
  Sent: Tuesday, June 14, 2011 11:34 AM
  Subject: Re: [suse-oracle] Linux system overloaded by oracle and notresponding


  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