(888) 685-3101 ext. 2

Memory usage can be an issue for DB2 whether a server has 2 GB or 2 TB of memory. There can be issues with making DB2 use all of the memory, and there can be issues with DB2 causing paging or even kernel panics. Because of this, it is important to understand how much memory DB2 is using.

DB2’s Memory Model

There is a lot of good material on understanding the DB2 memory model. I suggest this developerWorks article as a great read on this: http://www.ibm.com/developerworks/data/library/techarticle/dm-0406qi/

There are basically three types of memory areas – ones that are allocated at the instance level, ones that are allocated at the database level, and ones that are allocated at the application level.

Instance level memory areas include:

  • AUDIT_BUF_SZ
  • MON_HEAP_SZ
  • FCM areas

Database level memory areas include:

Application level memory areas include:

  • APPLHEAPSZ
  • STMTHEAP
  • STAT_HEAP_SZ
  • Private Sort Heaps (SHEAPTHRES and SORTHEAP)
  • AGENT_STACK_SZ
  • ASLHEAPSZ
  • RQRIOBLK

Why there is no exact way to say “DB2 should be using X memory at any given time”?

There are two big reasons you cannot just add up parameters as configured in DBM and DB configurations and say exactly how much memory DB2 should be using at any one time.

  1. Some memory areas are allocated only as applications connect or agents are started up, and the number of connected applications can change from second to second.
  2. Different memory is allocated at different times and in different amounts. Some areas are allocated in full on instance start or database activation or application connection. Some areas start at a minimum size and are incremented by db2 up to a configured maximum

If you work really hard at it, you can come up with an accurate range of memory allocation that DB2 should fall into at any given time based on your configuration settings, but estimating an exact number accurately is very difficult, especially for a live system with a variable number of end users.

How Much Memory is DB2 Using Right Now

For the most part, I will leave looking at DB2 memory from the OS side to SAs and when needed, googling. I have used top before on linux/UNIX, but it just reports one (generally large) number for all of DB2. That is not terribly helpful. The main situation I have used it in was when someone was using it and called me and said “What is this db2sysc that is using over 50% of the memory?”, and I had to compare it back to what memory DB2 thought it was using.

top

top looks something like this:

$ top
top - 14:47:43 up 316 days,  3:57,  1 user,  load average: 0.04, 0.02, 0.00
Tasks: 274 total,   1 running, 273 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.2%us,  0.3%sy,  0.0%ni, 99.5%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:  65968876k total, 65464000k used,   504876k free,     8036k buffers
Swap:  2097144k total,   140632k used,  1956512k free, 62781652k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                                                                         
23675 db2inst   20   0 15176 1460  992 R  0.7  0.0   0:00.25 top    
30951 db2inst   20   0 38.0g  12g  12g S  0.7 20.1 669:37.28 db2sysc                                                                                                                                         
27935 db2ins2   20   0 9656m 2.7g 2.5g S  0.3  4.3 491:19.14 db2sysc
                       


The nice thing about top is that it does show changes over time, but it can also consume system resources.

db2mtrk

I have found db2mtrk as a reliable method, though use of SQL later in this article is my favorite method. db2mtrk is used like this:

$ db2mtrk -i
Tracking Memory on: 2015/12/08 at 14:46:48

Memory for instance

   other       fcmbp       monh        
   60.2M       8.8M        128.0K         

$ db2mtrk -d
Tracking Memory on: 2015/12/08 at 14:46:18

Memory for database: SAMPLE  

   utilh       pckcacheh   other       catcacheh   bph (5)     bph (4)     
   3.0M        256.0K      192.0K      192.0K      7.1M        17.9M       

   bph (3)     bph (2)     bph (1)     bph (S32K)  bph (S16K)  bph (S8K)   
   306.1M      10.8G       224.1M      1.8M        1.5M        1.4M        

   bph (S4K)   shsorth     lockh       dbh         apph (55736)appshrh     
   1.3M        0           409.8M      339.6M      64.0K       192.0K      
       

Adding up all of these numbers will give you a pretty accurate number as far as total memory usage. There are a few other useful option on db2mtrk – “db2mtrk -h” provides both a usage diagram and meanings of the abbreviations used for the various heaps.

db2top

I am a big fan of db2top for watching a database in real time. The memory screen can be useful here, and shows similar memory areas:
Screenshot_120815_040801_PM

