Virtual Memory Consumption / Paging under AIX 7.1 (Doc ID 1666458.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.1 [Release 11.2 to 12.1]
IBM AIX on POWER Systems (64-bit)

Symptoms

After an upgrade from AIX 5.3 to AIX 7.1, an increase of virtual memory consumption and paging activity is noticed.

All the points were checked as mentioned in
<Note 1599824.1> - AIX: ORA-4030 Error or High Swap Usage

Moreover, the system has installed IBM interim patch "IV21116m04" that must be present in the system and numperm_global kernel system parameter is set to 0.
Depending on the system, the consumption of virtual memory could be around 1GB per day.

To monitor the system, next commands can be used:


The output for svmon shows that the increase of memory always under clnt text data BSS heap and this heap is growing, e.g.:

****svmon -P 46923876

-------------------------------------------------------------------------------
     Pid Command          Inuse      Pin     Pgsp  Virtual 64-bit Mthrd  16MB
46923876 oracle          717155   538496        0   647214      Y     N     Y

     PageSize                Inuse        Pin       Pgsp    Virtual
     s    4 KB               82227          0          0      12286
     m   64 KB                6659        632          0       6659
     L   16 MB                 129        129          0        129
     S   16 GB                   0          0          0          0

    Vsid      Esid Type Description              PSize  Inuse   Pin Pgsp Virtual
  8b0d4b        10 clnt text data BSS heap,          s  69593     0    -       -
                        /dev/lvora112030:127361                                
  822c01  7000000a work default shmat/mmap           L     16    16    0      16
  bb2338  70000009 work default shmat/mmap           L     16    16    0      16
  b741b7  70000005 work default shmat/mmap           L     16    16    0      16
  93fb10  70000008 work default shmat/mmap           L     16    16    0      16
  b022b0  70000007 work default shmat/mmap           L     16    16    0      16
  b00bb4  70000006 work default shmat/mmap           L     16    16    0      16
  990e59  70000004 work default shmat/mmap           L     16    16    0      16
  ac02af  7000000b work default shmat/mmap           L     15    15    0      15
  9b001b  90000000 work shared library text          m   2746     0    0    2746
  ae062e  90000001 work shared library text          m   2704     0    0    2704
   20002         0 work kernel segment               m    683   629    0     683
  8e1a0e  90000002 work shared library text          m    521     0    0     521
  9d001d  90020014 work shared library               s   6264     0    0    6264
  a01724  7000000c work default shmat/mmap           L      1     1    0       1
  9e0d9a  70000000 work default shmat/mmap           L      1     1    0       1
   50005  9ffffffd work shared library              sm   3246     0    0    3246
  b6f675        11 work text data BSS heap          sm   2507     0    0    2507
  b721b7         - pers /dev/lvgesta:625034          s    314     0    -       -
  a51ba7  9001000a work shared library data         sm    128     0    0     128
   e000e  9ffffffe work shared library              sm     87     0    0      87
  b0f633 f00000002 work process private              m      5     3    0       5
  a9062d  80020014 work USLA heap                   sm     24     0    0      24
  850185  9fffffff clnt USLA text,/dev/hd2:4160      s     20     0    -       -
  b60a32  ffffffff work application stack           sm     19     0    0      19
  aa0fea         - clnt /dev/lvora112030:127212      s     10     0    -       -
  b26ff2  8fffffff work private load data            s      8     0    0       8
  9d575d  8001000a work private load data           sm      3     0    0       3
  9406d4         - clnt /dev/hd2:84982               s      2     0    -       -
  8a0cca         - clnt /dev/lvora112030:127232      s      1     0    -       -
  990bd9         - clnt /dev/lvora112030:41195       s      1     0    -       -
  93dc10  a0000000 mmap maps 1 source(s)            sm      0     0    -       -
Fin captura: 20140423_063001 
**********************************************************************************************

 

Changes

Upgrade to AIX 7100-03.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms