| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: private memory used by oracle process in AIX ??
Small example:
pmap availavle by default on Solaris
$ /usr/proc/bin/pmap 28030
28030: ora_dbw0_GLJUK11
00010000 23392K read/exec /u01/app/oracle/product/816/bin/oracle 016F6000 216K read/write/exec /u01/app/oracle/product/816/bin/oracle 0172C000 1816K read/write/exec [ heap ] 80000000 9520K read/write/exec/shared [ shmid=0x803 ] EED80000 16K read/exec /usr/lib/libmp.so.2 EED92000 8K read/write/exec /usr/lib/libmp.so.2 EEDA0000 120K read/exec /usr/lib/libelf.so.1 EEDCC000 8K read/write/exec /usr/lib/libelf.so.1 EEDE0000 16K read/exec /usr/lib/libkvm.so.1 EEDF2000 16K read/write/exec /usr/lib/libkvm.so.1 EEE00000 600K read/exec /usr/lib/libc.so.1 EEEA4000 32K read/write/exec /usr/lib/libc.so.1 EEEAC000 8K read/write/exec [ anon ] EEED0000 88K read/exec /usr/lib/libm.so.1 EEEF4000 8K read/write/exec /usr/lib/libm.so.1 EEF00000 480K read/exec /usr/lib/libnsl.so.1 EEF86000 40K read/write/exec /usr/lib/libnsl.so.1 EEF90000 24K read/write/exec [ anon ] EEFA0000 8K read/exec /usr/lib/libkstat.so.1 EEFB0000 8K read/write/exec /usr/lib/libkstat.so.1 EEFC0000 24K read/exec /usr/lib/libposix4.so.1 EEFD4000 8K read/write/exec /usr/lib/libposix4.so.1 EEFE0000 24K read/exec /usr/lib/libaio.so.1 EEFF4000 16K read/write/exec /usr/lib/libaio.so.1 EF000000 5224K read/exec /u01/app/oracle/product/816/lib/libjox8.so EF528000 184K read/write/exectotal 43704K
/u01/app/oracle/product/816/lib/libjox8.so
EF556000 8K read/write/exec [ anon ] EF560000 16K read/exec /usr/platform/sun4u/lib/libc_psr.so.1 EF570000 8K read/write/exec [ anon ] EF580000 912K read/exec /u01/app/oracle/product/816/lib/liblsm.so EF672000 48K read/write/exec /u01/app/oracle/product/816/lib/liblsm.so EF67E000 504K read/write/exec [ anon ] EF710000 8K read/exec /usr/lib/libsched.so.1 EF720000 8K read/write/exec /usr/lib/libsched.so.1 EF730000 8K read/write/exec/shared [ anon ] EF740000 32K read/exec /usr/lib/libsocket.so.1 EF756000 8K read/write/exec /usr/lib/libsocket.so.1 EF758000 8K read/write/exec [ anon ] EF760000 8K read/exec /u01/app/oracle/product/816/lib/libwtc8.so EF770000 8K read/write/exec
/u01/app/oracle/product/816/lib/libwtc8.so
EF780000 8K read/exec /u01/app/oracle/product/816/lib/libskgxp8.so EF790000 8K read/write/exec
/u01/app/oracle/product/816/lib/libskgxp8.so
EF7A0000 8K read/exec /usr/lib/libdl.so.1 EF7B0000 8K read/write/exec [ anon ] EF7C0000 144K read/exec /usr/lib/ld.so.1 EF7F2000 16K read/write/exec /usr/lib/ld.so.1 EFFFA000 24K read/write/exec [ stack ]
pmem aditional soft pack
$ /opt/RMCmem/bin/pmem 28030
28030: ora_dbw0_GLJUK11
Address Kbytes Resident Shared Private Permissions Mapped File 00010000 23392 12064 12064 - read/exec oracle 016F6000 216 216 176 40 read/write/exec oracle 0172C000 1816 168 - 168 read/write/exec [ heap ] 80000000 9520 9520 9520 - read/write/exec/shared [shmid=0x803] EED80000 16 16 16 - read/exec libmp.so.2 EED92000 8 8 8 - read/write/exec libmp.so.2 EEDA0000 120 104 104 - read/exec libelf.so.1 EEDCC000 8 8 8 - read/write/exec libelf.so.1 EEDE0000 16 16 16 - read/exec libkvm.so.1 EEDF2000 16 16 16 - read/write/exec libkvm.so.1 EEE00000 600 600 600 - read/exec libc.so.1 EEEA4000 32 32 8 24 read/write/exec libc.so.1 EEEAC000 8 - - - read/write/exec [ anon ] EEED0000 88 88 88 - read/exec libm.so.1 EEEF4000 8 8 8 - read/write/exec libm.so.1 EEF00000 480 376 376 - read/exec libnsl.so.1 EEF86000 40 40 40 - read/write/exec libnsl.so.1 EEF90000 24 - - - read/write/exec [ anon ] EEFA0000 8 8 8 - read/exec libkstat.so.1 EEFB0000 8 8 8 - read/write/exec libkstat.so.1 EEFC0000 24 24 24 - read/exec libposix4.so.1 EEFD4000 8 8 8 - read/write/exec libposix4.so.1 EEFE0000 24 24 24 - read/exec libaio.so.1 EEFF4000 16 16 16 - read/write/exec libaio.so.1 EF000000 5224 1584 1584 - read/exec libjox8.so EF528000 184 160 160 - read/write/exec libjox8.so EF556000 8 - - - read/write/exec [ anon ] EF560000 16 16 16 - read/exec libc_psr.so.1 EF570000 8 8 - 8 read/write/exec [ anon ] EF580000 912 216 216 - read/exec liblsm.so EF672000 48 40 40 - read/write/exec liblsm.so EF67E000 504 - - - read/write/exec [ anon ] EF710000 8 8 8 - read/exec libsched.so.1 EF720000 8 8 8 - read/write/exec libsched.so.1 EF730000 8 8 8 - read/write/exec/shared [ anon ] EF740000 32 32 32 - read/exec libsocket.so.1 EF756000 8 8 8 - read/write/exec libsocket.so.1 EF758000 8 - - - read/write/exec [ anon ] EF760000 8 8 8 - read/exec libwtc8.so EF770000 8 8 8 - read/write/exec libwtc8.so EF780000 8 8 8 - read/exec libskgxp8.so EF790000 8 8 8 - read/write/exec libskgxp8.so EF7A0000 8 8 8 - read/exec libdl.so.1 EF7B0000 8 8 - 8 read/write/exec [ anon ] EF7C0000 144 144 144 - read/exec ld.so.1 EF7F2000 16 16 - 16 read/write/exec ld.so.1 EFFFA000 24 16 - 16 read/write/exec [ stack ] -------- ------ ------ ------ ------ total Kb 43704 25680 25400 280superhost*/817-/u01/app/oracle/product
Jurijs
9268222
J.Velikanovs_at_alise.lv
Sent by: oracle-l-bounce_at_freelists.org
09.07.2004 10:26
Please respond to oracle-l
To: oracle-l_at_freelists.org
cc:
Subject: Re: private memory used by oracle process in AIX
??
Hi Prem,
Are you aware regarding UNIX virtual memory mechanisms?
I am asking because from vmstat, ps, top and others OS tools, which
aggregate memory utilization information (RSS, VSZ etc) we can’t see for
sure how many Memory utilizing each process.
This is because VSZ figure include not just privet memory areas, but also
shared memory (like SGA) and TEXT (code). RSS represent VSZ process memory
which in RAM at the moment (other part swapped).
The way how different OS-es show RSS, VSZ figures differs from one OS to
other, but principles preserve.
.
Some OS-es have tools which allows to see in details all memory areas. For
example:
Solaris - /usr/proc/bin/pmap
Linux - cat /proc/<pid>/maps
Unfortunately I unaware of such tool on AIX. PS If you will find one, please share this information.
I you are interesting to investigate dipper, how UNIX manage and reflect information about memory utilization, then I would recommend to read “The SolarisMemorySystem Sizing,ToolsandArchitecture” from Sun. Document about Solaris, but main concepts are the same for UNIXes.
Any body, please correct me, in case I am wrong,
Best regards,
Jurijs
9268222
PS One way how you can try to calculate the MEM utilizations by each Oracle process (with known approximately), is to select sorted list of all
DB processes memory utilization (VSZ), take the smallest one and subtract the figure from others processes VSZ. This method assume, that smallest process use all shared memory as others DB processes, but privet part is insignificant. Doesn’t work if you using JVM.
"Prem Khanna J" <premj_at_rediffmail.com>
Sent by: oracle-l-bounce_at_freelists.org
09.07.2004 08:05
Please respond to oracle-l
To: oracle-l_at_freelists.org
cc:
Subject: private memory used by oracle process in AIX ??
Hi All,
the env is oracle 9.2.0.4/AIX5.2
# ps v 1495162
PID PGIN SIZE RSS LIM TSIZ TRS %CPU %MEM COMMAND
1495162 40 9068 32272 xx 48602 23204 0.0 1.0 ora_pmon
which will give me the private memory of the above process :
RSS - TRS
or
(RSS - TRS )*4
RSS & TRS are reported in kb. whereas an AIX memory page is 4096 bytes.
doc 123754.1 seems to be confusing.
it says to mulitply the difference by 4 , where as it doesn't in the
example shown in the doc.
can someone guide me which is the right way ?
Regards,
Prem.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Jul 09 2004 - 02:47:25 CDT
 |
 |