Skip to main content

Techdocs Library > White papers >

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



Document Author:

Rebecca Ballough


Document ID:

WP101720


Doc. Organization:

Advanced Technical Sales


Document Revised:

07/19/2010


Product(s) covered:

AIX; AIX 5L; IBM eServer p5; Oracle; Oracle RAC; Oracle Applications; Oracle Database; Oracle RDBMS; Oracle9i Real Application Clusters (RAC); Power4; Power5; pSeries; pSeries Server







Abstract: 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.

Diagnosing_Performance_NMON&Statspack_v2.pdf



Classification:

Solutions

Category:

Performance

Solution(s):

Business Intelligence; Enterprise Application Solutions (EAS/ERP); ISV Applications

ISV(s):

Oracle

Platform(s):

IBM System p Family

S/W Pillar(s):

Information Management

O/S:

AIX

Keywords:

Statspack, NMON, performance, oracle, aix, analysis, tuning, database, 10g, 9i, rac, real application clusters


The Techdocs Library
Is this your first visit to Techdocs (the Technical Sales Library)?

Learn more


Techdocs QuickSearch

: