Oracle process memory structure - how to view the memory consumed by Oracle process

xiaoxiao2021-03-06 44

Oracle Process Memory Structure - How to check the memory consumption of Oracle process

Last Updated:

Sunday, 2004-11-28 11:12

Eygle

Often someone asks how to determine the memory resources consumed under UNIX, and why the TOP tool is very high. Some people say that TOP's output is inaccurate, which is in exact. In fact, the Oracle process memory displayed in TOP output is used, which contains the SGA section. This is also the meaning of SGA. SGA can be shared, can be accessed by all processes, containing SGA size in the addressing space of the process.

As for how to determine the memory consumption of the process more accurately, this paper briefly describes the following (under Quickio, you may not see the description of this article):

1. System platform and database version

$ uname -a

Sunos Billing 5.8 Generic_108528-23 Sun4u SPARC SUNW, ULTRA-4

Sun Microsystems Inc. Sunos 5.8 Generic Patch October 2001

$ SQLPLUS "/ as sysdba"

SQL * Plus: Release 9.2.0.4.0 - Production on Sun Nov 28 10:48:00 2004

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

With the partitioning, OLAP AND ORACLE DATA MINING OPTIONS

JServer Release 9.2.0.4.0 - Production

SQL> SELECT * FROM V $ VERSION;

Banner

-------------------------------------------------- ----------------

Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

PL / SQL Release 9.2.0.4.0 - Production

Core 9.2.0.3.0 Production

TNS for Solaris: Version 9.2.0.4.0 - Production

NLSRTL VERSION 9.2.0.4.0 - Production

SQL> SHOW SGA

Total System Global Area 253200688 Bytes

Fixed size 731440 bytes

Variable size 167772160 bytes

Database buffers 83886080 BYtes

Redo buffers 811008 Bytes

SQL> EXIT

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

With the partitioning, OLAP AND ORACLE DATA MINING OPTIONS

JServer Release 9.2.0.4.0 - Production

2.Top output

$ TOP

Load averages: 0.12, 0.05, 0.04 billing 10:49:52

54 Processes: 52 Sleeping, 1 Stopped, 1 On CPucpu State: 99.3% iDLE, 0.0% User, 0.3% Kernel, 0.4% iowait, 0.0% SWAP

Memory: 2.0G REAL, 1.2G Free, 404M Swap in Use, 5.1g Swap Free

PID Username Thr Pr NCE Size Res State Time Flt CPU Command

10027 Oracle 1 58 0 2568K 1680K CPU03 0:00 0 0.09% Top

10052 Oracle 1 58 0 322M 275M Sleep 21:18 0 0.01% Oracle

11264 Oracle 22 58 0 329M 275M Sleep 59:01 0 0.00% Oracle

10056 Oracle 1 58 0 322M 275M SLEEP 3:04 0 0.00% Oracle

11262 Oracle 14 58 0 331M 270M SLEEP 73:55 0 0.00% Oracle

11260 Oracle 258 59 0 333M 274M Sleep 52:46 0 0.00% Oracle

11266 Oracle 1 58 0 325M 276M SLEEP 26:50 0 0.00% Oracle

10054 Oracle 1 59 0 322M 275M SLEEP 18:27 0 0.00% Oracle

23519 Oracle 1 55 0 322M 278M Sleep 0:50 0 0.00% Oracle

11258 Oracle 1 59 0 323M 271M SLEEP 0:31 0 0.00% Oracle

11285 Oracle 1 58 0 17.3m 3848k Sleep 0:20 0 0.00% TNSLSNR

11270 Oracle 1 58 0 322M 271M SLEEP 0:06 0 0.00% Oracle

2990 Oracle 1 59 0 322M 276M SLEEP 0:04 0 0.00% Oracle

9872 Oracle 1 48 0 1880K 1192K Sleep 0:00 0 0.00% KSH

23498 Oracle 1 58 0 323M 278M SLEEP 0:00 0 0.00% Oracle

3. PMAP output and process memory calculation

$ PS-EF | GREP ORA_

Oracle 9881 9872 0 10:49:57 PTS / 2 0:00 grep ora_

Oracle 11258 1 0 JUL 19? 0:31 Ora_PMON_HSBILL

Oracle 11260 1 0 JUL 19? 52:47 ORA_DBW0_HSBILL

Oracle 11262 1 0 JUL 19? 73:55 Ora_LGWR_HSBILL

Oracle 11264 1 0 JUL 19? 59:01 ORA_CKPT_HSBILL

Oracle 11266 1 0 JUL 19? 26:50 Ora_SMON_HSBILL

Oracle 11268 1 0 JUL 19? 0:00 ORA_RECO_HSBILLORACLE 11270 1 0 JUL 19? 0:06 ORA_CJQ0_HSBILL

Oracle 10054 1 0 NOV 02? 18:27 ORA_J001_HSBILL

Oracle 10052 1 0 NOV 02? 21:19 ORA_J000_HSBILL

Oracle 2990 1 0 NOV 25? 0:05 ORA_J003_HSBILL

