Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How many private memory does one single oracle server process allocate?

How many private memory does one single oracle server process allocate?

From: lsllcm <lsllcm_at_gmail.com>
Date: 23 Oct 2006 04:09:25 -0700
Message-ID: <1161601765.495422.224650@h48g2000cwc.googlegroups.com>


Hi All,

I have a question about how many private memory does one single oracle server process allocate? I read some articles, one oracle server process allocates about 2-3M per session. So I want to verify on local system (OS is ras 4.0 linux).

Here one oracle process pid is 25243, I look into /proc/25243/status
...

VmSize: 1008336 kB

VmLck:         0 kB
VmRSS:     11668 kB
VmData:     1600 kB
VmStk:        52 kB
VmExe:     37311 kB
VmLib:      4557 kB

StaBrk: 0ad6f000 kB
Brk: 0adb5000 kB
StaStk: bffff9b0 kB
...

We know one server process has shared memory, private memory, Could you tell me what parts are private memory?

Only VmData and VmStk are less than 2M!!!

When I run pmap command pmap -x 25243
The following are output:

25243: oraclepftest (LOCAL=NO)

Address   Kbytes     RSS    Anon  Locked Mode   Mapping
00940000      72       -       -       - r-x--  libnsl-2.3.4.so
00952000       8       -       -       - rw---  libnsl-2.3.4.so
00954000       8       -       -       - rw---    [ anon ]
00aea000      84       -       -       - r-x--  ld-2.3.4.so
00aff000       4       -       -       - r----  ld-2.3.4.so
00b00000       4       -       -       - rw---  ld-2.3.4.so
00b03000       4       -       -       - r-x--  libaio.so.1.0.0
00b04000       4       -       -       - rw---  libaio.so.1.0.0
00c57000       8       -       -       - r-x--  libdl-2.3.4.so
00c59000       8       -       -       - rw---  libdl-2.3.4.so
08048000   37312       -       -       - r-x--  oracle
0a4b8000    8804       -       -       - rw---  oracle
0ad51000     400       -       -       - rw---    [ anon ]
50000000  425984       -       -       - rw-s-    [ shmid=0x0 ]
6a000000       4       -       -       - r--s-    [ shmid=0x0 ]
6a001000    1156       -       -       - rw-s-    [ shmid=0x0 ]
6a122000       4       -       -       - r--s-    [ shmid=0x0 ]
6a123000    2932       -       -       - rw-s-    [ shmid=0x0 ]
978f9000     512       -       -       - rw---  zero
97979000     724       -       -       - rw---    [ anon ]
97a2e000      32       -       -       - rw-s-  orashm_32769
97a36000      32       -       -       - rw-s-  orashm_32769
97a3e000      32       -       -       - rw-s-  orashm_32769
97a46000      32       -       -       - rw-s-  orashm_32769
97a4e000      32       -       -       - rw-s-  orashm_32769
97a56000  524128       -       -       - rw-s-  orashm_32769
b7a2e000      36       -       -       - r-x--  libnss_files-2.3.4.so
b7a37000       8       -       -       - rw---  libnss_files-2.3.4.so
b7a39000     180       -       -       - rw---    [ anon ]
b7a66000    1160       -       -       - r-x--  libc-2.3.4.so
b7b88000       4       -       -       - r----  libc-2.3.4.so
b7b89000      12       -       -       - rw---  libc-2.3.4.so
b7b8c000       8       -       -       - rw---    [ anon ]
b7b8e000      56       -       -       - r-x--  libpthread-0.10.so
b7b9c000       8       -       -       - rw---  libpthread-0.10.so
b7b9e000     268       -       -       - rw---    [ anon ]
b7be1000     132       -       -       - r-x--  libm-2.3.4.so
b7c02000       8       -       -       - rw---  libm-2.3.4.so
b7c04000    2940       -       -       - r-x--  libjox9.so
b7ee3000    1088       -       -       - rw---  libjox9.so
b7ff3000       8       -       -       - rw---    [ anon ]
b7ff5000       4       -       -       - r-x--  libskgxn9.so
b7ff6000       8       -       -       - rw---  libskgxn9.so
b7ff8000       4       -       -       - r-x--  libskgxp9.so
b7ff9000       4       -       -       - -----  libskgxp9.so
b7ffa000       4       -       -       - rw---  libskgxp9.so
b7ffb000       4       -       -       - r-x--  libodmd9.so
b7ffc000       4       -       -       - rw---  libodmd9.so
b7ffd000       4       -       -       - r-x--  libcwait.so
b7ffe000       4       -       -       - rw---  libcwait.so
b7fff000       4       -       -       - rw---    [ anon ]
bfff3000      52       -       -       - rwx--    [ stack ]
ffffe000       4       -       -       - -----    [ anon ]
-------- ------- ------- ------- -------
total kB 1008340       -       -       -

Could you tell me what parts are private memory in these output?

Thanks in advance! Received on Mon Oct 23 2006 - 06:09:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US