Very large resident memory size oracle-processes.

From: Andre.van.Benthem@achmea.nl
Date: Fri Aug 09 2002 - 07:18:44 EDT


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.
************************************************************



This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:48:49 EDT