Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview

What's New in Oracle Standard Management Pack for Release 9i

Oracle Performance Manager

Oracle Index Tuning Wizard

Oracle Change Manager

Create Baseline

Compare Database Objects

Oracle TopSessions

2 Post-Installation Configuration

Setting Up Performance Manager

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

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 Index Tuning Wizard

When to Use the Index Tuning Wizard

Accessing the Index Tuning Wizard

Index Tuning Wizard Interface

Application Type

Schema Selection

Index Recommendations

Analysis Report and Script

Finish

5 Overview of the Change Management Applications

New Features for the Change Management Applications

Database Objects Supported by the Change Management Applications

Understanding Change Management Objects

Change Management Applications

Overview of Change Manager

Overview of Create Baseline

Capturing a Baseline from the Oracle Enterprise Manager Console

Overview of Compare Database Objects

Performing a Comparison from the Oracle Enterprise Manager Console

Sample Uses for the Change Management Applications

Using Help

Displaying the Contents Page for Help

Displaying a Help Topic for Your Current Context in an Application

Finding a Particular Type of Help Topic

6 Using Change Manager

Running Change Manager Connected to an Oracle Management Server or Standalone

Creating a Standalone Repository for Change Management Applications

Changing Your Standalone Change Management Repository

Starting Change Manager

Using the Change Manager Main Window

Starting Change Management Applications from Change Manager

Working with Baselines

Working with Comparisons

Viewing History Entries for Tasks

Viewing Completed Tasks

Working With a Particular Version of a Baseline or Comparison

Exporting and Importing Baselines and Comparisons

7 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

A Troubleshooting Appendix

Using Environment Variables When Running Change Manager from the Command Line

Enabling Tracing and Debugging for Change Management Applications

Index