|
 |
Tuning IBM AIX 5.3 and AIX 6.1 for Oracle Database
|
|
|
© Copyright IBM Corporation, 2008. All Rights Reserved.
All trademarks or registered trademarks mentioned herein are the property of their respective holders.
|
|
Find out about performance analysis and tuning for Oracle workloads on IBM AIX 5.3 and IBM AIX 6.1 configurations on IBM POWER systems when running an Oracle database (including simultaneous multithreading [SMT] and IBM Micro-Partitioning technology). You will learn how best to exploit the specific performance features of AIX 5.3 and AIX 6.1. |
 |
|
| |
In this paper, the required operating-system tuning tasks are grouped into three sections: processor, memory and I/O tuning. Fine-grained tuning is important and valuable, although this level of tuning can lead to problems if not used correctly. Each of these is discussed in detail. The reader will come to understand that performance tuning involves trade-offs that might favor one environment, while hurting another. Therefore, the paper also explains the importance of applying tuning changes one at a time, while monitoring system throughput to determine if the alteration is beneficial for the environment. This paper covers tuning on IBM® POWER5, IBM POWER5+ and IBM POWER6 systems. For convenience, these will be collectively referred to as IBM POWER systems and their processors will be referred to as IBM POWER processors in this paper. Except when needing to distinguish between IBM AIX® 5.3 and AIX 6.1 these AIX operating systems will be referred to collectively as AIX. Note: Oracle Database generic-tuning concepts are widely available and are usually independent of the system and hardware. These concepts are not discussed in this paper. |
|
|
|
|
|
