Database Management White Papers

IBM Solutions Technical Brief: Diagnosing Oracle Database Performance on AIX Using IBM NMON and Oracle Statspack Reports

Overview 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.

Further White Paper Details
PublisherIBM File FormatPDF
Date PublishedOctober 2006
FormatWhite Papers   
Topics

Database Consolidation Makes New IT Initiatives Possible

The Issue: The proliferation of databases is Preventing money and staff from being devoted to new IT initiatives.Read this recent AMR Research survey which found that companies are reducing the...

Oracle Database: 11g Standard Edition

Oracle Database 11g Standard Edition is a full-featured data management solution ideally suited to the needs of midsized businesses. It is easy to install on Windows and Linux operating systems, easy...

Oracle Database: 11g Standard Edition ONE

Oracle Database 11g Standard Edition One is a full-featured data management solution ideally suited to the needs of fast-growing businesses. It is easy to install on Windows and Linux operating...

Database Consolidation: Reducing Cost and Complexity

The Bottom Line: Database consolidation projects offer companies the hope of lower costs, greater ease of database administration, and the chance to improve the quality of their database technology by...

Making the Case for Oracle Database on Windows

Read this Ovum Summit paper to see why one of the best-kept secrets in the IT industry is the depth of support Oracle offers to customers deploying its databases on...

  • Featured White Papers
Childnet helps parents get web savvy

Childnet helps parents get web savvy

Case study: Gov't initiative to bridge digital divide more

Travel site bookings fly when glitch fixed

Travel site bookings fly when glitch fixed

Case study: Testing software gives Thomson Holidays a boost more

Cheat Sheet: BBC iPlayer

Cheat Sheet: BBC iPlayer

Get the lowdown on Auntie's biggest online endeavour more


Quick Sitemap Links: