Why is rac1 free memory so low?
本帖最后由 Mille 于 2013-12-13 09:57 编辑aix 6100+oracle 11.2.0.3 rac
两个节点sga pga参数一致, vmstat free 相差比较大？？
rac1 Topas
Topas Monitor for host: rac1 EVENTS/QUEUES FILE/TTY
Fri Dec 13 09:04:52 2013 Interval: 2 Cswitch 8543 Readch 681.4K
Syscall 56368 Writech 172.1K
CPU User% Kern% Wait% Idle% Reads 677 Rawin 0
ALL 1.4 1.4 0.4 96.8 Writes 304 Ttyout 430
Forks 23 Igets 0
Network KBPS I-Pack O-Pack KB-In KB-Out Execs 24 Namei 17560
Total 151.3 157.0 89.0 117.3 34.0 Runqueue 0.5 Dirblk 0
Waitqueue 0.5
Disk Busy% KBPS TPS KB-Read KB-Writ MEMORY
Total 1.8 1335.3 296.0 64.0 1271.4 PAGING Real,MB 58368
Faults 9167 % Comp 49
FileSystem KBPS TPS KB-Read KB-Writ Steals 0 % Noncomp 50
Total 667.5 508.4 577.5 90.0 PgspIn 0 % Client 50
PgspOut 0
Name PID CPU% PgSp Owner PageIn 0 PAGING SPACE
sendmail 25690720 0.7 2.1 root PageOut 20 Size,MB 46080
oracle 37290646 0.2 15.2 grid Sios 20 % Used 0
ohasd.bi 4260132 0.1 59.8 root % Free 100
gipcd.bi 4718916 0.1 27.0 grid NFS (calls/sec)
evmd.bin 3474038 0.1 41.6 grid SerV2 0 WPAR Activ 0
crsd.bin 4784880 0.1 81.5 root CliV2 0 WPAR Total 0
octssd.b 3932428 0.1 16.2 root SerV3 0 Press: "h"-help
oracle 31982020 0.1 28.8 oracle CliV3 0 "q"-quit
oracle 2425562 0.1 22.8 grid
ocssd.bi 3670676 0.1 119.2 grid
oracle 21365254 0.1 15.1 grid
oraroota 5440026 0.0 30.1 root
oracle 25362864 0.0 33.1 oracle
cssdmoni 4522648 0.0 77.0 root
osysmond 3867332 0.0 115.9 root
gil 1245830 0.0 0.9 root
oracle 3801126 0.0 27.2 grid
oracle 31588844 0.0 14.8 oracle
reaffin 589850 0.0 0.6 root
oracle 24511060 0.0 25.4 oracle
oracle@rac1$vmstat 1 10
System configuration: lcpu=48 mem=58368MB
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
1 0 6822232 33863 0 0 0 0 0 0 396 87101 8236 2 1 96 0
2 0 6822024 34057 0 0 0 0 0 0 507 57470 8683 1 1 97 0
2 0 6822077 33999 0 0 0 0 0 0 465 56840 8987 2 1 96 0
1 0 6822113 33961 0 0 0 0 0 0 374 42676 8004 1 1 98 0
1 0 6822025 34049 0 0 0 0 0 0 515 68056 8164 4 1 95 0
0 0 6822025 34048 0 0 0 0 0 0 392 50710 7685 1 1 97 0
3 0 6822113 33957 0 0 0 0 0 0 486 93696 7944 2 1 96 0
4 0 6822079 33992 0 0 0 0 0 0 353 53110 8101 1 1 97 0
1 0 6822081 33990 0 0 0 0 0 0 407 51367 8172 1 1 97 0
2 0 6822031 34038 0 0 0 0 0 0 330 80944 8155 1 1 97 0
rac2 vmstat
oracle@rac2$vmstat 1 10
System configuration: lcpu=48 mem=58368MB
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 0 5438806 3792351 0 0 0 0 0 0 109 27280 9954 1 1 98 0
0 0 5438806 3792349 0 0 0 0 0 0 102 20160 8519 1 1 99 0
1 0 5438886 3792269 0 0 0 0 0 0 225 25113 7913 1 1 98 0
1 0 5438934 3792220 0 0 0 0 0 0 231 52878 7297 1 1 98 0
1 0 5438982 3792172 0 0 0 0 0 0 119 20760 7531 1 1 99 0
0 0 5438998 3792154 0 0 0 0 0 0 113 25256 8860 1 1 98 0
0 0 5436564 3794587 0 0 0 0 0 0 184 53319 7686 1 1 98 0
1 0 5436484 3794667 0 0 0 0 0 0 81 19627 7677 1 1 99 0
1 0 5436516 3794633 0 0 0 0 0 0 120 21276 8019 1 1 99 0
0 0 5436612 3794537 0 0 0 0 0 0 168 19829 7903 1 1 99 0
rac2 topas
Topas Monitor for host: rac2 EVENTS/QUEUES FILE/TTY
Fri Dec 13 09:11:10 2013 Interval: 2 Cswitch 7968 Readch 151.0K
Syscall 22600 Writech 16441
CPU User% Kern% Wait% Idle% Reads 159 Rawin 0
ALL 0.9 0.7 0.0 98.4 Writes 91 Ttyout 570
Forks 2 Igets 0
Network KBPS I-Pack O-Pack KB-In KB-Out Execs 3 Namei 180
Total 220.1 194.0 221.5 92.8 127.3 Runqueue 0.5 Dirblk 0
Waitqueue 0.0
Disk Busy% KBPS TPS KB-Read KB-Writ MEMORY
Total 0.0 273.0 5.0 72.0 201.0 PAGING Real,MB 58368
Faults 1345 % Comp 36
FileSystem KBPS TPS KB-Read KB-Writ Steals 0 % Noncomp 38
Total 117.9 115.0 115.2 2.7 PgspIn 0 % Client 38
PgspOut 0
Name PID CPU% PgSp Owner PageIn 0 PAGING SPACE
oracle 8716920 0.5 14.7 grid PageOut 0 Size,MB 43520
crsd.bin 5111978 0.2 56.4 root Sios 0 % Used 0
oraroota 5767672 0.2 61.5 root % Free 100
ohasd.bi 2490668 0.1 59.5 root NFS (calls/sec)
gipcd.bi 5898376 0.1 27.0 grid SerV2 0 WPAR Activ 0
oracle 8651076 0.1 24.5 oracle CliV2 0 WPAR Total 0
octssd.b 4129352 0.1 16.1 root SerV3 0 Press: "h"-help
ocssd.bi 3539372 0.1 88.5 grid CliV3 0 "q"-quit
oracle 6554206 0.1 23.2 grid
oracle 8454442 0.1 24.5 oracle
evmd.bin 3670566 0.0 41.5 grid
oracle 11665508 0.0 24.6 oracle
oracle 8847656 0.0 24.8 oracle
gil 1180294 0.0 0.9 root
oracle 7995890 0.0 15.8 grid
reaffin 589850 0.0 0.6 root
oraroota 4588256 0.0 60.3 root
oraagent 8323474 0.0 49.0 oracle
oraagent 3735558 0.0 77.6 grid
oracle 3605148 0.0 15.3 grid
SQL> select count(*),t.INST_ID from gv$session t group by t.INST_ID;
COUNT(*) INST_ID
---------- ----------
69 1
79 2
SQL> select count(*),t.INST_ID from gv$session t where t.STATUS='ACTIVE' group by t.INST_ID
2 ;
COUNT(*) INST_ID
---------- ----------
51 1
53 2
SQL> /
COUNT(*) INST_ID
---------- ----------
51 1
53 2
SQL> /
COUNT(*) INST_ID
---------- ----------
51 1
54 2
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 15G
sga_target big integer 15G
SQL> show parameter pga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 3G
给出2个节点的 svmon -G -O unit=MB
和 svmon -U oracle -O unit=MB
Liu Maclean(刘相兵 发表于 2013-12-14 16:20 static/image/common/back.gif
给出2个节点的 svmon -G -O unit=MB
和 svmon -U oracle -O unit=MB
谢谢回复！
root@RAC_01[/]svmon -G -O unit=MB
Unit: MB
--------------------------------------------------------------------------------------
size inuse free pin virtual available mmode
memory 58368.00 58259.59 108.41 9293.41 28709.65 25643.41 Ded
pg space 46080.00 81.8
work pers clnt other
pin 7365.04 0 142.38 1786.00
in use 28709.65 0 29549.95
root@RAC_02[/]svmon -G -O unit=MB
Unit: MB
--------------------------------------------------------------------------------------
size inuse free pin virtual available mmode
memory 58368.00 46212.43 12155.57 4863.52 23905.42 32681.19 Ded
pg space 43520.00 69.7
work pers clnt other
pin 2935.14 0 142.38 1786.00
in use 23905.42 0 22307.01
root@RAC_01[/]svmon -U oracle -O unit=MB
Unit: MB
===============================================================================
User Inuse Pin Pgsp Virtual
oracle 17679.91 205.92 0 16850.86
root@RAC_02[/]svmon -U oracle -O unit=MB
Unit: MB
===============================================================================
User Inuse Pin Pgsp Virtual
oracle 17342.14 115.46 0 16450.95
root@RAC_02[/]vmstat 1 10
System configuration: lcpu=48 mem=58368MB
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
1 0 6132400 3099054 0 0 0 0 0 0 165 58902 8097 1 1 98 0
2 0 6132400 3099053 0 0 0 0 0 0 278 31961 8340 2 1 97 0
0 0 6132400 3099053 0 0 0 0 0 0 139 26278 9498 1 1 98 0
1 0 6132416 3099036 0 0 0 0 0 0 157 53434 8140 1 1 98 0
1 0 6132889 3098561 0 0 0 0 0 0 204 24740 7951 2 1 98 0
0 0 6132834 3098616 0 0 0 0 0 0 223 30461 8285 2 1 97 0
1 0 6132838 3098611 0 0 0 0 0 0 182 35293 7638 2 1 97 0
0 0 6133243 3098206 0 0 0 0 0 0 341 26157 9119 1 1 98 0
1 0 6133243 3098203 0 0 0 0 0 0 96 36871 7589 1 1 99 0
0 0 6133243 3098201 0 0 0 0 0 0 239 37421 7839 1 1 98 0
root@RAC_01[/]vmstat 1 10
System configuration: lcpu=48 mem=58368MB
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 0 7317884 59232 0 0 0 0 0 0 216 20819 7769 1 1 99 0
0 0 7317884 59230 0 0 0 0 0 0 71 28115 8443 2 1 97 0
0 0 7317884 59229 0 0 0 0 0 0 104 56597 7655 1 1 98 0
1 0 7317884 59228 0 0 0 0 0 0 74 20335 7391 1 1 99 0
1 0 7317883 59228 0 0 0 0 0 0 233 24079 7441 1 1 98 0
0 0 7317883 59227 0 0 0 0 0 0 341 21260 7505 1 1 99 0
0 0 7317867 59243 0 0 0 0 0 0 76 22989 7464 1 1 99 0
1 0 7322925 54184 0 0 0 0 0 0 369 23583 7710 1 1 97 0
1 0 7322925 54183 0 0 0 0 0 0 205 102284 7628 7 1 91 0
0 0 7322925 54182 0 0 0 0 0 0 135 21159 7532 1 1 99 0
root@RAC_01[/]svmon -U oracle -O unit=MB
Unit: MB
===============================================================================
User Inuse Pin Pgsp Virtual
oracle 17679.91 205.92 0 16850.86
root@RAC_02[/]svmon -U oracle -O unit=MB
Unit: MB
===============================================================================
User Inuse Pin Pgsp Virtual
oracle 17342.14 115.46 0 16450.95
2个节点上 oracle 用户总的使用的内存 是17g左右
而1节点 全局的 inuse 为 58259.59 》2节点的46212 ，这说明内存不是被oracle用户吃掉的 svmon -U grid
也看一下 Liu Maclean(刘相兵 发表于 2013-12-16 10:07 static/image/common/back.gif
svmon -U grid
也看一下
root@RAC_01[/]svmon -U grid -O unit=MB
Unit: MB
===============================================================================
User Inuse Pin Pgsp Virtual
grid 17768.69 289.10 0 16706.22
root@RAC_02[/]svmon -U grid -O unit=MB
Unit: MB
===============================================================================
User Inuse Pin Pgsp Virtual
grid 17522.03 205.54 0 16548.53 Liu Maclean(刘相兵 发表于 2013-12-16 10:07 static/image/common/back.gif
root@RAC_01[/]svmon -U oracle -O unit=MB
Unit: MB
================================================== ...
grid 也差不多，那到底什么什么占完了？ root@RAC_01[/]svmon -G -O unit=MB
Unit: MB
--------------------------------------------------------------------------------------
size inuse free pin virtual available mmode
memory 58368.00 58259.59 108.41 9293.41 28709.65 25643.41 Ded
pg space 46080.00 81.8
work pers clnt other
pin 7365.04 0 142.38 1786.00
in use 28709.65 0 29549.95
root@RAC_02[/]svmon -G -O unit=MB
Unit: MB
--------------------------------------------------------------------------------------
size inuse free pin virtual available mmode
memory 58368.00 46212.43 12155.57 4863.52 23905.42 32681.19 Ded
pg space 43520.00 69.7
work pers clnt other
pin 2935.14 0 142.38 1786.00
in use 23905.42 0 22307.01
节点1 clnt 29549.95 ， 节点2 22307.01
client 一般是 文件缓存， 我觉得你没必要纠结该问题
谢谢刘大！
把maxperm%
maxclient% 都改为50 之前是90
free 就升了
Liu Maclean(刘相兵 发表于 2013-12-16 11:07 static/image/common/back.gif
root@RAC_01[/]svmon -G -O unit=MB
Unit: MB
--------------------------------------------------------- ...
谢谢刘大！
把maxperm%
maxclient% 都改为50 之前是90
free 就升了
页:
[1]