Advanced Technical Sales
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.
Business Intelligence; Enterprise Application Solutions (EAS/ERP); ISV Applications
IBM System p Family
Statspack, NMON, performance, oracle, aix, analysis, tuning, database, 10g, 9i, rac, real application clusters
|Is this your first visit to Techdocs (the Technical Sales Library)?