Notice in the very middle at the bottom, it gives a total number that matches up well with the other methods described here.

db2pd

db2pd also lets us look at these memory areas in detail:

$ db2pd -mempools

Database Member 0 -- Active -- Up 102 days 03:17:37 -- Date 2015-12-08-15.04.07.335241

Memory Pools:
Address            MemSet   PoolName   Id    SecondId    Overhead   LogSz       LogHWM      PhySz       PhyHWM      CfgSize     Bnd BlkCnt CfgParm   
0x000000020002C458 DBMS     fcm        74    0           0          0           0           0           0           786432      No  0      n/a       
0x0000000200029570 DBMS     fcmsess    77    0           65376      1658592     1658592     1835008     1835008     1835008     No  3      n/a       
0x0000000200026688 DBMS     fcmchan    79    0           97984      9137152     10437632    9240576     10551296    9240576     No  7      n/a       
0x00000002000237A0 DBMS     fcmbp      13    0           97984      12156928    21069824    12713984    22740992    12713984    No  9      n/a       
0x00000002000208B8 DBMS     fcmctl     73    0           188224     2355069     2355069     2555904     2555904     2555904     No  86     n/a       
0x000000020001AAE8 DBMS     monh       11    0           122496     946466      1690259     1179648     1835008     393216      No  231    MON_HEAP_SZ
0x0000000200017C00 DBMS     resynch    62    0           32576      2457720     2457720     2555904     2555904     2752512     No  2      n/a       
0x0000000200014D18 DBMS     ostrack    57    0           42592      416240      416240      524288      524288      524288      No  3      n/a       
0x0000000200011E30 DBMS     apmh       70    0           0          8470284     54638244    27525120    56098816    16449536    No  247    n/a       
0x000000020000EF48 DBMS     kerh       52    0           50912      30592339    80487819    35913728    85524480    32440320    No  1346   n/a       
0x000000020000C060 DBMS     bsuh       71    0           38784      6380590     10081774    7012352     11075584    29687808    No  304    n/a       
0x0000000200009178 DBMS     sqlch      50    0           0          2758797     2772642     2818048     2818048     2818048     No  206    n/a       
0x0000000200006290 DBMS     djh        83    0           0          32          32          65536       65536       65536       No  1      n/a       
0x00000002000033A8 DBMS     krcbh      69    0           0          6489088     6489728     6553600     6553600     6553600     No  20     n/a       
0x00000002000004C0 DBMS     eduah      72    0           65344      8192024     8192024     8257536     8257536     8257536     No  1      n/a       
0x00000002100004C0 FMP      undefh     59    0           48000      737400      737400      786432      786432      23003136    No  6      n/a       
$ db2pd -db SAMPLE -mempools

Database Member 0 -- Database SAMPLE -- Active -- Up 102 days 03:12:21 -- Date 2015-12-08-15.04.24.616338

