| 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: Memory utilization
Sure! One way is to use the UNIX "pmap" utility...
Here is 8.1.7.3 on Sol 2.8; my apologies if this output wraps and comes out really ugly -- there's really no way to "prettify" this on the plain text email formats enforced by the list server...
I've made notes indicating where the Oracle PGA/UGA and SGA data structures are located....
$ pmap 28598
28598: oracleportal (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
00010000 26520K read/exec /opt/app/oracle/product/8.1.7/bin/oracle 01A04000 264K read/write/exec /opt/app/oracle/product/8.1.7/bin/oracle 01A46000 720K read/write/exec [ heap ] <<== ORACLE PGA/UGA ISHERE!!!
FF080000 16K read/exec /usr/platform/sun4u/lib/libc_psr.so.1 FF090000 16K read/exec /usr/lib/libmp.so.2 FF0A4000 8K read/write/exec /usr/lib/libmp.so.2 FF0B0000 88K read/exec /usr/lib/libm.so.1 FF0D4000 8K read/write/exec /usr/lib/libm.so.1 FF0E0000 8K read/exec /usr/lib/libkstat.so.1 FF0F2000 8K read/write/exec /usr/lib/libkstat.so.1 FF100000 680K read/exec /usr/lib/libc.so.1 FF1BA000 32K read/write/exec /usr/lib/libc.so.1 FF1D0000 24K read/exec /usr/lib/librt.so.1 FF1E6000 8K read/write/exec /usr/lib/librt.so.1 FF1F0000 32K read/exec /usr/lib/libaio.so.1 FF208000 8K read/write/exec /usr/lib/libaio.so.1 FF210000 8K read/write/exec [ anon ] FF220000 8K read/exec /usr/lib/libsched.so.1 FF232000 8K read/write/exec /usr/lib/libsched.so.1 FF240000 24K read/exec /usr/lib/libgen.so.1 FF256000 8K read/write/exec /usr/lib/libgen.so.1 FF260000 40K read/exec /usr/lib/libsocket.so.1 FF27A000 8K read/write/exec /usr/lib/libsocket.so.1 FF280000 560K read/exec /usr/lib/libnsl.so.1 FF31C000 32K read/write/exec /usr/lib/libnsl.so.1 FF324000 32K read/write/exec /usr/lib/libnsl.so.1 FF340000 8K read/write/exec/shared [ anon ] FF350000 32K read/exec /opt/app/oracle/product/8.1.7/lib/libdsbtsh8.so FF366000 8K read/write/exec /opt/app/oracle/product/8.1.7/lib/libdsbtsh8.so FF368000 8K read/write/exec /opt/app/oracle/product/8.1.7/lib/libdsbtsh8.so FF370000 8K read/exec /opt/app/oracle/product/8.1.7/lib/libskgxp8.so FF380000 8K read/write/exec /opt/app/oracle/product/8.1.7/lib/libskgxp8.so FF390000 8K read/exec /usr/lib/libdl.so.1 FF3A0000 8K read/write/exec [ anon ] FF3B0000 152K read/exec /usr/lib/ld.so.1 FF3E6000 8K read/write/exec /usr/lib/ld.so.1 FFBE0000 64K read/write/exec [ stack ]total 238896K
So, the total at the bottom shows that total virtual memory consumed for this process is 238896K, but really all but those areas marked as "heap" and "stack" are truly distinct for the process. All those other "text" pages with the file-names next to them, as well as the 205,192 Kbyte section marked as "ism" are memory pages that are shared amongst all "oracle" server processes, both foreground and background.
I see 720K of "heap" (i.e. Oracle PGA and UGA) and 64K of "stack" which is particular to this process. I don't know what "anon" means, but let's assume that it is also private to this specific process, so that totals to 808K that is specific and private to this process.
So, in this example, of the total "footprint" of 238,896 Kb of virtual memory, only 808Kb of that is "private" to this process only and the remaining 238,088Kb is shared by all of the "oracle" server processes...
> Hi Gurus,
>
> How can I find out the amount of memory utilized (grabbed from the
> available memory of the OS) by a server process, whenever a user
> establishes a connection with the database. The OS is Sun Solairs with
> Oracle version 8.1.7.3. In other words, if I have a unix process id, is
> there a way to find out how much memory it is consuming.
>
> Thanks for your help and time in advance.
>
> CP
>
>
>
>
> lzhang_at_salu.com wrote:
>
> >OS: Solaris 2.7
> >Database: 8.1.7
> >
> >On dev server, !ls from sqlplus gives the files of current directory
where
> >sqlplus runs.
> >On pro server, !ls from sqlplus goes to the home directory of os user.
> >
> >For example,
> >Login to sqlplus from /u01 on both machines,
> >on dev: SQL> !pwd
> > /u01
> >
> >on pro: SQL> !pwd
> >/export/oracle
> >
> >What seting affects this ?
> >
> >Thanks,
> >
> >-Li Zhang
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: CP
> INET: csp2201_at_netscape.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: Tim_at_SageLogix.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Jun 13 2002 - 20:03:18 CDT
 |
 |