Red Hat LINUX ADVANCED SERVER 2.1 - Informations techniques télécharger pdf (Page 12)

Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux

Advanced Server

TUNING OF RED HAT LINUX ADVANCED SERVER FOR ORACLE

In this section, tuning of various Red Hat Advanced Server 2.1 kernel parameters is

explained. Many of the parameters related to the new features introduced in the

Red Hat Advanced Server are discussed. The significance of these kernel

parameters to Oracle and the range of workable values that could be set are

detailed.

It is suggested that those parameters that require to be set at every boot be saved in

/etc/rc.local. The same parameters could also be set in /etc/sysctl.conf, but the

syntax is different.

Swap:

It is recommended that the minimum swap size be atleast the same as physical

memory size.

File handles:

The recommendation for minimum value of File Handles is 65536. It could be set

using ulimit -n or /proc/sys/fs/file-max. It could be set to higher values as needed.

echo "65536" > /proc/sys/fs/file-max

ulimit -n 65536

Shared memory:

SHMMAX: This parameter sets the largest shared memory segment size allowed by

the kernel, in bytes. Default value for this parameter is 33554432. With this value,

database creation may fail. Therefore it is advisable to increase the value of

SHMMAX, such that, Oracle will allocate the SGA in one segment.

For a system with 4 GB RAM, the suggested value of SHMMAX is 2 GB.

Maximum value of SHMMAX that could be set is 4 GB - 1.

echo "2147483648" > /proc/sys/kernel/shmmax

SHMMNI: This parameter sets the maximum number of shared memory segments

for the whole system.

echo "4096" > /proc/sys/kernel/shmmni

SHMALL: This parameter sets the total amount of shared memory that can be used

at one time on the system, in bytes.

echo "2097152" > /proc/sys/kernel/shmall

Tips and Techniques: Install and Configure Oracle9i on Red Hat Linux Advanced Server Page 12

1 2 ... 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Pas de commentaire

Red Hat LINUX ADVANCED SERVER 2.1 - Informations techniques Page 12