This discussion is archived
1 Reply Latest reply: Apr 3, 2013 1:15 AM by LiuMaclean(刘相兵) RSS

想使用linux的 huge_page提升数据库的性能,但是遇到问题

1000662 Newbie
Currently Being Moderated
1)OS:RHEL
2)uname:Linux faqtestdb 2.6.18-274.el5 #1 SMP Fri Jul 8 17:36:59 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
3)DB:oracle10.2.0.5
4)ulimit:

[root@faqtestdb ~]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 16384
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 16384
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@faqtestdb ~]# su - oracle
[oracle@faqtestdb ~]$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 16384
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 65536
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 16384
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

5)

[oracle@faqtestdb ~]$ ipcs -m

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0xd6d54844 4390913 oracle 640 996147200 16


6)[oracle@faqtestdb ~]$ grep Huge /proc/meminfo
HugePages_Total: 476
HugePages_Free: 476
HugePages_Rsvd: 0
Hugepagesize: 2048 kB
7)[oracle@faqtestdb ~]$ grep huge /etc/sysctl.conf
vm.nr_hugepages=476


我想用使用linux的 huge_page提升数据库的性能,但是遇到问题

---重启OS和数据库以后发现/proc/meminfo中的HugePages_Free没有变化,是否说明oracle还是没用到huge_page
---怎么能证明关于HugePages的设置生效了
---是不是什么原因导致我的设置没有生效

我参考的文档

官方文档:HugePages on Linux: What It Is... and What It Is Not... [ID 361323.1]
参考文档:http://foxmile.blog.163.com/blog/static/81169805201141335438177/

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points