RE: process memory utilization
I posted a similar question recently and whilst I received some answers I never did discover an exact way of matching oracle use of memory with unix use of memory. One issue is that when oracle releases memory the unix process does not automatically do the same until the memory is required. Therefore it is likely that there will always be a difference. Tim Gorman pointed me to a script oramem.sh (www.evdbt.com/tools.htm) which does what you are doing with a pmap function which is quite useful The discussion was around 4/10/02 and the thread title was "How much memory is an oracle shadow process using" John -Original Message- Sent: 03 December 2002 11:29 To: Multiple recipients of list ORACLE-L chao_ping, It seems i am posting a too long question, so nobody is interested. I post the answer to my second question, to check the memory utilization in linux operation system. It is in /proc/spid/status file. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.cnoug.org(Chinese Oracle User Group) === 2002-12-02 08:34:00 ,you wrote£º=== >Hi,dba friends: > I am thinking of measure how much memory per connection used, from the os viewpoint and oracle viewpoint. And this is my result from my production server, and i have some questions below. > > >23:56:28 SQL> select sum(value),sum(value)/count(distinct sid) average from v$sesstat where statistic#=15; --uga > > SUM(VALUE) AVERAGE > > 69,098,528 145,777 > >23:58:09 SQL>select sum(value),sum(value)/count(distinct sid),max(value) from v$sesstat where statistic#=20 --pga > > SUM(VALUE) SUM(VALUE)/COUNT(DISTINCTSID) MAX(VALUE) > - > 265,290,648559,684.9117,510,184 > > There is about my production server(oracle817+solaris7), and I also used pmap to trace some process and it look like: >oracle@main-db1$pmap 11443 #some process id i which is choosed randomly via /usr/ucb/ps -aux. >11443: oraclebiddb (LOCAL=NO) >0001 29440K read/exec /export/home/oracle/app/product/8.1.7/bin/oracle >000101DBE000464K read/write/exec /export/home/oracle/app/product/8.1.7/bin/oracle >000101E32000 1440K read/write/exec [ heap ] >00038000 5685720K read/write/exec/shared [ shmid=0x65 ] >7D80 16K read/exec /usr/lib/sparcv9/libmp.so.2 >7D902000 8K read/write/exec /usr/lib/sparcv9/libmp.so.2 >7DA0 88K read/exec /usr/lib/sparcv9/libm.so.1 >7DB14000 16K read/write/exec /usr/lib/sparcv9/libm.so.1 >7DC0 8K read/exec /usr/lib/sparcv9/libkstat.so.1 >7DD0 8K read/write/exec /usr/lib/sparcv9/libkstat.so.1 >7DE0 32K read/exec /usr/lib/sparcv9/librt.so.1 >7DF06000 8K read/write/exec /usr/lib/sparcv9/librt.so.1 >7E00 24K read/exec /usr/lib/sparcv9/libaio.so.1 >7E104000 16K read/write/exec /usr/lib/sparcv9/libaio.so.1 >7E20704K read/exec /usr/lib/sparcv9/libc.so.1 >7E3AE000 64K read/write/exec /usr/lib/sparcv9/libc.so.1 >7E3BE000 8K read/write/exec [ anon ] >7E40 8K read/exec /usr/lib/sparcv9/libsched.so.1 >7E50 8K read/write/exec /usr/lib/sparcv9/libsched.so.1 >7E60 32K read/exec /usr/lib/sparcv9/libgen.so.1 >7E706000 8K read/write/exec /usr/lib/sparcv9/libgen.so.1 >7E80 40K read/exec /usr/lib/sparcv9/libsocket.so.1 >7E908000 16K read/write/exec /usr/lib/sparcv9/libsocket.so.1 >7EA0624K read/exec /usr/lib/sparcv9/libnsl.so.1 >7EB9A000 64K read/write/exec /usr/lib/sparcv9/libnsl.so.1 >7EBAA000 32K read/write/exec [ anon ] >7EC0 3896K read/exec /export/home/oracle/app/product/8.1.7/lib/libjox8.so >7F0CC000192K read/write/exec /export/home/oracle/app/product/8.1.7/lib/libjox8.so >7F0FC000 8K read/write/exec [ anon ] >7F30 40K read/exec /export/home/oracle/app/product/8.1.7/lib64/libdsbtsh8.so >7F408000 8K read/write/exec /export/home/oracle/app/product/8.1.7/lib64/libdsbtsh8.so >7F40A000 8K read/write/exec [ anon ] >7F50 8K read/exec /export/home/oracle/app/product/8.1.7/lib64/libskgxp8.so >7F60 8K read/write/exec /export/home/oracle/app/product/8.1.7/lib64/libskgxp8.so >7F68128K read/exec /usr/lib/sparcv9/ld.so.1 >7F79 16K read/exec /usr/platform/sun4u/lib/sparcv9/libc_psr.so.1 >7F79E000 8K read/write/exec /usr/lib/sparcv9/ld.so.1 >7F7A 8K read/write/exec [ anon ] >7F7B 8K read/write/exec [ anon ] >7
Re: process memory utilization
chao_ping, It seems i am posting a too long question, so nobody is interested. I post the answer to my second question, to check the memory utilization in linux operation system. It is in /proc/spid/status file. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.cnoug.org(Chinese Oracle User Group) === 2002-12-02 08:34:00 ,you wrote£º=== >Hi,dba friends: > I am thinking of measure how much memory per connection used, from the os >viewpoint and oracle viewpoint. And this is my result from my production server, and >i have some questions below. > > >23:56:28 SQL> select sum(value),sum(value)/count(distinct sid) average from >v$sesstat where statistic#=15; --uga > > SUM(VALUE) AVERAGE > > 69,098,528 145,777 > >23:58:09 SQL>select sum(value),sum(value)/count(distinct sid),max(value) from >v$sesstat where statistic#=20 --pga > > SUM(VALUE) SUM(VALUE)/COUNT(DISTINCTSID) MAX(VALUE) > - > 265,290,648559,684.9117,510,184 > > There is about my production server(oracle817+solaris7), and I also used pmap >to trace some process and it look like: >oracle@main-db1$pmap 11443 #some process id i which is choosed randomly via >/usr/ucb/ps -aux. >11443: oraclebiddb (LOCAL=NO) >0001 29440K read/exec >/export/home/oracle/app/product/8.1.7/bin/oracle >000101DBE000464K read/write/exec >/export/home/oracle/app/product/8.1.7/bin/oracle >000101E32000 1440K read/write/exec [ heap ] >00038000 5685720K read/write/exec/shared [ shmid=0x65 ] >7D80 16K read/exec /usr/lib/sparcv9/libmp.so.2 >7D902000 8K read/write/exec /usr/lib/sparcv9/libmp.so.2 >7DA0 88K read/exec /usr/lib/sparcv9/libm.so.1 >7DB14000 16K read/write/exec /usr/lib/sparcv9/libm.so.1 >7DC0 8K read/exec /usr/lib/sparcv9/libkstat.so.1 >7DD0 8K read/write/exec /usr/lib/sparcv9/libkstat.so.1 >7DE0 32K read/exec /usr/lib/sparcv9/librt.so.1 >7DF06000 8K read/write/exec /usr/lib/sparcv9/librt.so.1 >7E00 24K read/exec /usr/lib/sparcv9/libaio.so.1 >7E104000 16K read/write/exec /usr/lib/sparcv9/libaio.so.1 >7E20704K read/exec /usr/lib/sparcv9/libc.so.1 >7E3AE000 64K read/write/exec /usr/lib/sparcv9/libc.so.1 >7E3BE000 8K read/write/exec [ anon ] >7E40 8K read/exec /usr/lib/sparcv9/libsched.so.1 >7E50 8K read/write/exec /usr/lib/sparcv9/libsched.so.1 >7E60 32K read/exec /usr/lib/sparcv9/libgen.so.1 >7E706000 8K read/write/exec /usr/lib/sparcv9/libgen.so.1 >7E80 40K read/exec /usr/lib/sparcv9/libsocket.so.1 >7E908000 16K read/write/exec /usr/lib/sparcv9/libsocket.so.1 >7EA0624K read/exec /usr/lib/sparcv9/libnsl.so.1 >7EB9A000 64K read/write/exec /usr/lib/sparcv9/libnsl.so.1 >7EBAA000 32K read/write/exec [ anon ] >7EC0 3896K read/exec >/export/home/oracle/app/product/8.1.7/lib/libjox8.so >7F0CC000192K read/write/exec >/export/home/oracle/app/product/8.1.7/lib/libjox8.so >7F0FC000 8K read/write/exec [ anon ] >7F30 40K read/exec >/export/home/oracle/app/product/8.1.7/lib64/libdsbtsh8.so >7F408000 8K read/write/exec >/export/home/oracle/app/product/8.1.7/lib64/libdsbtsh8.so >7F40A000 8K read/write/exec [ anon ] >7F50 8K read/exec >/export/home/oracle/app/product/8.1.7/lib64/libskgxp8.so >7F60 8K read/write/exec >/export/home/oracle/app/product/8.1.7/lib64/libskgxp8.so >7F68128K read/exec /usr/lib/sparcv9/ld.so.1 >7F79 16K read/exec >/usr/platform/sun4u/lib/sparcv9/libc_psr.so.1 >7F79E000 8K read/write/exec /usr/lib/sparcv9/ld.so.1 >7F7A 8K read/write/exec [ anon ] >7F7B 8K read/write/exec [ anon ] >7F7C 8K read/write/exec [ anon ] >7F7D 8K read/write/exec/shared [ anon ] >7F7E 8K read/write/exec [ anon ] >7F7F 8K read/exec /usr/lib/sparcv9/libdl.so.1 >7FFEE000 72K read/write [ stack ] > total 5723336K > >and i compared it with oracle statistics: >00:11:59 SQL> @whoisit >00:12:02 SQL> col machine format a30 >00:12:02 SQL> col program format a40 >00:12:02 SQL> set line 200 >00:12:02 SQL> select sid,serial# >,username,osuser,machine,program,process,to_char(logon_time,'/mm/dd hh24:mi:ss') >00:12:02 2 from v$ses