オラクルのための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