Preface

This section describes the purpose and organization of this guide: the Oracle Enterprise Manager Performance Monitoring User's Guide. Specifically, it covers the following topics:

Purpose of this Guide

This guide describes how to use the optional performance monitoring applications of the Oracle Enterprise Manager. Specifically, these applications are:

Oracle Performance Manager
Oracle Advanced Events
Oracle Lock Manager
Oracle TopSessions
Oracle Tablespace Manager

Information in this guide applies to these performance monitoring applications running on all platforms. When functionality differs among platforms, this guide refers you to your operating system-specific documentation.

Audience

This guide is written for those who wish to use Oracle Performance Manager, Oracle Advanced Events, Oracle Lock Manager, Oracle TopSessions, and Oracle Tablespace Manager to monitor database instance performance.

Knowledge Assumed of the Reader

This guide assumes you are familiar with the performance monitoring tasks you wish to perform. If you are not, refer to the Oracle Server documentation set. The Oracle Server documentation set contains specific and thorough descriptions of these tasks. In addition, the Oracle Server documentation set provides recommendations on how to tune your database optimally based on performance monitoring statistics.

This guide also assumes that you are familiar with the operation of Microsoft Windows. Refer to the Windows documentation for your system, if necessary.

How this Guide is Organized

The Oracle Enterprise Manager Performance Monitoring User's Guide is divided into parts and chapters, as described below.

Chapter 1, Performance Monitoring Applications

This chapter introduces the Oracle Performance Manager, Oracle Advanced Events, Oracle Lock Manager, Oracle TopSessions, and Oracle Tablespace Manager, explains how to start these applications, and includes a common scenario for using them.

Part I: Using Oracle Performance Manager

Chapter 2, Oracle Performance Manager Overview

This chapter introduces Oracle Performance Manager. It also describes the components of the Oracle Performance Manager main window, how you use the right mouse button in this application, and the basic chart types you can use to display database statistics.

Chapter 3, Using Predefined Charts

This chapter describes some default characteristics of the predefined charts included with Oracle Performance Manager, and briefly describes each of these charts.

Chapter 4, Customizing Display Elements of Charts

This chapter describes how you customize the display elements of charts (such as chart type, scale, or 3D rotation) to best meet the needs of your particular environment.

Chapter 5, Defining or Modifying Charts

This chapter describes how you define a new chart or modify the basic definition of a chart, such as the SQL statement used to gather data for display. It also includes an example of defining a new chart.

Chapter 6, Displaying Charts in Chart Windows

This chapter covers the components of an Oracle Performance Manager chart window, and describes how you use such a window to display one or more Oracle Performance Manager charts.

Chapter 7, Working with Oracle Performance Manager Data

This chapter describes how you manage current and historical data for display in Oracle Performance Manager charts.

Part II: Using Other Performance Monitoring Applications

Chapter 8, Using Oracle Lock Manager

This chapter covers how you monitor locks in a database----- particularly blocking and waiting sessions.

Chapter 9, Using Oracle TopSessions

This chapter covers prerequisites to using Oracle TopSessions, starting Oracle TopSessions, the components of the Oracle TopSessions main window, viewing details about a given session, customizing the session information you display, and exiting Oracle TopSessions.

Chapter 10, Using Oracle Tablespace Manager

This chapter covers starting Oracle Tablespace Manager, the components of the Oracle Tablespace Manager main window, obtaining an overview of tablespaces and datafiles, monitoring segments in a tablespace, and managing storage in a tablespace.

How to Use this Guide

The Oracle Enterprise Manager Performance Monitoring User's Guide has been designed to be used closely with the Oracle Server documentation set. While this guide teaches you how to use Oracle Performance Manager, Oracle TopSessions, Oracle Lock Manager, and Oracle Tablespace Manager to monitor Oracle databases and systems, the Oracle Server documentation set describes the reasons for and the implications of such performance monitoring. Consequently, you should refer to the Oracle Server documentation set while using these applications.

Before using one of these performance monitoring applications, you should read "Overview of the Performance Monitoring Applications." After reading, you may choose to proceed directly to those chapters that are relevant to the tasks you plan to perform using one or more of these tools.

Conventions Used in this Guide

Special icons are provided to alert you to particular information within the body of this guide and within other manuals.

Attention:

The attention icon highlights information that is important to remember when performing the described task.

Suggestion:

The suggestion icon signifies suggestions and practical hints that can be helpful when using these applications.

Warning:

The warning icon indicates information that you should be aware of before you perform the action described in the current section.

Related Publications

