IBM POWER7 AIX and Oracle Database performance considerations


This post is intended to provide DBA's with advice and website links to assist with IBM Power Systems running in an Oracle environment.
Most issues that show up on POWER7 are the result of not following best practices advice that applies to all Power Systems generations.

Metalink: IBM POWER7 AIX and Oracle Database performance considerations -- 10g & 11g (Doc ID 1507249.1)

IBM White paper: IBM POWER7 AIX and Oracle Database performance considerations


Why Use Parallel Processing?

This demonstration compares the use of parallel and serial processing for the same SQL query.
This demonstration is associated with lessons 2 and 3 of the Oracle University seminar: Parallel Processing in Oracle 11g.

Enjoy


Oracle Architecture (9i,10g,11g) and Tuning on AIX (5.3,6.1,7.1)

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 focused on the AIX versions 5.3, 6.1, 7.1 and Oracle 9i, 10g and 11g.

This paper begins with a short descript ion 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. Addit ional informationon 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.

See link below..
Oracle Architecture and Tuning on AIX (v 2.10)
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100883
Enjoy..

Cluster Health Monitor (CHM)

Oracle is strongly encouraging the admins of Clusterware / RAC using the CHM (Cluster Health Monitor).
This tool (formerly known as Instantaneous Problem Detector for Clusters or IPD/OS) is designed to detect and analyze operating system (OS) and cluster resource related degradation and failures in order to bring more explanatory power to many issues that occur in clusters where Oracle Clusterware and Oracle RAC are running such as node eviction. It tracks the OS resource consumption at each node, process, and device level continuously. It collects and analyzes the cluster-wide data. In real time mode, when thresholds are hit, an alert is shown to the operator. For root cause analysis, historical data can be replayed to understand what was happening at the time of failure.

See this presentation on this issue on link below

Introduction
– What is? Why use? Where to get?
Cluster Health Monitor (CHM)
• Installation
– Of the Tool
– Of the GUI
• CHM in Action
• Administration
• FAQ & More Information
– OTN Migration

Everything_you_ever_wanted_to_know_about_CHM

Enjoy…


Oracle Real Application Clusters on IBM AIX Best practices in memory tuning and configuring for system stability

Introduction

Customers who experience Oracle Real Application Clusters (RAC) node evictions due to excessive AIX kernel paging should carefully review and implement these recommended best practices. Testing and experience have found that memory over commitments may cause scheduling delays for Oracle’s ‘oprocd’ process resulting in node evictions.
Implementing all of these recommendations will reduce scheduling delays and corresponding oprocd initiated evictions.

Problem validation

This paper addresses the best practices for environments experience node evictions caused bycritical processes not being able to get scheduled in a timely fashion on AIX due to memory overcommitment. To validate that node evections are caused by this situation, the followingvalidation steps should be taken.

Click link below…

rac_aix_memory_tuning October 17 2011

Enjoy


RMAN Performance Tuning / Notes – My Oracle Support (Metalink)

I’ll post here useful notes from MOS about the RMAN Performance and Tuning.

To view these documents you must have access to the MOS.

 

RMAN Myths Dispelled: Common RMAN Performance Misconceptions [ID 134214.1]

This document will help dispel some of the common misconceptions related to proper usage of Recovery Manager (RMAN).

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=134214.1

 

 

RMAN Restore Database Slow / How To Improve RMAN Restore Performance [ID 467694.1]

Goal: RMAN Restore database is slow.  Backup to tape takes 13 hours and the restore takes over 26hrs.

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=HOWTO&id=467694.1

 

Advise On How To Improve Rman Performance [ID 579158.1]

Goal: How  to boost RMAN performance ?

Also is a recommended for improving RMAN performance on AIX5L based system. IBM suggestions the AIX related advices

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=HOWTO&id=579158.1

 

RMAN Performance Tuning Diagnostics [ID 311068.1]

Provide diagnostic reference for collecting RMAN backup performance diagnostic information.

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=TROUBLESHOOTING&id=311068.1

 

RMAN Performance Tuning Using Buffer Memory Parameters [ID 1072545.1]

The purpose of RMAN performance tuning is to identify the bottlenecks for a given backup or restore job and use RMAN commands, initialization parameters, or adjustments to physical media to improve overall performance.

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=1072545.1

 

 

RMAN: Monitoring Recovery Manager Jobs [ID 144640.1]

To inform all the Oracle Recovery Manager Documentation has the information to resolve most problems.

All RMAN users should review the RMAN Troubleshooting section of the online documentation provided.

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=144640.1

 


Diagnosing Oracle Database Performance on AIX Using NMON and Oracle Statspack Reports

For Oracle Database environments, ongoing performance monitoring and tuning activities are essential to getting the most of your systems investment. In order to be most effective, monitoring and tuning must be performed at multiple levels of the solution stack.

This includes the hardware, Operating System, Database and Application levels.

This paper discusses two commonly available performance monitoring tools – Oracle Statspack and IBM NMON – and how they can be used to monitor and analyze possible performance issues for Oracle Database applications running in an AIX/System p™ server environment. In Oracle10g environments, Automatic Workload Repository (AWR) reports can be used in place of Statspack.

A number of real-world examples of Statspack and NMON data are provided.

This paper assumes that the reader is familiar with Oracle Database as well as the AIX/System p server environment.

Click link below..

Diagnosing_Performance_NMON&Statspack_v2

Enjoy