Oracle Architecture and Tuning on AIX v2.30

Abstract:This paper is intended for IBM Power Systems customers, IBM Technical Sales Specialists and consultants who are interested in learning more about the requirements involved in building and tuning an Oracle RDBMS system for optimal performance on 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 focused on AIX versions 5.3, 6.1, 7.1 and Oracle 9i, 10g, 11g.

It 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 the Appendix 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.