This section covers the following topics:

Oracle Enterprise Manager documentation set
Other related Oracle publications

Oracle Enterprise Manager Documentation

The Oracle Enterprise Manager Performance Monitoring User's Guide is one of several Oracle Enterprise Manager documents.

The Oracle Enterprise Manager Readme provides important notes regarding the online documentation, updates to the software, and other late-breaking news.
The Oracle Enterprise Manager Installation CD-ROM Insert provides information about installing Oracle Enterprise Manager.
The Oracle Enterprise Manager Administrator's Guide explains how to use Oracle Enterprise Manager, Oracle's systems management console, common services, and integrated platform tool.
The Oracle Enterprise Manager Concepts Guide provides an overview of the Oracle Enterprise Manager.
The Oracle Enterprise Manager Configuration Guide explains how to configure Oracle Enterprise Manager.
The Oracle Enterprise Manager Application Developer's Guide describes the programming external interfaces to the Oracle Enterprise Manager console.
The Oracle Enterprise Manager Messages Manual describes the Oracle Enterprise Manager error messages and methods for diagnosing the messages.
The Oracle Enterprise Manager Oracle Trace User's Guide explains how to use the Oracle Trace application to capture and use historical data to monitor Oracle databases. The guide also offers guidelines for instrumenting your application with Trace routines.
The Oracle Enterprise Manager Oracle Expert User's Guide explains how to use Oracle Expert to optimize the performance of your database environment, during initial configuration, as well as during ongoing database operation.
The Oracle Enterprise Manager Performance Monitoring User's Guide explains how to use Oracle Performance Manager, Oracle Advanced Events, Oracle Lock Manager, Oracle TopSessions, and Oracle Tablespace Manager to monitor the performance of Oracle databases.

Other Related Oracle Publications

The Oracle Enterprise Manager Performance Monitoring User's Guide is one of many books that explain various parts of an Oracle database system.

In many sections of this guide, the information is general because the guide is written to apply to Oracle Performance Manager, Oracle Lock Manager, Oracle TopSessions, and Oracle Tablespace Manager working under any operating system and configuration. Therefore, you will also find many references in this book to important information in related publications. The related Oracle7 and Oracle8 books referred to in this guide are listed below. Note that these manuals are provided with both the Oracle7 and Oracle8 documentation set; you should use the manuals supplied with the version of the database you are using.

For general information about the Oracle Server and how it works, see Oracle Server Concepts.
For information about the database performance statistics mentioned in this guide, see Oracle Server Tuning.
For information about the V$ views and specific fields from which these performance statistics are obtained, see the Oracle Server Reference.
For information about administering the Oracle Server, see the Oracle Server Administrator's Guide.
For information about administering Oracle Parallel Servers, see the Oracle Parallel Server Support for the Oracle Enterprise Manager Console Guide.
For information about developing database applications within the Oracle Server, see the Oracle Server Application Developer's Guide.
For information on Oracle's SQL commands and functions, see the Oracle Server SQL Reference.
For information about Oracle's procedural language extension to SQL, PL/SQL, see the PL/SQL User's Guide and Reference.
For information about Oracle messages and codes, refer to Oracle Server Messages.
For information specific to the Oracle Server working on your host operating system, see your operating system-specific Oracle documentation (specific book titles vary by operating system) and system release bulletins, if available.

Oracle Corporation also publishes several ASCII files, which are available on your distribution media. These files describe differences between minor releases of Oracle software that are not accompanied by new manuals. These files are usually named README.DOC, BUGFIX.DOC, BUGHST.DOC, and RESTRICT.DOC. Read these files to learn about changes to the software that are not described in the regular manuals.

The release notes for Enterprise Manager are also available on your distribution media. The file is commonly called README.TXT.

Additional Information:

The exact names and locations of the files mentioned above may vary, depending on your operating system. See your operating system-specific Oracle documentation for information about these files.

Your Comments Are Welcome

We value and appreciate your Comments as an Oracle user and reader of the manuals. As we write, revise, and evaluate our documentation, your opinions are the most important input we receive. After the table of contents in our printed manuals is a Reader's Comment Form, which we encourage you to use to tell us what you like and dislike about this manual or other Oracle manuals. If the form is not available, please use the following address, FAX number, or electronic mail address.

Oracle Corporation
Oracle Performance Manager Documentation
One Oracle Drive
Nashua, NH 03062
U.S.A.

FAX - 603-987-3317 Attn: Oracle Performance Manager Documentation

Electronic mail - nedc_doc@us.oracle.com