You are here: silicon.com > Resources > White Papers > Data Management > Data Infrastructure > Database Management

Database Management White Papers

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

Tags:
database management

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
Publisher	IBM	File Format	PDF
Date Published	October 2006
Format	White Papers
Topics	Database Management, AIX

Did you find this white paper useful?

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

Publisher:
Oracle

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

Publisher:
Oracle

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

Publisher:
Oracle

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

Publisher:
Oracle

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

Publisher:
Oracle

Tags:
database management

Featured White Papers

Best in Class Organisations Use Packeteers WAN Optimisation Solutions

Independent research from the Aberdeen Group shows that the most successful enterprises are reaping the benefits of the Packeteer solution and are using it for competitive advantage.

Publisher:
Packeteer

Protecting key assets (security)

Key infrastructure elements must be secured against outages, damage and sabotage. Siemens offers comprehensive solutions from healthcare and power generation to water supply, transportation, and industrial production, to telecommunications.

Publisher:
Siemens

Getting Started with Master Data Management

Master data management forms part of an overall enterprise governance program that aims to establish trusted data throughout the enterprise. This white paper from Mike Ferguson of Intelligent Business Strategies defines master data, examines why it is needed, and explores methodologies for implementing master data management.