linux上Oracle的sga(HugePages)分配问题

最新推荐文章于 2021-09-13 15:54:26 发布

cqhiabc50405

最新推荐文章于 2021-09-13 15:54:26 发布

阅读量201

点赞数

文章标签：数据库

Oracle的sga实际占用大小是逐步增大，类似稀疏文件？ipcs -m显示的值代表什么？

下面的现象：
1 HugePages 没用到（应该是memlock设置不对）
2 ipcs  显示活动共享内存段为 68719476736 （bytes），这个值是实际大小吗？
3 free显示内存有46770M没有使用，Swap 0 used，HugePages占了60多G，系统共有内存128G

Sga：

SQL> select sum(bytes)/1024/1024 from v$sgastat;

SUM(BYTES)/1024/1024
--------------------
      65536.0017

[oracle@nod04 ~]$ top

top - 10:27:53 up 2 days,  3:51,  2 users,  load average: 0.08, 0.14, 0.15
Tasks: 523 total, 1 running, 522 sleeping, 0 stopped, 0 zombie
Cpu(s):  0.5% us,  0.1% sy,  0.0% ni, 99.3% id,  0.0% wa,  0.0% hi,  0.0% si
Mem:  132090276k total, 84169508k used, 47920768k free, 109860k buffers
Swap: 131074324k total,       0k used, 131074324k free,  8260692k cached

  PID USER    PR  NI  VIRT  RES  SHR S %CPU %MEM TIME+  COMMAND
29554 oracle 15 0 64.1g 714m 706m S 21.2  0.6 0:27.89 oracle
6435 oracle RT 0 4928m 4.8g  24m S  1.7  3.8  30:44.87 ocssd.bin
7659 oracle 16 0  6572 1484  840 R  0.7  0.0 0:00.12 top
22589 oracle 15 0 64.2g 480m 465m S  0.7  0.4 0:33.75 oracle
22601 oracle 15 0 64.2g 475m 461m S  0.7  0.4 0:31.62 oracle
22613 oracle 15 0 64.2g 477m 463m S  0.7  0.4 0:30.15 oracle
22629 oracle 15 0 64.2g 479m 465m S  0.7  0.4 0:30.00 oracle
28109 oracle 16 0 64.1g 451m 444m S  0.7  0.3 0:08.23 oracle
5351 root    16 0  506m  27m 9512 S  0.3  0.0 1:51.06 crsd.bin
22585 oracle 15 0 64.2g 478m 464m S  0.3  0.4 0:32.51 oracle
22597 oracle 15 0 64.2g 477m 462m S  0.3  0.4 0:30.72 oracle
22605 oracle 15 0 64.2g 471m 456m S  0.3  0.4 0:30.85 oracle
1 root    16 0  4772  564  468 S  0.0  0.0 0:04.43 init
2 root    RT 0    0 0 0 S  0.0  0.0 0:00.20 migration/0
3 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/0
4 root    RT 0    0 0 0 S  0.0  0.0 0:01.28 migration/1
5 root    34  19    0 0 0 S  0.0  0.0 0:00.01 ksoftirqd/1
6 root    RT 0    0 0 0 S  0.0  0.0 0:01.33 migration/2
7 root    34  19    0 0 0 S  0.0  0.0 0:00.01 ksoftirqd/2
8 root    RT 0    0 0 0 S  0.0  0.0 0:01.30 migration/3
9 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/3
10 root    RT 0    0 0 0 S  0.0  0.0 0:00.21 migration/4
11 root    34  19    0 0 0 S  0.0  0.0 0:00.01 ksoftirqd/4
12 root    RT 0    0 0 0 S  0.0  0.0 0:00.04 migration/5
13 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/5
14 root    RT 0    0 0 0 S  0.0  0.0 0:00.02 migration/6
15 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/6
16 root    RT 0    0 0 0 S  0.0  0.0 0:00.00 migration/7
17 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/7
18 root    RT 0    0 0 0 S  0.0  0.0 0:00.00 migration/8
19 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/8
20 root    RT 0    0 0 0 S  0.0  0.0 0:00.00 migration/9
21 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/9
22 root    RT 0    0 0 0 S  0.0  0.0 0:00.00 migration/10
23 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/10
24 root    RT 0    0 0 0 S  0.0  0.0 0:00.00 migration/11
25 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/11

[oracle@nod04 ~]$ cat /etc/security/limits.conf
oracle soft nofile 131072
oracle hard nofile 131072
oracle soft nproc 131072
oracle hard nproc 131072
oracle soft core unlimited
oracle hard core unlimited
oracle soft memlock 50000000
oracle hard memlock 50000000

[oracle@nod04 ~]$
[oracle@nod04 ~]$ free -m
         total    used    free    shared buffers    cached
Mem:       128994    82223    46770       0       107    8079
-/+ buffers/cache:    74037    54957
Swap:    128002       0    128002
[oracle@nod04 ~]$
[oracle@nod04 ~]$ ipcs -m

------ Shared Memory Segments --------
key       shmid    owner    perms    bytes    nattch    status
0x58a04a18 0       oracle 640       337641472  15
0x00000000 98305    oracle 640       68719476736 100
0xc8ea1340 131074    oracle 640       2097152 100

[oracle@nod04 ~]$ cat /proc/meminfo
MemTotal:    132090276 kB
MemFree:    47891392 kB
Buffers:       109872 kB
Cached:       8274096 kB
SwapCached:       0 kB
Active:       9032436 kB
Inactive:    5289840 kB
HighTotal:          0 kB
HighFree:          0 kB
LowTotal:    132090276 kB
LowFree:    47891392 kB
SwapTotal: 131074324 kB
SwapFree:    131074324 kB
Dirty:          132 kB
Writeback:          0 kB
Mapped:    13448620 kB
Slab:          201216 kB
CommitLimit:  162516452 kB
Committed_AS: 75057816 kB
PageTables:    326848 kB
VmallocTotal: 536870911 kB
VmallocUsed: 330404 kB
VmallocChunk: 536540479 kB
HugePages_Total: 33792
HugePages_Free:  33631
Hugepagesize:    2048 kB

[oracle@nod04 ~]$ cat /etc/issue
Enterprise Linux Enterprise Linux AS release 4 (October Update 8)
Kernel \r on an \m

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/758322/viewspace-703945/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/758322/viewspace-703945/