Oracle 10056 1 0 NOV 02? 3:04 ORA_J002_HSBILL

Oracle 8879 1 0 09:54:32? 0:00 ORA_J004_HSBILL

$ PMAP 11264

11264: ORA_CKPT_HSBILL

0000000100000000 53824K Read / Exec /opt/oracle/product/9.2.0/bin/oracle

000000010358E000 872K Read / Write / Exec /opt/oracle/Product/9.2.0/bin/oracle

0000000103668000 7968k Read / Write / EXEC [HEAP]

0000000380000000 266240k Read / Write / Exec / Shared [ism shmid = 0x64]

Ffffffffff7c802000 8k read / write / exec [anon]

Ffffffffff7c814000 8k read / write / exec [anon]

Ffffffffff7c826000 8k read / write / exec [anon]

Ffffffffff7c838000 8k read / write / exec [anon]

Ffffffffff7c84a000 8k read / write / exec [anon]

Ffffffffff7c85c000 8k read / write / exec [Anon]

Ffffffffff7c86e000 8k read / write / exec [Anon]

Ffffffffff7c880000 8k read / write / exec [anon]

Ffffffffff7c892000 8k read / write / exec [anon]

Ffffffffff7c8a4000 8k read / write / exec [anon]

Ffffffffff7c8b6000 8k read / write / exec [anon]

Ffffffffff7c8c8000 8k read / write / exec [anon]

Ffffffffffff7c8d6000 8k read / write / exec [anon]

Ffffffffff7c8da000 8k read / write / exec [Anon]

Ffffffffff7c8e8000 8k read / write / exec [anon]

Fffffffff7c8ec000 8k read / write / exec [anon]

Ffffffffffff7c8fa000 8k read / write / exec [anon]

Ffffffffff7c8fe000 8k read / write / exec [anon]

Ffffffff7c90c000 8k read / write / exec [Anon]

Ffffffffff7c910000 8k read / write / exec [anon]

Ffffffffff7c91e000 8k read / write / exec [anon]

Ffffffffff7ca02000 8k read / write / exec [anon]

Fffffffffff7ca10000 8k read / write / exec [anon]

Fffffffff7ca14000 8k read / write / exec [anon]

Ffffffffff7ca22000 8k read / write / exec [anon]

Ffffffffff7ca26000 8k read / write / exec [anon]

Ffffffffff7ca34000 8k read / write / exec [anon]

Ffffffffff7ca38000 8k read / write / exec [anon]

Fffffffff7ca46000 8k read / write / exec [anon]

Ffffffffff7ca4a000 8k read / write / exec [anon]

Ffffffffff7ca58000 8k read / write / exec [Anon]

Ffffffffff7ca5c000 8k read / write / exec [anon]

Ffffffffff7ca6a000 8k read / write / exec [anon]

Ffffffffff7ca6e000 8k read / write / exec [anon]

Ffffffffff7ca7c000 8k read / write / exec [anon]

Ffffffffff7ca80000 8k read / write / exec [Anon]

Ffffffffff7ca8e000 8k read / write / exec [anon]

Ffffffffff7ca92000 8k read / write / exec [Anon]

Ffffffffff7caa0000 8k read / write / exec [anon]

Fffffffff7caa4000 8k read / write / exec [anon]

Ffffffffff7cab2000 8k read / write / exec [anon]

Fffffffff7cab6000 8k read / write / exec [anon]

Ffffffffff7cac4000 8k read / write / exec [anon]

Ffffffffff7cac8000 8k read / write / exec [anon]

Fffffffff7cad6000 8k read / write / exec [anon]

Ffffffffff7cada000 8k read / write / exec [anon]

Ffffffffff7cae8000 8k read / write / exec [anon]

Ffffffffff7caec000 8k read / write / exec [anon]

Fffffffff7cafa000 8k read / write / exec [anon]

Fffffffff7cafe000 8k read / write / exec [Anon] fffffffff7cb0c000 8k read / write / exec [Anon]

Ffffffffff7cb10000 8k read / write / exec [anon]

Ffffffffff7cb1e000 8k read / write / exec [anon]

Ffffffffff7cc00000 8k Read / Write / Exec [Anon]

Ffffffffff7cd00000 24k read / exec /usr/lib/sparcv9/nss_files.so.1

Ffffffffff7Ce06000 8k Read / Write / Exec /usR/LIB/SPARCV9/NSS_FILES.SO.1

Fffffffff7cf00000 8k read / write [anon]

Ffffffffffff7cf10000 8k read / write [anon]

Fffffffff7cf50000 8k read / write [anon]

Fffffffff7cf60000 16k read / write [anon]

Ffffffffff7cf68000 32k read / write [anon]

Ffffffffff7d000000 16k read / exec /usr/platform/sun4u/lib/sparcv9/libc_psr.so.1

Ffffffffff7d100000 16k read / exec /usr/lib/sparcv9/libmp.so.2

