Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview

What's New in Version 9i

Oracle Advanced Event Tests

Oracle Performance Manager

Oracle Capacity Planner

Oracle Trace Data Viewer

Oracle TopSessions Charts

Typical Scenario for Using the Diagnostics Pack

System Monitoring and Problem Detection

Diagnosing the Cause of the Problem

Examining the Current State of the System

Investigating Resource Usage

Identifying Problem Sessions

Identifying High Impact SQL

Analyzing Past Information

Correcting the Problem

Microsoft SQL Server Support

2 Post-Installation Configuration

Setting Up Advanced Events

Setting Up Capacity Planner and Performance Manager

Configuring Pre-9i Databases to Use Performance Reporting in Capacity Planner

Configuring Oracle Intelligent Agent to Collect Data

Enabling Disk Statistics Collection on Windows NT

Converting User-Defined Charts From Previous Releases of Performance Manager

Converting Performance Manager Release 1.5.0 User-Defined Charts

Converting Performance Manager Release 1.6.0 User-Defined Charts

Using Performance Manager in a Parallel Server Environment

Obtaining Trace Data for Use in Trace Data Viewer

3 Introduction to Oracle Performance Manager

Accessing Performance Data Through an Intermediate Host

Usage Scenarios for Oracle Performance Manager

Starting Oracle Performance Manager

Starting Oracle Performance Manager from the Console

Starting Oracle Performance Manager from the UNIX Command Line

Starting Oracle Performance Manager from the Start Menu in Windows NT

Running Performance Manager in Enterprise Mode

Running Performance Manager in Standalone Mode

Using the Oracle Performance Manager Main Window

Connecting to a Discovered Target in Enterprise Mode

Manually Connecting to a Target

Viewing Performance Manager Charts

Monitoring Multiple Targets Concurrently

Viewing Chart Groups

Selecting Collected Data and Data Sources

Using the Chart Display Window

Selecting a Chart Format

Setting the Chart Refresh Rate

Pausing and Restarting a Chart

Selecting Chart Options

Chart-Specific Commands

Drilling Down from One Chart to Another

Using the Chart Status Button

Drilling Down to an Historical Chart

Displaying Alternate Chart Orientations

Sorting Data in a Table Chart

Saving Your Changes to a Chart

Obtaining Help for a Class, Chart, or Data Item

Printing a Chart

Generating a Report for a Chart

Recording Chart Data

Starting a Recording

Stopping a Recording

Playing a Recording

Removing a Recording

Creating a User-Defined Chart

Modifying an Existing User-Defined Chart

Modifying the Data Items for a User-Defined Chart

Copying a User-Defined Chart

Converting Old Performance Manager User-Defined Charts

Chart Display Window Menu Shortcut Keys

Working With Events and Thresholds in Performance Manager

Triggered Events and Thresholds

Events Registered for Multiple Targets

Metrics with Multiple Events and Different Thresholds

Event Permissions

Registering Events in Performance Manager

About Oracle 9i and Pre-9i Agents

Viewing Thresholds

Resetting Thresholds

Refreshing Thresholds

Editing Threshold Associations

Running Performance Manager in a Browser

Viewing Metric and Event Documentation Through a Browser

4 Introduction to Oracle Capacity Planner

How Capacity Planner Collects and Stores Performance Data

Accessing Historical Data Through an Intermediate Host

Usage Scenarios for Oracle Capacity Planner

Starting Oracle Capacity Planner

Using Help

Using Oracle Capacity Planner

Setting Up a Collection

Selecting Targets

Selecting Targets on Discovered Nodes

Selecting Targets on Undiscovered Nodes

About the Target Property Sheet

Defining the Frequency of Collection Samples

Defining the Location of the Historical Database

Defining the Frequency of Loading Collection Data

Understanding When the Loader Runs

Understanding How Data Aggregation Works

Defining the Amount of Data to Keep

Applying and Reverting the Collection Settings for a Target

Selecting the Classes of Data to Collect

Starting Data Collection

Stopping Data Collection

Generating a Collection Report

Copying Collection Settings

Creating a User-Defined Class

Designating a Data Item as the Data Source for a User-Defined Class

Removing, Modifying, and Adding Data Items in a User-Defined Class

Modifying User-Defined Classes

Creating a User-Defined Class Like an Existing User-Defined Class

Starting Data Collection for a User-Defined Class

Deleting a User-Defined Class

