White Papers
IBM Solutions Technical Brief: Diagnosing Oracle Database Performance on AIX Using IBM NMON and Oracle Statspack Reports
Category: Data Management, Servers and Server OS
Tags: server, applications, data
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.
- Publisher
- IBM
- File Format
- Date Published
- Apr 30, 2008
- Format
- White Papers
- Topics
- AIX, Database Management
Similiar White Papers
Oracle Database 10g R2 and Oracle RAC 10g R2 on IBM AIX: Tips and Considerations
There are many technical topics to consider when running Oracle Database 10gR2 and Oracle RAC 10gR2 on AIX such as certi
Oracle Database 11g and Oracle RAC 11g on IBM AIX
There are many technical topics to consider when running Oracle Database 11g and Oracle RAC 11g on AIX such as certifica
Oracle Real Application Clusters 10g Release 2 With AIX 5L Version 5.3 and NetApp Storage
This paper covers the installation of NetApp storage in a NFS environment for IBM AIX 5L on IBM System p5 550Q, model 91
Publisher: Network Appliance (NetApp) | Tags: database, network
Implementing Oracle 10g RAC With ASM on AIX
Prior to the release of Oracle Database Server 10g, database administrators had to choose between raw logical volumes or
Oracle 9i RAC Deployment on AIX Using VERITAS Storage Foundation for Oracle RAC 4.0 as Clusterware
VERITAS Storage Foundation for Oracle Real Application Clusters (SFRAC) provides an enabling clusterware on which to run
Publisher: IBM
IBM White Papers
Integrated Change & Release Management
Short deadlines and constant change epitomize the challenges of software and systems development. Routine change increas
Webcast: Introducing IBM Lotus Quickr -- The Fastest Way to Share Content with Your Teams
Have you heard the buzz about Lotus Quickr? Lotus Quickr is IBM's new Web 2.0-based team collaboration software that is
Publisher: IBM | Tags: collaboration software, software
An examination of server consolidation: the trends that can drive efficiencies and help businesses gain a competitive edge
This white paper provides a starting point for organizations contemplating server consolidation. It includes an overview
Publisher: IBM | Tags: cost savings, server
Build Strong, Flexible J2EE apps With a WebSphere Cluster Environment
When building a strong, extensible, and flexible J2EE application, one needs to consider several factors. One important
Publisher: IBM | Tags: application server, management, server
Deploying Oracle ASM With Oracle 10g RAC on AIX With IBM System Storage DS8000 and DS6000 Advanced Features
The IBM System Storage DS8000 and DS6000 Disk Storage systems are both high performance storage systems that offer expan
Featured white papers
-
The Value of Location Intelligence in the Communications Industry
Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...
-
Best Practices for Translating Customer Satisfaction into Revenue
Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...
-
HP print solutions and 3M
The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...
-
Check out these top business apps for your iPhone
-
Inside a Microsoft datacentre
-
Green IT without losing your edge
-
Peter Cochrane's latest video blog
-
What you need to know about Windows 7