Techdocs Library > White papers > Diagnosing Oracle® Database Performance on AIX® Using IBM® NMON and Oracle Statspack Reports

Document Author:	Dale Martin		Document ID:	WP100880
Doc. Organization:	Advanced Technical Skills		Document Revised:	10/31/2006
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.

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