RHEL (e OEL) Tuning para Oracle Database
O pacote tuned do Red Hat Enterprise Linux 6 (também disponível no Oracle Enterprise linux 6) é recomendado para um ajuste automático do sistema para cargas específicas: enterprise storage, high network throughput, ou power savings.
Para o Oracle Database, habilite o perfil para enterprise-storage, para ajustes do I/O Scheduler, read-ahead buffers, e limpeza da memória virtual, com valores mais adequados para este tipo de ambiente.
Uma das alterações, que pode ser verificada abaixo, é a troca do I/O Scheduler para o algoritmo deadline, que impõe um limite em todas as operações de I/O, para previnir gargalo de requisições.
[root@nerv01 ~]# yum install tuned
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package tuned.noarch 0:0.2.19-11.el6.1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
tuned noarch 0.2.19-11.el6.1 ol6_latest 91 k
Transaction Summary
================================================================================
Install 1 Package(s)
Total download size: 91 k
Installed size: 217 k
Is this ok [y/N]: y
Downloading Packages:
tuned-0.2.19-11.el6.1.noarch.rpm | 91 kB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : tuned-0.2.19-11.el6.1.noarch 1/1
Verifying : tuned-0.2.19-11.el6.1.noarch 1/1
Installed:
tuned.noarch 0:0.2.19-11.el6.1
Complete!
[root@nerv01 ~]# chkconfig tuned on
[root@nerv01 ~]# tuned-adm profile enterprise-storage
Switching to profile 'enterprise-storage'
Applying ktune sysctl settings:
/etc/ktune.d/tunedadm.conf: [ OK ]
Calling '/etc/ktune.d/tunedadm.sh start': [ OK ]
Applying sysctl settings from /etc/sysctl.conf
Applying deadline elevator: sda [ OK ]
Starting tuned: [ OK ]
[root@nerv01 ~]# cat /etc/ktune.d/tunedadm.conf | grep -v "#"
kernel.sched_min_granularity_ns = 10000000
kernel.sched_wakeup_granularity_ns = 15000000
vm.dirty_ratio = 40
[root@nerv01 ~]#Fonte
