Oracle Architecture and Tuning on AIX

Overview

This paper contains best practices that have been collected during the extensive period of time that the authors team colleagues and the author have spent working in the Oracle RDBMS based environment. Current version is primarily focused on the AIX versions 5.2 & 5.3 and Oracle 9i & 10g. This paper provides a short description of the most important Oracle DB architectural elements. It continues with the coverage of the AIX related tuning elements that are the crucial for the optimal DB activity.