Memory Pools:
Address            MemSet   PoolName   Id    SecondId    Overhead   LogSz       LogHWM      PhySz       PhyHWM      CfgSize     Bnd BlkCnt CfgParm   
0x00007F8F0AD05E00 SAMPLE   utilh      5     0           0          243935524   3025246886  357367808   3381460992  8192000000  No  24377  UTIL_HEAP_SZ
0x00007F8F0AD00030 SAMPLE   pckcacheh  7     0           3516288    79682028    134150417   84213760    215154688   134217728   No  22069  PCKCACHESZ
0x00007F8F0773BBD0 SAMPLE   xmlcacheh  93    0           50880      145552      145552      196608      196608      2097152     No  1      n/a       
0x00007F8F07738CE8 SAMPLE   catcacheh  8     0           52736      2034314     4320328     4784128     5439488     2097152     No  1696   CATALOGCACHE_SZ
0x00007F8F07730030 SAMPLE   bph        16    5           65376      6958976     22417280    7733248     23330816    7733248     No  50     n/a       
0x00007F8A59025110 SAMPLE   bph        16    4           65376      18432384    18432384    19005440    19005440    19005440    No  136    n/a       
0x00007F8A5901F340 SAMPLE   bph        16    3           196128     321224832   427188352   321781760   428212224   321781760   No  2411   n/a       
0x00007F8A59019570 SAMPLE   bph        16    2           1895904    11649531264 11649531264 11654594560 11654594560 11654594560 No  88156  n/a       
0x00007F8A590137A0 SAMPLE   bph        16    1           1634400    241902208   8375713408  243859456   8379629568  243859456   No  1802   n/a       
0x00007F8A5900D9D0 SAMPLE   bph        16    4099        0          784768      784768      1835008     1835008     1835008     No  5      n/a       
0x00007F8A59007C00 SAMPLE   bph        16    4098        0          522624      522624      1572864     1572864     1572864     No  3      n/a       
0x00007F8A59001E30 SAMPLE   bph        16    4097        0          391552      391552      1441792     1441792     1441792     No  2      n/a       
0x00007F8A58FFC060 SAMPLE   bph        16    4096        0          326016      326016      1376256     1376256     1376256     No  2      n/a       
0x00007F8A58FF6290 SAMPLE   shsorth    18    0           0          12104       238675897278 2359296     10315825152 13926400000 No  18     SHEAPTHRES_SHR
0x00007F8A58FF33A8 SAMPLE   lockh      4     0           0          483436032   1585489408  483459072   1585512448  429654016   No  1      LOCKLIST  
0x00007F8A58FF04C0 SAMPLE   dbh        2     0           14101824   2616346134  2620041663  2725511168  2732654592  1215299584  No  994735 DBHEAP    
0x00007F92DB9B5E00 Appl     apph       1     5081        0          21658       90478       131072      131072      1048576     No  45     APPLHEAPSZ
0x00007F8972810030 Appl     apph       1     5080        0          18342       95696       131072      131072      1048576     No  30     APPLHEAPSZ
0x00007F887A240030 Appl     apph       1     5075        5185920    52847994    105103963   72286208    134610944   1048576     No  2836   APPLHEAPSZ
0x00007F92D7E40030 Appl     apph       1     4777        0          19887       88459       131072      131072      1048576     No  35     APPLHEAPSZ
0x00007F8972445E00 Appl     apph       1     4593        0          25632       56332       65536       65536       1048576     No  48     APPLHEAPSZ
0x00007F92D6B15E00 Appl     apph       1     4578        0          25632       56332       65536       65536       1048576     No  48     APPLHEAPSZ
0x00007F889C702F18 Appl     apph       1     4585        0          25632       56332       65536       65536       1048576     No  48     APPLHEAPSZ
0x00007F88FA7A0030 Appl     apph       1     4588        0          25632       56332       65536       65536       1048576     No  48     APPLHEAPSZ
0x00007F92D6705E00 Appl     apph       1     4589        0          25632       56332       65536       65536       1048576     No  48     APPLHEAPSZ
0x00007F92D3482F18 Appl     apph       1     4586        0          25632       56332       65536       65536       1048576     No  48     APPLHEAPSZ
0x00007F889A888CE8 Appl     apph       1     4569        0          27518       3782694     131072      5308416     1048576     No  65     APPLHEAPSZ
0x00007F896AA5BBD0 Appl     apph       1     3150        0          25199       268897      131072      327680      1048576     No  49     APPLHEAPSZ
0x00007F89204F0030 Appl     apph       1     3141        0          25199       259721      196608      327680      1048576     No  49     APPLHEAPSZ
0x00007F88C38A8CE8 Appl     apph       1     3145        0          25199       259721      131072      327680      1048576     No  49     APPLHEAPSZ
0x00007F887A375E00 Appl     apph       1     3148        0          26864       261386      131072      327680      1048576     No  53     APPLHEAPSZ
0x00007F92D6E65E00 Appl     apph       1     3144        0          25199       259721      131072      327680      1048576     No  49     APPLHEAPSZ
0x00007F92DBD72F18 Appl     apph       1     3138        0          25199       259721      196608      327680      1048576     No  49     APPLHEAPSZ
0x00007F92DBED8CE8 Appl     apph       1     3151        0          25199       259721      196608      327680      1048576     No  49     APPLHEAPSZ
0x00007F8879390030 Appl     apph       1     3143        0          26864       276906      131072      327680      1048576     No  53     APPLHEAPSZ
0x00007F92D477BBD0 Appl     apph       1     2597        0          26625       2160937     196608      3407872     1048576     No  55     APPLHEAPSZ
0x00007F92D23833A8 Appl     apph       1     62188       0          21354       21263671    131072      26345472    1048576     No  51     APPLHEAPSZ
0x00007F88177B1BD0 Appl     apph       1     62171       259968     1025697     5905673     1966080     7995392     1048576     No  95     APPLHEAPSZ
0x00007F88C4745E00 Appl     apph       1     62168       0          17706       56385       65536       65536       1048576     No  28     APPLHEAPSZ
0x00007F88F709BBD0 Appl     apph       1     59836       0          28848       12700563    1179648     17432576    1048576     No  75     APPLHEAPSZ
0x00007F92D3B82F18 Appl     apph       1     58021       0          28308       46898498    1900544     57802752    1048576     No  77     APPLHEAPSZ
0x00007F88C17F0030 Appl     apph       1     58002       0          49166       854766145   38273024    1058340864  1048576     No  296    APPLHEAPSZ
0x00007F889E1F5E00 Appl     apph       1     58009       0          17670       56361       65536       65536       1048576     No  28     APPLHEAPSZ
0x00007F8920478CE8 Appl     apph       1     52149       0          27489       2836154     65536       4063232     1048576     No  56     APPLHEAPSZ
0x00007F92DB9B8CE8 Appl     apph       1     52109       0          28665       87970772    18415616    121438208   1048576     No  88     APPLHEAPSZ
0x00007F884CEEE030 Appl     apph       1     52110       0          17666       56357       65536       65536       1048576     No  28     APPLHEAPSZ
0x00007F92D2530030 Appl     apph       1     22          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D24E8CE8 Appl     apph       1     21          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D24E2F18 Appl     apph       1     20          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D24BBBD0 Appl     apph       1     19          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D24B5E00 Appl     apph       1     18          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D24B0030 Appl     apph       1     17          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D23B5110 Appl     apph       1     16          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D23AF340 Appl     apph       1     15          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D23A9570 Appl     apph       1     14          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D23A37A0 Appl     apph       1     13          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D239D9D0 Appl     apph       1     12          0          99179       99683       196608      196608      1048576     No  1046   APPLHEAPSZ
0x00007F92D2397C00 Appl     apph       1     11          0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D2391E30 Appl     apph       1     10          0          17259       19243       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D238C060 Appl     apph       1     9           0          17259       17259       65536       65536       1048576     No  22     APPLHEAPSZ
0x00007F92D23804C0 Appl     appshrh    20    0           711232     59805264    175920784   94109696    232128512   81920000    No  9639   application shared

There are interesting looking columns here for things like high water marks and upper bounds.

For a slightly different way of looking at it, you can also look at it from a memory sets point of view with db2pd:

$ db2pd -memsets

Database Member 0 -- Active -- Up 102 days 03:16:08 -- Date 2015-12-08-15.02.38.106896

Memory Sets:
Name         Address            Id          Size(Kb)   Key         DBP    Type   Unrsv(Kb)  Used(Kb)   HWM(Kb)    Cmt(Kb)    Uncmt(Kb)  CmtRt(Kb)  DcmtRt(Kb) HoldRt(Kb) Sngl      
DBMS         0x0000000200000000 737902602   226624     0xC7CCFD61  0      0      88064      116288     207616     150976     75648      1024       17152      0          422       
  Seg0       0x00007F88FF350000 1603960854  0          0x0         0      0      0          0          0          0          0          0          0          0          0         
FMP          0x0000000210000000 737935371   22784      0x0         0      0      2          0          1024       22784      0          21760      0          0          0         
Trace        0x0000000000000000 737869831   33355      0xC7CCFD74  0      -1     0          33355      0          33355      0          0          0          0          0         
PRIVATE      0x00007F932E48C000 0           357312     0x0         0      9      0          357312     546368     0          0          0          0          0          0         
$ db2pd -db SAMPLE -memsets

Database Member 0 -- Database SAMPLE -- Active -- Up 102 days 03:10:43 -- Date 2015-12-08-15.02.46.877910

