Re: anothere Oracle memory question

andrew_webby at [/i]
[B]Here's a program summem.sh I found at Oracle some time back. Who knows whether it's still current,
but there's some good tips inside on what to consider shared (read/exec appears to be considered shared, read/write/exec looks 'private').

Anyway, see attachment.

"Robert Yeh" <robert.yeh_at_qwest.com> wrote in message [url="news:9g8e0c$cl0$1_at_bob.news.rcn.net"]news:9g8e0c$cl0$1_at_bob.news.rcn.net[/url]...
[size=1]  [i][color="{usenetquotecolor}"]> I am trying to calculate the client connection memory using pmap. The[/color][/i][/size]
total
[size=1]  [i][color="{usenetquotecolor}"]> is 31272K bytes. I guess I need to deduct the shared memory (line 4,[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 12747K). Does it man this client is using 18465K (31272K-12744K) memory? That is a lot of memory[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> for one client. How about line 1 and 2(16264K and[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 128K)? Are they considered shared memory also?[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]>[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]>[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]>[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> qcdev1:/home/oracle> /usr/proc/bin/pmap 20213[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 20213: oracleqc_d (LOCAL=NO) 00010000 16264K read/exec /opt/Oracle/product/8.0.5/bin/oracle[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 01000000 128K read/write/exec /opt/Oracle/product/8.0.5/bin/oracle 01020000 384K[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> read/write/exec [ heap ] 80000000 12744K read/write/exec/shared [ shmid=0x67 ] FF130000[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 16K read/exec /usr/lib/libmp.so.2 FF142000 8K read/write/exec /usr/lib/libmp.so.2 FF150000[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 88K read/exec /usr/lib/libm.so.1 FF174000 8K read/write/exec /usr/lib/libm.so.1 FF180000[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 664K read/exec /usr/lib/libc.so.1 FF234000 32K read/write/exec /usr/lib/libc.so.1 FF23C000[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 8K read/write/exec [ anon ] FF260000 32K read/exec /usr/lib/libaio.so.1 FF276000 8K[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> read/write/exec /usr/lib/libaio.so.1 FF280000 520K read/exec /usr/lib/libnsl.so.1 FF310000[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 40K read/write/exec /usr/lib/libnsl.so.1 FF31A000 32K read/write/exec [ anon ] FF330000[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 16K read/exec /usr/platform/sun4u/lib/libc_psr.so.1 FF350000 8K read/write/exec [ anon ][/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> FF360000 24K read/exec /usr/lib/libgen.so.1 FF374000 16K read/write/exec[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> /usr/lib/libgen.so.1 FF380000 32K read/exec /usr/lib/libsocket.so.1 FF396000 16K[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> read/write/exec /usr/lib/libsocket.so.1 FF3A0000 8K read/exec /usr/lib/libdl.so.1 FF3B0000[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> 128K read/exec /usr/lib/ld.so.1 FF3DE000 16K read/write/exec /usr/lib/ld.so.1 FFBE8000 32K[/color][/i][/size]
[size=1]  [i][color="{usenetquotecolor}"]> read/write/exec [ stack ] total 31272K[/color] wrote:

Andrew:

I am interested in obtaining the summem.sh script. I checked MetaLinks and OTN and could not find it. Could I get a copy of the script. Thanks in advance.

• jeff

--
-------------------------------------
Jeffrey Hunter
Senior Database Administrator
WEB    - www.iDevelopment.info
EMAIL  - jhunter_at_iDevelopment.info
-------------------------------------

Posted via dBforums
http://dbforums.com