Troubleshooting Collection and Load Problems

Collecting Data for Diagnostic Reporting

Scope of the Oracle Recommended Collection

Collecting for Performance Reporting

Analyzing Collected Data

Connecting to an Oracle Capacity Planner Historical Database

Organization of Data in the Navigator

Browsing the Collected Data

Viewing an Analysis for a Class of Data

Saving a Class Analysis as a User-Defined Analysis

Specifying Selection Criteria for a Class of Data

Viewing and Modifying User-Defined and Predefined Analyses

Creating a Copy of an Analysis

Renaming a User-Defined Analysis

Deleting a User-Defined Analysis

Working with Analyses

Viewing the Value of a Data Point

Selecting a Line

Adding a Class of Data to an Analysis

Modifying Selection Criteria from the Analysis Window

Removing a Line from a Chart

Excluding a Data Point from a Chart

Showing or Hiding the Chart Legend

Zooming and Scrolling to View More or Less Chart Data

Auto-Scaling Data

What Is a Trend Analysis?

Specifying and Performing a Trend Analysis

Saving Changes to a User-Defined or Predefined Analysis

Saving the Results of a User-Defined Analysis

Saving the Results of a Predefined Analysis

Printing an Analysis Chart

Generating a Report for an Analysis Chart

Understanding the Oracle Capacity Planner Historical Database

Understanding the Service Reference Table (vp_service_ref)

Understanding the Class Reference Table (vp_class_ref)

Understanding the Data Tables

Data Table Names

Data Table Contents

5 Oracle e-Business Management Tools

Monitoring Features of the HTTP Servers

Discovering the HTTP Server

Real-Time Monitoring of the HTTP Server

Reporting of HTTP Server Activity

Log Analysis Report Job Task

Contents of Apache Server Access Log Traffic Report

Charts and Chart Groups

Performance Overview Class

I/O Class

Server Utilization Class

6 Using Oracle TopSessions

Overview of Oracle TopSessions

Before You Use the Oracle TopSessions Chart

Displaying the TopSessions Chart

Displaying the TopSessions Chart from the Console

Starting TopSessions from the Start Menu

Displaying TopSessions in Performance Manager

Oracle TopSessions Menu Bar

File Menu

View Menu

Collection Menu

Drilldown Menu

Help Menu

Toolbar

Print Screen

Report Chart

Chart Type

Horizontal Orientation

Vertical Orientation

Refresh Rate

Pause Chart

Resume Chart

Options

Historical Data

Start Recording

Stop Recording

Help on Chart

Overview of Session Activity

Using the Right Mouse Button on the Main Display

Sorting the Order of Entries in the Chart

Using the Chart Status Button

Viewing Details About a Given Session

Session Details Page

Session Details Statistics Page

Customizing the Session Information You Display

Data Options Page

Data Sources

Select Collected Data

Session Filtering Options Page

Creating a Customized TopSessions Collection

Options Page

7 Using Oracle Trace Data Viewer

Overview

Usage Scenarios for Data Viewer

Starting Data Viewer

Starting Data Viewer from Oracle Enterprise Manager

Starting Data Viewer from the Start Menu

Using Data Viewer

Computing Statistics - Preparing Data for Fast Access and Analysis

Displaying Data Views

Accessing the Definition of a Data View

Viewing Data in a Data View

Creating Custom Data Views

Modifying or Extending Data Views

Drill-Down of Data Views

Selecting a Drill-Down Data View

Modifying Drill-Down Data Views

Saving As Data Views and Files

Printing Data Views

Using the Data View Wizard

Choosing an Event

Choosing Items Associated with the Selected Event

Choosing the Sort Criteria

Defining the Number of Rows to Display

Reviewing the Summary Page

Data Viewer Problems

Could Not View Oracle Trace Formatted Data

Need to Restore Formatted Data

Additional Formatted Data Is Missing from Data Viewer

Poor Performance

Table or View Does Not Exist (or No Data in Collection)

Isolating an Oracle Trace Problem

Isolating a Problem in Oracle Trace Collection Services

Oracle Trace Command-Line Interface

Oracle7 Stored Procedures

EPC_ERROR.LOG File

Information Needed When Reporting a Problem

A Using Advanced Event Tests Effectively

Operational Management

Problem

Action

Resolution

Space Management

Problem

Action

Resolution

Performance Tuning

Problem

Action

Resolution

Index