Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › Why is rac1 free memory so low?

Mille

51 积分	0 好友	20 主题

发消息

[升级] Why is rac1 free memory so low?

1^#

发表于 2013-12-13 09:56:31 | 查看: 4255| 回复: 9

本帖最后由 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[/home/oracle]$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[/home/oracle]$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

rac1-rac2.txt

7.85 KB, 下载次数: 1128

分享0

收藏0 回复只看该作者道具举报

Mille

10^#

发表于 2013-12-16 11:55:33

Liu Maclean(刘相兵发表于 2013-12-16 11:07
root@RAC_01[/]svmon -G -O unit=MB
Unit: MB
--------------------------------------------------------- ...

谢谢刘大！

把maxperm%
maxclient% 都改为50 之前是90
free 就升了

回复只看该作者道具举报

Mille

9^#

发表于 2013-12-16 11:55:05

谢谢刘大！

把maxperm%
maxclient% 都改为50 之前是90
free 就升了

回复只看该作者道具举报

Liu Maclean(刘相兵

8^#

发表于 2013-12-16 11:07:36

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 一般是文件缓存，我觉得你没必要纠结该问题

回复只看该作者道具举报

Mille

7^#

发表于 2013-12-16 11:03:51

Liu Maclean(刘相兵发表于 2013-12-16 10:07
root@RAC_01[/]svmon -U oracle -O unit=MB
Unit: MB
================================================== ...

grid 也差不多，那到底什么什么占完了？

回复只看该作者道具举报

Mille

6^#

发表于 2013-12-16 11:01:35

Liu Maclean(刘相兵发表于 2013-12-16 10:07
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(刘相兵

5^#

发表于 2013-12-16 10:07:54

svmon -U grid
也看一下

回复只看该作者道具举报

Liu Maclean(刘相兵

4^#

发表于 2013-12-16 10:07:37

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用户吃掉的

回复只看该作者道具举报

Mille

3^#

发表于 2013-12-16 09:28:40

Liu Maclean(刘相兵发表于 2013-12-14 16:20
给出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

回复只看该作者道具举报

Liu Maclean(刘相兵

2^#

发表于 2013-12-14 16:20:20

给出2个节点的 svmon -G -O unit=MB

和 svmon -U oracle -O unit=MB

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册