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.
The intent of this flash is to document the AIX fixes and Oracle patches that need to be used with the Database Online patching feature. This document is not a guide on how to apply the Oracle patch online.
IBM and Oracle recommend that ALL customers follow the steps mentioned in the Flash “Oracle’s USLA HEAP Patches available on AIX”.
Customers should evaluate the need to install the fix that corrects AIX behavior when the environment variable MPROTEXT_TXT=ON is set, as is required for Oracle Database online patching. Without this fix, JAVA and certain other applications may not start when the environment variable MPROTEXT_TXT=ON is set in the current shell.
APAR IV16716 for AIX 6.1 TL07
APAR IV16737 for AIX 7.1 TL01
If a customer anticipates applying an Oracle patch online, IBM recommends that the customer review Oracle bug number 13494030, which refers to the problem “slow process startup with online patches on AIX”. This describes a possible problem on a system with high rate of connections to Oracle database under relatively loaded environment. The bug can be found at Oracle My Oracle Support website at https://support.oracle.com/CSP/ui/flash.html. Please note that user id and password are required to access My Oracle Support. If an Oracle patch is not available for download, customer may follow normal Oracle support process to request the patch.
Additional information may be found at these websites:
1. My Oracle Support (for the Oracle Certification Matrix)(1) :
(1): A userid and password are required to access that website. This is available for Oracle customers
and Oracle Business Partners. After accessing that website, please refer to Document id # 282036.1
and/or the Certification folder for generic information on AIX.
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 practises which have been collected during the extensive period of time spent working with Oracle RDBMS based environment.
Download the full PDF here.
Oracle Architecture and Tuning on AIX (v 2.20)