4 Replies Latest reply on Mar 24, 2014 9:30 AM by fuechsin

    Oracle Server Swaps / Configuration Questions

    fuechsin

      Hi,

       

      I hope this is the right section for my question.

       

      First of all, the circumstances:

      • SLES 10.3 x86_64  2.6.16.60-0.54.5-smp
      • total of 64GB RAM
      • 64 GB Swap
      • Oracle 10.2.0.4.0 Standard One Edition
      • SGA_MAX_SIZE=55GB
      • SGA_TARGET=45GB

       

      The problem is, that the server is swapping.

       

      Output of vmstat:

       

      rzvdb:/Daten/ORADUMP # vmstat -S M
      procs -----------memory---------- ---swap-- -----io---- -system-- -----cpu------
      r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa st
      7  0  33400    164      0  60116    0    0  2457   651   29   37 12  1 83  4  0
      
      

       

       

      Information about the sga:

       

      SQL> select * from v$sgainfo;
      
      NAME       BYTES RES
      -------------------------------- ---------- ---
      Fixed SGA Size     2283664 No
      Redo Buffers     2162688 No
      Buffer Cache Size  4,4158E+10 Yes
      Shared Pool Size  3808428032 Yes
      Large Pool Size     16777216 Yes
      Java Pool Size    50331648 Yes
      Streams Pool Size    33554432 Yes
      Granule Size    16777216 No
      Maximum SGA Size  5,4375E+10 No
      Startup overhead in Shared Pool   100663296 No
      Startup NUMA Shared Pool memory   402653184 No
      
      NAME       BYTES RES
      -------------------------------- ---------- ---
      Free SGA Memory Available  6291456000
      
      12 Zeilen ausgew�hlt.
      
      

       

      The Parameters:

       

      SQL> show parameters sga
      
      NAME      TYPE  VALUE
      ------------------------------------ ----------- ------------------------------
      lock_sga      boolean  FALSE
      pre_page_sga      boolean  FALSE
      sga_max_size      big integer 51856M
      sga_target      big integer 45856M
      
      

       

      sysctl.conf:

       

      SQL> show parameters sga
      
      NAME      TYPE  VALUE
      ------------------------------------ ----------- ------------------------------
      lock_sga      boolean  FALSE
      pre_page_sga      boolean  FALSE
      sga_max_size      big integer 51856M
      sga_target      big integer 45856M
      
      

       

       

      When the instance is shutting down no memory or swap was freed. After reboot the everything is ok. When I'm booting the instance everything looks finde to but when somebody works on the database it begins to swap. This is a productive system so it is not possible the reboot it to test paramters.

       

      On other system whith SLES11 and Oracle 11g there is no such behavior.

       

      I hope somebody has an idea or a tip what I can do.

       

      Kind regards Jessica