AIX; AIX 5L; IBM eServer p5; IBM eServer pSeries; IBM System p5; Oracle; Oracle RAC; Oracle Database; Oracle RDBMS; Oracle9i Real Application Clusters (RAC); Power; Power4; Power5; Power 6; pSeries; pSeries 520; pSeries 550; pSeries 570; pSeries 590; pSeries 610; pSeries 615; pSeries 620; pSeries 630; pSeries 640; pSeries 650; pSeries 660; pSeries 670; pSeries 690; pSeries Server; RS/6000
Abstract: This paper is intended for IBM Power Systems customers, IBM Technical Sales Specialists, and consultants who are interested in learning more the requirements involved in building and tuning an Oracle RDBMS system for optimal performance on the AIX platform.
This white paper contains best practices which have been collected during the extensive period of time my team colleagues and I have spent working in the Oracle RDBMS based environment. It is primarily focused on the AIX versions 5.3 & 6.1 and Oracle 9i, 10g and 11g.
This paper begins with a short description of the most important Oracle DB architectural elements. It continues with an overview of the AIX-related tuning elements that are most crucial for optimal DB activity.
This document can be expanded into many different OS or DB-related directions. Additional information on related topics is included in Appendix A of this paper, as well as references to supporting documentation. However, this paper is not focused on the application tuning area. Application performance tuning is a subject too broad to be covered in a white paper of this length.
Additionally, an equally important prerequisite for optimal DB activity is the careful planning of the DB/Storage layout. More information on DB/Storage layout can be found in the Appendix A.
