Prev | Current Page 561 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

The voting disk is used by Oracle??™s clustering software,
Cluster Ready Services (CRS), to arbitrate ownership of the cluster in case of a private network
failure. The OCR disk is used to maintain all metadata about the cluster: the cluster configuration
and the cluster database configuration.
Kernel Parameters
Most of the ???out of the box??? kernel parameters are set correctly for Oracle except a few; ensure
that the kernel parameters in Table 10-2 are set to the values provided in the table.
NOTE
For 64-bit platforms, if your SGA will be larger than 2GB, the value
for kernel.shmall should be at least as large as the value of the
initialization parameter SGA_MAX_SIZE.
Chapter 10: Real Application Clusters 355
You can confirm that these values are in effect using the following command:
[root@oc1 ~]# /sbin/sysctl -a |
egrep 'sem|shm|file-max|ip_local|rmem|wmem'
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 262144
vm.hugetlb_shm_group = 0
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 2147483648
fs.file-max = 65536
[root@oc1 ~]#
In a default Oracle Enterprise Linux installation, some of these parameters are already set. For
those values that vary from Table 10-2, simply append the parameter name and the value from
the previous sample output to the file /etc/sysctl.


Pages:
549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573
zalew sulejowski koszule korporacyjne Skimboard remont warszawa terapia magnetyczna