AIX 7.1 oracle 11.2.0.3 huge memory leak
- From: Anton <djeday84@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 Mar 2014 09:35:45 +0400
hi all
faced with heavy swapping, while investigating found huge difference
between oracle and os stats:
v$process says that it use 1.5 gb mem
svmon says that is tis 10gb.
where such differences come from ?
bash-4.2# svmon -U oracle -O
segment=category,unit=MB,sortentity=pgsp,filtertype=working,process=on |
head -25
Unit: MB
===============================================================================
User Inuse Pin Pgsp Virtual
oracle 41179.38 590.73 27917.30 63493.41
-------------------------------------------------------------------------------
Pid Command Inuse Pin Pgsp Virtual
*51052894 oracle 9016.62 39.2 2273.88 10940.50*
11010066 oracle 465.83 0.19 1430.34 1542.33
13632114 oracle 463.73 0.19 1393.21 1542.32
21168584 oracle 456.06 0.19 1322.54 1542.82
4260408 oracle 798.98 0.19 1225.30 1368.77
61210926 oracle 795.25 0.19 1099.12 1368.77
20448030 oracle 498.23 0.19 1044.51 1205.08
34079040 oracle 798.92 0.19 986.36 1368.77
44433750 oracle 921.85 0.19 871.66 1304.71
58655074 oracle 510.53 0.19 846.24 1091.12
7340592 oracle 522.36 0.19 822.12 1091.12
4326136 oracle 521.50 0.19 821.52 1091.23
12321578 oracle 1178.31 0.19 815.12 1481.91
24249310 oracle 506.46 0.19 791.75 1091.12
60948896 oracle 659.91 0.19 676.79 1001.32
50200676 oracle 168.06 0.19 562.99 713.18
57016582 oracle 83.2 0.19 479.40 536.70
2228812 oracle 81.9 0.19 478.94 536.63
:::::::::::::::::::::::::::::::::: PROGRAM GLOBAL AREA statistics
:::::::::::::::::::::::::::::::::
<https://community.oracle.com/message/1812436#1812436>
SESSION PID/THREAD CURRENT SIZE MAXIMUM SIZE
-------------------------------------------------- ----------
------------------ ------------------
924 - ETLdc1-dwhfrn02 11010066 1,526.45 MB 1,528.58 MB
1029 - ETLdc1-dwhfrn02 13632114 1,526.45 MB 1,528.58 MB
1083 - ETLdc1-dwhfrn02 21168584 1,526.39 MB 1,528.52 MB
* 963 - ETLdc1-dwhfrn02 51052894 1,526.39 MB 1,528.52 MB*
1615 - ETLdc1-dwhfrn02 12321578 1,431.77 MB 1,431.77 MB
2099 - ETLdc1-dwhfrn02 12845104 1,366.64 MB 1,366.64 MB
1604 - ETLdc1-dwhfrn02 20447468 1,286.87 MB 1,287.00 MB
1919 - ETLdc1-dwhfrn02 4260408 1,239.14 MB 1,239.14 MB
1980 - ETLdc1-dwhfrn02 34079040 1,235.89 MB 1,235.89 MB
1944 - ETLdc1-dwhfrn02 61210926 1,235.89 MB 1,235.89 MB
2028 - ETLdc1-dwhfrn02 44433750 1,222.45 MB 1,236.70 MB
962 - ETLdc1-dwhfrn02 20448030 1,160.95 MB 1,166.20 MB
427 - ETLdc1-dwhfrn02 7340592 1,153.64 MB 1,153.64 MB
509 - ETLdc1-dwhfrn02 4326136 1,153.64 MB 1,153.64 MB
313 - ETLdc1-dwhfrn02 58655074 1,153.64 MB 1,153.64 MB
589 - ETLdc1-dwhfrn02 24249310 1,153.64 MB 1,153.64 MB
308 - ETLdc1-dwhfrn02 41943434 1,076.19 MB 1,076.19 MB
ps:
bash-4.2# uname -a
AIX DC1-DWHFRN02 1 7 00F8298E4C00
opatch -lsinventory
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g
11.2.0.3.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Other related posts:
