Diagnosing Oracle Database Performance on AIX Using NMON and Oracle Statspack ReportsPosted: 12/01/2011 | |
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..
- Share on Facebook (Opens in new window)
- Click to share on Twitter (Opens in new window)
- Click to share on Google+ (Opens in new window)
- Click to email (Opens in new window)
- Click to share on Reddit (Opens in new window)
- Click to share on Tumblr (Opens in new window)
- Click to share on Pinterest (Opens in new window)
- Click to print (Opens in new window)