Ffffffffff7d204000 8k read / write / exec /usr/lib/sparcv9/libmp.so.2

Fffffffff7d300000 8k read / write / exec [anon]

Fffffffff7d400000 88k read / exec /usr/lib/sparcv9/libm.so.1

Fffffffff7d516000 8k read / write / exec /usr/lib/sparcv9/libm.so.1

Ffffffffff7d600000 8k read / exec /usr/lib/sparcv9/libstat.so.1

Ffffffffff7d702000 8k read / write / exec /usr/lib/sparcv9/libkstat.so.1

Fffffffff7d800000 32k read / exec /usr/lib/sparcv9/librt.so.1

Fffffffff7d908000 8k read / write / exec /usr/lib/sparcv9/librt.so.1

Ffffffffff7da00000 32k Read / Exec /usR/LIB/SPARCV9/LIBAIO.SO.1

Ffffffff7db08000 8k read / write / exec /usr/lib/sparcv9/libaio.so.1

Ffffffffff7dc00000 720k Read / Exec /usR/LIB/SPARCV9/LIBC.SO.1

Fffffffffff7ddb4000 56k read / write / exec /usr/lib/sparcv9/libc.so.1

Ffffffffff7ddc2000 8k read / write / exec /usr/lib/sparcv9/libc.so.1fffffffff7df00000 8k read / write / exec [anon]

Ffffffff7e000000 32k read / exec /usr/lib/sparcv9/libgen.so.1

Ffffffff7e108000 8k read / write / exec /usr/lib/sparcv9/libgen.so.1

Ffffffff7e200000 672k read / exec /usr/lib/sparcv9/libnsl.so.1

Fffffffff7e3a8000 56k ready / exec /usr/lib/sparcv9/libnsl.so.1

Ffffffff7e3b6000 40k read / write / exec /usr/lib/sparcv9/libnsl.so.1

Ffffffff7e400000 5328k read / exec /opt/oracle/product/9.2.0/lib/libjox9.so

Fffffffff7ea32000 384k read / write / exec /opt/oracle/product/9.2.0/lud/libjox9.so

Ffffffff7ea92000 8k read / write / exec /opt/oracle/product/9.2.0/lud/libjox9.so

Ffffffff7eb00000 56k read / exec /usr/lib/sparcv9/libsocket.so.1

Ffffffff7ec0e000 16k read / write / exec /usr/lib/sparcv9/libsocket.so.1

Ffffffff7ed00000 8k Read / Write / Exec [Anon]

Ffffffff7ee00000 32k read / exec /opt/oracle/product/9.2.0/lib/libskgxn9.so

Ffffffff7ef06000 8k read / write / exec /opt/oracle/product/9.2.0/lib/libskgxn9.so

Ffffffffff7f000000 8k read / exec /opt/racle/product/9.2.0/lib/libskgxp9.so

Ffffffffff7f100000 8k read / write / exec /opt/oracle/product/9.2.0/lib/libskgxp9.so

Ffffffffff7f200000 8k read / exec /opt/oracle/product/9.2.0/lib/libodmd9.so

Ffffffffff7f300000 8k read / write / exec /opt/oracle/product/9.2.0/lib/libodmd9.so

Ffffffffff7f400000 8k read / exec /usr/lib/sparcv9/libdl.so.1

Ffffffffff7f500000 8k read / write / exec [anon]

Ffffffffff7f600000 152k read / exec /usr/lib/sparcv9/ld.so.1

Ffffffffff7f724000 16k read / write / exec /usr/lib/sparcv9/ld.so.1

Ffffffff7ffa000 24k Read / Write [stack] Total 337360K

Calculate the memory resources used by the background process:

337360K - 266240K = 71,120k

This is the memory consumed by a process.

4. User process memory usage example

$ PS-EF | GREP LOCAL

Oracle 10080 9872 0 11:00:25 PTS / 2 0:00 Grep Local

Oracle 23498 1 0 NOV 25? 0:00 Oraclehsbill (local = no)

Oracle 23519 1 0 NOV 25? 0:50 Oraclehsbill (local = no)

$ PMAP 23519

23519: Oraclehsbill (local = no)

0000000100000000 53824K Read / Exec /opt/oracle/product/9.2.0/bin/oracle

000000010358E000 872K Read / Write / Exec /opt/oracle/Product/9.2.0/bin/oracle

0000000103668000 848k Read / Write / EXEC [HEAP]

0000000380000000 266240k Read / Write / Exec / Shared [ism shmid = 0x64]

Ffffffff7cc00000 8k read / write [anon]

Fffffffff7cc10000 8k read / write [anon]

Ffffffffff7cc50000 136k ready [anon]

Ffffffffff7cc76000 40k read / write [anon]

Ffffffffff7cd00000 8k read / write / exec [anon]

Ffffffffff7ce00000 24k Read / Exec /usR/LIB/SPARCV9/NSS_FILES.SO.1

Ffffffffffff7cf06000 8k read / write / exec /usr/lib/sparcv9/nss_files.so.1