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.
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)
This is a paper from IBM and Sybase to assist database administrators (DBAs) and UNIX system administrators (SAs) working together. This white paper helps these professionals achieve the best possible performance from the Sybase Adaptive Server Enterprise (ASE) on IBM Power Systems running in the IBM AIX operating environment.
The focus of this white paper is on Sybase ASE 15.0.2 through ASE 15.5, running under AIX 5.3, 6.1, and 7.1 on the IBM POWER6 and IBM POWER7 processor-based servers. The recommendations of the original version of this white paper, published in March 2006, applied to IBM AIX 5L logical partitions (LPARs) with dedicated processors, memory, and devices. The 2009 revision of the paper also addressed all relevant aspects of IBM PowerVM including shared-processor LPARs (referred to as IBM Micro-Partitioning) and virtual I/O, features which are only available in the POWER 5, POWER6, and POWER7 processor-based servers with AIX 5.3 or later releases. The current revision of the white paper extends coverage to POWER7, enhancements to virtual I/O, and AIX 7.1 where relevant to ASE. Recent field and lab experience with POWER7 processor-based servers is applied to new or revised best practice recommendations. The recommendations apply to ASE Cluster Edition for AIX except where noted.
Full PDF: Optimizing Sybase Adaptive Server Enterprise(ASE) for IBM AIX