linux上Oracle的sga(HugePages)分配問題
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
下面的現象：
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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【TUNE_ORACLE】Oracle資料庫與HugePages（三）HugePages常見問題和解決辦法Oracle資料庫
- [20191202]關於oracle例項是否使用hugepages問題.txtOracle
- [20191129]關於hugepages的問題.txt
- HugePages on LinuxLinux
- [20191204]關於oracle例項是否使用hugepages問題2.txtOracle
- 關於32位oracle擴充套件SGA的一些問題Oracle套件
- [20221125]設定hugepages遇到的問題.txt
- 【TUNE_ORACLE】Oracle資料庫與HugePages（二）HugePages配置和限制Oracle資料庫
- [20210528]oracle大表空間預分配問題.txtOracle
- 【TUNE_ORACLE】Oracle資料庫與HugePages（一）HugePages概念和優勢Oracle資料庫
- [20191202]關於hugepages相關問題.txt
- 無題號 分配問題 題解
- [20221212]關於pre_page_sga引數的問題.txt
- ordebug 手動修改Oracle sga scnOracle
- [20181229]關於字串的分配問題.txt字串
- linux處理oracle問題常用命令LinuxOracle
- xshell連線不上linux問題Linux
- Kubernetes EKS 叢集中的 IP 地址分配問題
- [20190409]pre_page_sga=true與連線緩慢的問題.txt
- 記憶體分配問題處理記憶體
- [20190103]設定pre_page_sga=true啟動緩慢的問題.txt
- JVM的棧上分配JVM
- 【TUNE_ORACLE】Oracle資料庫與HugePages（四）如何禁用透明大頁Oracle資料庫
- oracle undo分配規則Oracle
- Oracle trigger問題Oracle
- Oracle Exadata與SGA快取記憶體CQOracle快取記憶體
- 一次Oracle診斷案例-SGA與SwapOracle
- Oracle Rac 修改SGA_TARGET值無變化Oracle
- linux遇到的問題Linux
- [20190102]關於字串的分配問題(10g).txt字串
- How to disable transparent hugepages (THP) on Red Hat Enterprise Linux 7Linux
- Oracle的SCN顯示問題Oracle
- Django在Linux上uwsgi 與nginx的問題與解決DjangoLinuxNginx
- oracle SGA區基礎知識與檢視命令Oracle
- Oracle常用傻瓜問題1000問Oracle
- Oracle記憶體結構(一)----SGA的區域資訊(轉)Oracle記憶體
- 【ASK_ORACLE】LOCK_SGA引數失效的解決辦法Oracle
- WINDOWS平臺上擴充套件SGA (zt)Windows套件
- Oracle的時區問題Time ZoneOracle