Dear managers,
I noticed that most oracle-processes are using excessive resident memory.
Below some processes: ( tru64 5.1A PK2 / oracle 8.1.7.3)
# ps auxw | egrep 'RSS|oracle'
USER        PID %CPU %MEM   VSZ  RSS TTY      S    STARTED         TIME COMMAND
oracle   389837  0.0 17.1 1.09G 349M ??       S      Aug 03     1:56.19 ora_snpv
_pvfbqp
oracle   389828  0.0 23.0 1.08G 469M ??       S      Aug 03     1:33.94 ora_snpt
_pvfbqp
oracle   389824  0.0 10.1 1.08G 207M ??       S      Aug 03     1:20.46 ora_snpp
In total there are 46 oracle processes using on average 300MB resident
memory.
The total resident memory is about 13GB on a system with 2.0GB physical
memory !
The system is performing normally.
Does anyone had similar experiences ?? and maybe a explanation ?
# vmstat -P
Total Physical Memory =  2048.00 M
                      =   262144 pages
Physical Memory Clusters:
start_pfn     end_pfn        type  size_pages / size_bytes
         0         877         pal         877 /    6.85M
       877      262135          os      261258 / 2041.08M
    262135      262144         pal           9 /   72.00k
Physical Memory Use:
 start_pfn     end_pfn        type  size_pages / size_bytes
       877        1056    scavenge         179 /    1.40M
      1056        1854        text         798 /    6.23M
      1854        2001        data         147 /    1.15M
      2001        2217         bss         216 /    1.69M
      2217        2415      kdebug         198 /    1.55M
      2415        2421     cfgmgmt           6 /   48.00k
      2421        2423       locks           2 /   16.00k
      2423        2437        pmap          14 /  112.00k
      2437        3501   unixtable        1064 /    8.31M
      3501        3549        logs          48 /  384.00k
      3549        7655    vmtables        4106 /   32.08M
      7655      262135     managed      254480 / 1988.12M
                             ============================
         Total Physical Memory Use:     261258 / 2041.08M
Managed Pages Break Down:
       free pages = 4565
     active pages = 61739
   inactive pages = 131922
      wired pages = 29485
        ubc pages = 26947
        ==================
            Total = 254658
WIRED Pages Break Down:
   vm wired pages = 6132
  ubc wired pages = 26
  meta data pages = 2596
     malloc pages = 11595
     contig pages = 2649
    user ptepages = 6260
  kernel ptepages = 222
    free ptepages = 5
        ==================
            Total = 29485
#
Regards A. van Benthem
********************* DISCLAIMER *********************
De informatie in dit e-mail bericht is uitsluitend
bestemd voor de geadresseerde. Verstrekking aan
en gebruik door anderen is niet toegestaan.
Door de electronische verzending van het bericht
kunnen er geen rechten worden ontleend aan de
informatie.
************************************************************
Received on Fri Aug 09 2002 - 11:19:09 NZST