Re: anothere Oracle memory question

A copy of this was sent to "Robert Yeh" <robert.yeh_at_qwest.com> (if that email address didn't require changing) On Wed, 13 Jun 2001 15:18:20 -0400, you wrote:

>I am trying to calculate the client connection memory using pmap. The total
>is 31272K bytes. I guess I need to deduct the shared memory (line 4,
>12747K). Does it man this client is using 18465K (31272K-12744K) memory?
>That is a lot of memory for one client. How about line 1 and 2(16264K and
>128K)? Are they considered shared memory also?
>
>

see
http://www.ntua.gr/cgi-bin/man-cgi?pmap+1

use -x with pmap on 2.6 and up to get more info.

it'll break it out into:

Address   Kbytes Resident Shared Private Permissions       Mapped File
00010000   24704   17176   15032    2144 read/exec         oracle

private is close to what you are looking for but is still larger than. see also http://www.geocrawler.com/archives/3/182/1998/10/0/1062716/

>
>qcdev1:/home/oracle> /usr/proc/bin/pmap 20213
>20213: oracleqc_d (LOCAL=NO)
>00010000 16264K read/exec /opt/Oracle/product/8.0.5/bin/oracle
>01000000 128K read/write/exec /opt/Oracle/product/8.0.5/bin/oracle
>01020000 384K read/write/exec [ heap ]
>80000000 12744K read/write/exec/shared [ shmid=0x67 ]
>FF130000 16K read/exec /usr/lib/libmp.so.2
>FF142000 8K read/write/exec /usr/lib/libmp.so.2
>FF150000 88K read/exec /usr/lib/libm.so.1
>FF174000 8K read/write/exec /usr/lib/libm.so.1
>FF180000 664K read/exec /usr/lib/libc.so.1
>FF234000 32K read/write/exec /usr/lib/libc.so.1
>FF23C000 8K read/write/exec [ anon ]
>FF260000 32K read/exec /usr/lib/libaio.so.1
>FF276000 8K read/write/exec /usr/lib/libaio.so.1
>FF280000 520K read/exec /usr/lib/libnsl.so.1
>FF310000 40K read/write/exec /usr/lib/libnsl.so.1
>FF31A000 32K read/write/exec [ anon ]
>FF330000 16K read/exec /usr/platform/sun4u/lib/libc_psr.so.1
>FF350000 8K read/write/exec [ anon ]
>FF360000 24K read/exec /usr/lib/libgen.so.1
>FF374000 16K read/write/exec /usr/lib/libgen.so.1
>FF380000 32K read/exec /usr/lib/libsocket.so.1
>FF396000 16K read/write/exec /usr/lib/libsocket.so.1
>FF3A0000 8K read/exec /usr/lib/libdl.so.1
>FF3B0000 128K read/exec /usr/lib/ld.so.1
>FF3DE000 16K read/write/exec /usr/lib/ld.so.1
>FFBE8000 32K read/write/exec [ stack ]
> total 31272K
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/
Oracle Magazine: http://www.oracle.com/oramag

Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  

Opinions are mine and do not necessarily reflect those of Oracle Corp