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

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

    1000662
      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/