オラクルのためのOSチューニング

オラクルのためのOSチューニング

  • Introduction
  • Hardware Architectures and Linux Kernels

General
32-bit Architecture and the hugemem Kernel
64-bit Architecture

  • Kernel Upgrades
  • Kernel Boot Parameters

General
I/O Scheduler

  • Memory Usage and Page Cache

Checking Memory Usage
Tuning Page Cache

  • Swap Space

General
Swap Size Recommendations
Checking Swap Space Size and Usage

  • Setting Shared Memory

Setting SHMMAX Parameter
Setting SHMMNI Parameter
Setting SHMALL Parameter
Removing Shared Memory

  • Setting Semaphores

The SEMMSL Parameter
The SEMMNI Parameter
The SEMMNS Parameter
The SEMOPM Parameter
Setting Semaphore Parameters
Example for Semaphore Settings

  • Setting File Handles
  • Adjusting Network Settings

Changing Network Adapter Settings
Changing Network Kernel Settings
Flow Control for e1000 NICs

  • Setting Shell Limits for the Oracle User

Limiting Maximum Number of Open File Descriptors for the Oracle User
Limiting Maximum Number of Processes for the Oracle User

  • Enabling Asynchronous I/O Support

Relinking Oracle9i R2 to Enable Asynchronous I/O Support
Relinking Oracle 10g to Enable Asynchronous I/O Support
Enabling Asynchronous I/O in Oracle 9i and 10g
Tuning Asynchronous I/O for Oracle 9i and 10g
Checking Asynchronous I/O Usage

基礎
RAWとは
オラクルDBでRAWを利用する
RHEL4と10gR2の場合ブロックデバイスを利用する

  • Large Memory Optimization (Big Pages, Huge Pages)

Big Pages in RHEL 2.1 and Huge Pages in RHEL 3/4
Usage of Big Pages and Huge Pages in Oracle 9i and 10g
Sizing Big Pages and Huge Pages
Checking Shared Memory Before Starting Oracle Databases
Configuring Big Pages in RHEL 2.1
Configuring Huge Pages in RHEL 3
Configuring Huge Pages in RHEL 4
Huge Pages and Shared Memory Filesystem in RHEL 3/4

  • Growing the Oracle SGA to 2.7 GB in x86 RHEL 2.1 Without VLM

General
Linux Memory Layout
Increasing Space for the SGA in RHEL 2.1
Lowering the Mapped Base Address for Shared Libraries in RHEL 2.1
Lowering the SGA Attach Address for Shared Memory Segments in Oracle 9i
Allowing the Oracle User to Change the Mapped Base Address for Shared Libraries

  • Growing the Oracle SGA to 2.7/3.42 GB in x86 RHEL 3/4 Without VLM

General
Mapped Base Address for Shared Libraries in RHEL 3 and RHEL 4
Oracle 10g SGA Sizes in RHEL 3 and RHEL 4
Lowering the SGA Attach Address in Oracle 10g

  • Using Very Large Memory (VLM)

General
Configuring Very Large Memory (VLM)

  • Measuring I/O Performance on Linux for Oracle Databases

General
Using Orion

  • Appendix
  • References

See Also OS Tuning for Oracle