Download Red Hat ENTERPRISE LINUX AS 2.1 - Installation guide

I. Tuning and Optimizing Red Hat Enterprise Linux for Oracle Database 9i and 10g
1
1. Introduction
3
2. Hardware Architectures and Linux Kernels
2.1. General ...............................................................................................................
2.2. 32 bit Architecture and the hugemem Kernel ..........................................................
2.3. The 64 bit Architecture .........................................................................................
5
5
5
6
3. Kernel Upgrades
7
4. Kernel Boot Parameters
9
4.1. General ............................................................................................................... 9
4.2. The I/O Scheduler ................................................................................................ 9
5. Memory Usage and Page Cache
11
5.1. Checking the Memory Usage .............................................................................. 11
5.2. Tuning the Page Cache ...................................................................................... 11
6. Swap Space
13
6.1. General .............................................................................................................. 13
6.2. Checking Swap Space Size and Usage ............................................................... 14
7. Setting Shared Memory
7.1. Setting SHMMAX Parameter ..............................................................................
7.2. Setting SHMMNI Parameter ................................................................................
7.3. Setting SHMALL Parameter ................................................................................
7.4. Removing Shared Memory ..................................................................................
15
15
16
16
17
8. Setting Semaphores
8.1. The SEMMSL Parameter ....................................................................................
8.2. The SEMMNI Parameter .....................................................................................
8.3. The SEMMNS Parameter ...................................................................................
8.4. The SEMOPM Parameter ...................................................................................
8.5. Setting Semaphore Parameters ...........................................................................
8.6. An Example of Semaphore Settings ....................................................................
19
19
19
19
20
20
20
9. Setting File Handles
23
10. Adjusting Network Settings
10.1. Changing Network Adapter Settings ..................................................................
10.2. Changing Network Kernel Settings ....................................................................
10.3. Flow Control for e1000 Network Interface Cards .................................................
25
25
25
26
11. Setting Shell Limits for the Oracle User
27
11.1. Limiting Maximum Number of Open File Descriptors for the Oracle User ............... 27
11.2. Limiting Maximum Number of Processes Available for the Oracle User ................. 28
12. Enabling Asynchronous I/O and Direct I/O Support
12.1. Relinking Oracle9i R2 to Enable Asynchronous I/O Support .................................
12.2. Relinking Oracle 10g to Enable Asynchronous I/O Support ..................................
12.3. Enabling Asynchronous I/O in Oracle 9i and 10g ................................................
12.4. Tuning Asynchronous I/O for Oracle 9i and 10g ..................................................
12.5. Verifying Asynchronous I/O Usage .....................................................................
31
31
32
32
33
34
13. Configuring I/O for Raw Partitions
37
13.1. General ............................................................................................................ 37
13.2. Basics of Raw Devices ..................................................................................... 38
iii