Memory Sets:
Name         Address            Id          Size(Kb)   Key         DBP    Type   Unrsv(Kb)  Used(Kb)   HWM(Kb)    Cmt(Kb)    Uncmt(Kb)  CmtRt(Kb)  DcmtRt(Kb) HoldRt(Kb) Sngl      
SAMPLE       0x00007F8A58FF0000 738164748   38796288   0x0         0      1      1958464    15672000   22441408   24046976   11493568   255168     11493568   808192     2244      
AppCtl       0x00007F92D2380000 738131977   352896     0x0         0      12     0          250944     2984896    349824     3072       1472       101184     0          110       
  Seg0       0x00007F8968000000 1066958865  0          0x0         0      12     0          0          0          0          0          0          0          0          0         
  Seg1       0x00007F8920000000 1580400656  0          0x0         0      12     0          0          0          0          0          0          0          0          0         
  Seg2       0x00007F88EE570000 1603993623  0          0x0         0      12     0          0          0          0          0          0          0          0          0         
  Seg3       0x00007F88BBE30000 1604026392  0          0x0         0      12     0          0          0          0          0          0          0          0          0         
  Seg4       0x00007F8899E50000 1604059161  0          0x0         0      12     0          0          0          0          0          0          0          0          0         
  Seg5       0x00007F8878F70000 1604091930  0          0x0         0      12     0          0          0          0          0          0          0          0          0         
  Seg6       0x00007F8856A8E000 2122252308  0          0x0         0      12     0          0          0          0          0          0          0          0          0         
  Seg7       0x00007F8846A8E000 2122285077  0          0x0         0      12     0          0          0          0          0          0          0          0          0         
  Seg8       0x00007F8810D16000 64487442    0          0x0         0      12     0          0          0          0          0          0          0          0          0         
  Seg9       0x00007F87DD676000 64520211    0          0x0         0      12     0          0          0          0          0          0          0          0          0         
  Seg10      0x00007F87BB7C6000 64552987    0          0x0         0      12     0          0          0          0          0          0          0          0          0         
App5080      n/a                719421468   128        0x0         0      4      0          128        0          128        0          0          0          0          0         

SQL and MON_GET_*

The MON_GET table functions allow the same information to be returned by query. They will work in DB2 9.7 and up, though these examples are from DB2 10.5. MON_GET_MEMORY_SETS and MON_GET_MEMkORY_POOLS should correspond to the db2pd way of looking at things. This is the first method presented that requires a database connection to work.

select substr(HOST_NAME,1,25) as HOST_NAME
	, substr(DB_NAME,1,10) as DBNAME
	, MEMORY_SET_TYPE
	, MEMORY_SET_ID
	, MEMORY_SET_SIZE
	, MEMORY_SET_COMMITTED
	, MEMORY_SET_USED
	, MEMORY_SET_USED_HWM 
from table(MON_GET_MEMORY_SET(null,null,-2)) as t 
with ur

HOST_NAME                 DBNAME     MEMORY_SET_TYPE                  MEMORY_SET_ID        MEMORY_SET_SIZE      MEMORY_SET_COMMITTED MEMORY_SET_USED      MEMORY_SET_USED_HWM 
------------------------- ---------- -------------------------------- -------------------- -------------------- -------------------- -------------------- --------------------
xxxxxxxxxxxx              -          DBMS                                                0               226624               150976               116224               207616
xxxxxxxxxxxx              -          FMP                                                 2                22784                22784                 1024                 1024
xxxxxxxxxxxx              -          PRIVATE                                             9               356672               356672               183360               525824
xxxxxxxxxxxx              SAMPLE     DATABASE                                            1             38796288             24046976             15672000             22441408
xxxxxxxxxxxx              SAMPLE     APPLICATION                                        12               291200               291200               176320              2984896

  5 record(s) selected.

select substr(HOST_NAME,1,25) as HOST_NAME
	, substr(DB_NAME,1,10) as DBNAME
	, MEMORY_SET_TYPE
	, MEMORY_POOL_TYPE
	, MEMORY_POOL_ID
	, APPLICATION_HANDLE
	, EDU_ID
	, MEMORY_POOL_USED
	, MEMORY_POOL_USED_HWM 
from table(MON_GET_MEMORY_POOL(null,null,-2)) as t 
with ur

HOST_NAME                 DBNAME     MEMORY_SET_TYPE                  MEMORY_POOL_TYPE                 MEMORY_POOL_ID       APPLICATION_HANDLE   EDU_ID               MEMORY_POOL_USED     MEMORY_POOL_USED_HWM
------------------------- ---------- -------------------------------- -------------------------------- -------------------- -------------------- -------------------- -------------------- --------------------
xxxxxxxxxxxx              -          DBMS                             FCM_LOCAL                                          74                    -                    -                    0                    0
xxxxxxxxxxxx              -          DBMS                             FCM_SESSION                                        77                    -                    -                 1792                 1792
xxxxxxxxxxxx              -          DBMS                             FCM_CHANNEL                                        79                    -                    -                 9024                10304
xxxxxxxxxxxx              -          DBMS                             FCMBP                                              13                    -                    -                12416                22208
xxxxxxxxxxxx              -          DBMS                             FCM_CONTROL                                        73                    -                    -                 2496                 2496
xxxxxxxxxxxx              -          DBMS                             MONITOR                                            11                    -                    -                 1152                 1792
xxxxxxxxxxxx              -          DBMS                             RESYNC                                             62                    -                    -                 2496                 2496
xxxxxxxxxxxx              -          DBMS                             OSS_TRACKER                                        57                    -                    -                  512                  512
xxxxxxxxxxxx              -          DBMS                             APM                                                70                    -                    -                26880                54784
xxxxxxxxxxxx              -          DBMS                             KERNEL                                             52                    -                    -                35072                83520
xxxxxxxxxxxx              -          DBMS                             BSU                                                71                    -                    -                 6784                10816
xxxxxxxxxxxx              -          DBMS                             SQL_COMPILER                                       50                    -                    -                 2752                 2752
xxxxxxxxxxxx              -          DBMS                             FEDERATED                                          83                    -                    -                   64                   64
xxxxxxxxxxxx              -          DBMS                             KERNEL_CONTROL                                     69                    -                    -                 6400                 6400
xxxxxxxxxxxx              -          DBMS                             EDU                                                72                    -                    -                 8064                 8064
xxxxxxxxxxxx              -          FMP                              MISC                                               59                    -                    -                  768                  768
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                22064                   64                  128
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53098                  384                  384
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                47472                  960                 5120
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58335                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58334                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58332                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58327                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58326                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58323                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58322                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58320                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58317                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58312                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58311                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58310                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58307                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58304                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58302                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58300                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58297                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58296                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58295                  192                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58291                  512                 4416
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58290                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58289                  768                  768
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58288                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58287                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58285                  192                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58284                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58283                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58275                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58273                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58270                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58266                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58262                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58261                  640                 4608
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58260                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58259                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58258                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58257                  704                  704
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58256                  768                 4800
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58255                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58254                  192                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58253                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58252                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58251                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58247                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58246                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58245                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58244                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58243                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58241                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58239                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58238                  192                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58237                  192                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                58234                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                18258                  832                 5056
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53113                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53105                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53103                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53101                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53099                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53096                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53095                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53094                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53093                 1024                 1920
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53066                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53025                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                53009                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52993                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52937                 1024                 4864
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52914                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52904                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52902                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52885                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52882                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52880                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52857                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52846                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52829                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52824                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52821                  448                 2560
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52816                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52810                  896                 5184
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52795                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52780                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52778                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52758                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52755                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                52748                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                47441                  768                 5120
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                49161                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                49130                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                49070                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                46086                 1216                 5248
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                46107                 1088                 5184
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                47475                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                47437                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                46169                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                46154                  576                  896
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                46122                  896                89408
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                46051                  320                  512
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                46033                  704                  704
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                46024                  640                12096
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                45987                  960               177536
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                45979                  448                  960
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                45970                  640                 1152
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                32647                  832                 5184
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                38180                  704                 4608
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                38167                 1216                 5440
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                37957                  704                 5056
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                24617                  640                 4800
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                29908                  448                 4544
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                26134                  960                 4928
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                18277                 1088                 4992
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                16912                  512                  832
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                37492                  960                 5184
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                33989                  896                 4992
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                  506                  512                 5120
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   68                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   67                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   66                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   65                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   64                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   63                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   62                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   61                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   60                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   59                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   58                  576                  576
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   57                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   56                  192                  192
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   55                  384                  384
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   54                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   53                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   52                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   51                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   50                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   49                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   48                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   47                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   46                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   45                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   44                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   43                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   42                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   41                  256                  256
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   40                  256                  320
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   39                  256                  320
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   38                  256                  320
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   37                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   36                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   35                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   34                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   33                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   32                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   31                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   30                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   29                    0                    0
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   28                    0                    0
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   27                   64                 2176
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   26                  384               131520
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   25                   64                 4288
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   24                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   21                    0                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   20                    0                    0
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   16                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                   13                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          PRIVATE                                            88                    -                    0                   64                   64
xxxxxxxxxxxx              -          PRIVATE                          USER_DATA                                          95                    -                    0                 7680               130304
xxxxxxxxxxxx              -          PRIVATE                          PERSISTENT_PRIVATE                                 86                    -                    0                94400               258304
xxxxxxxxxxxx              SAMPLE     DATABASE                         UTILITY                                             5                    -                    -               348992              3302208
xxxxxxxxxxxx              SAMPLE     DATABASE                         PACKAGE_CACHE                                       7                    -                    -                82240               210112
xxxxxxxxxxxx              SAMPLE     DATABASE                         XMLCACHE                                           93                    -                    -                  192                  192
xxxxxxxxxxxx              SAMPLE     DATABASE                         CAT_CACHE                                           8                    -                    -                 4672                 5312
xxxxxxxxxxxx              SAMPLE     DATABASE                         BP                                                 16                    -                    -                 7552                22784
xxxxxxxxxxxx              SAMPLE     DATABASE                         BP                                                 16                    -                    -                18560                18560
xxxxxxxxxxxx              SAMPLE     DATABASE                         BP                                                 16                    -                    -               314240               418176
xxxxxxxxxxxx              SAMPLE     DATABASE                         BP                                                 16                    -                    -             11381440             11381440
xxxxxxxxxxxx              SAMPLE     DATABASE                         BP                                                 16                    -                    -               238144              8183232
xxxxxxxxxxxx              SAMPLE     DATABASE                         BP                                                 16                    -                    -                 1792                 1792
xxxxxxxxxxxx              SAMPLE     DATABASE                         BP                                                 16                    -                    -                 1536                 1536
xxxxxxxxxxxx              SAMPLE     DATABASE                         BP                                                 16                    -                    -                 1408                 1408
xxxxxxxxxxxx              SAMPLE     DATABASE                         BP                                                 16                    -                    -                 1344                 1344
xxxxxxxxxxxx              SAMPLE     DATABASE                         SHARED_SORT                                        18                    -                    -                 2304             10074048
xxxxxxxxxxxx              SAMPLE     DATABASE                         LOCK_MGR                                            4                    -                    -               472128              1548352
xxxxxxxxxxxx              SAMPLE     DATABASE                         DATABASE                                            2                    -                    -              2661632              2668608
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 5093                    -                36480                59200
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 5080                    -                  128                  128
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 4777                    -                  128                  128
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 4593                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 4578                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 4585                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 4588                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 4589                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 4586                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 4569                    -                  128                 5184
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 3150                    -                  128                  320
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 3141                    -                  192                  320
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 3145                    -                  128                  320
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 3148                    -                  128                  320
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 3144                    -                  128                  320
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 3138                    -                  192                  320
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 3151                    -                  192                  320
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 3143                    -                  128                  320
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                 2597                    -                  192                 3328
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                62188                    -                  128                25728
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                62171                    -                 1920                 7808
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                62168                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                59836                    -                 1152                17024
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                58021                    -                 1856                56448
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                58002                    -                37376              1033536
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                58009                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                52149                    -                   64                 3968
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                52109                    -                17984               118592
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                52110                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   22                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   21                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   20                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   19                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   18                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   17                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   16                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   15                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   14                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   13                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   12                    -                  192                  192
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   11                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                   10                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPLICATION                                         1                    9                    -                   64                   64
xxxxxxxxxxxx              SAMPLE     APPLICATION                      APPL_SHARED                                        20                    -                    -                91776               226688

  247 record(s) selected.

Now that is pretty long, but think of the potential for easy addition and averaging and such.

I think you are going to get the best possible answer to “how much memory is DB2 using” from DB2’s perspective by using:

$ db2 "select SUM(MEMORY_POOL_USED) as TOT_MEMORY_USED from table(MON_GET_MEMORY_POOL(null,null,-2)) as t with ur"
TOT_MEMORY_USED     
--------------------
            16013824

  1 record(s) selected.

Share This