Preface

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

Purpose of This Guide

This guide provides user instructions for the Oracle Trace Manager application, which is the Oracle Trace graphical user interface. This guide also provides information on the Oracle Trace Data Viewer used to view formatted data collected by Oracle Trace.

Audience

This guide is written for Oracle Trace users who want to set up data collections using the Oracle Trace Manager application and who want to view the formatted collected data using Oracle Trace Data Viewer.

How This Guide Is Organized

This guide is organized as follows:

Chapter 1, "Overview"

Provides a general description of Oracle Trace.

Chapter 2, "Using Oracle Trace"

Describes how to invoke Oracle Trace, the Oracle Trace Manager windows and menus displayed, and how to exit. Included in this chapter are instructions for discovering products.

Chapter 3, "Working with Collections"

Describes how to create, edit, stop, and delete Oracle Trace collections.

Chapter 4, "Oracle Trace Data Viewer"

Describes how to use Oracle Trace Data Viewer.

Appendix A, "Manual Collection of Oracle Trace Data"

Describes Oracle Trace initialization parameters, stored procedures, and command-line interface.

Appendix B, "Oracle Server Events"

Contains information on Oracle Server SQL and wait events and data that can be collected with Oracle Trace.

Appendix C, "Troubleshooting Oracle Trace"

Lists the problems you might encounter while using Oracle Trace and provides solutions to these problems.

Conventions Used in This Guide

The following table lists the conventions used in the guide.

Convention Explanation

#

The default superuser prompt.

%

The default user prompt.

[Ctrl/C]

Press the Ctrl key while you simultaneously press another key (in this case, C).

italics

Italicized words indicate variables, such as a file or directory name.

$ORACLE_HOME

Represents the directory where you installed Oracle Enterprise Manager components and Oracle Diagnostics Packproducts. The directory name may be different on your system.

otracexx

The xx represents the version of the database for which you are collecting data; for example, otrace73 for the Oracle Server release 7.3.

Convention	Explanation
#	The default superuser prompt.
%	The default user prompt.
[Ctrl/C]	Press the Ctrl key while you simultaneously press another key (in this case, C).
italics	Italicized words indicate variables, such as a file or directory name.
$ORACLE_HOME	Represents the directory where you installed Oracle Enterprise Manager components and Oracle Diagnostics Packproducts. The directory name may be different on your system.
otracexx	The xx represents the version of the database for which you are collecting data; for example, otrace73 for the Oracle Server release 7.3.

This guide also assumes that you are familiar with the operation of Microsoft Windows NT. Refer to the Windows documentation for your system, if necessary. In general, this guide shows the directory names as they are used in UNIX; on an NT system, delineate directory names with a backslash (\).

To reduce wordiness and redundancy, menu and submenu choices are joined by arrows. For example, Collection=>Create refers to the Create Collection choice in the Collection menu.

Oracle Enterprise Manager Pack Information

The Oracle Enterprise Manager product family includes three packs: Oracle Change Management Pack, Oracle Diagnostics Pack, and Oracle Tuning Pack. Each pack is fully integrated into the Oracle Enterprise Manager Console framework.

Oracle Change Management Pack

Includes DB Alter, DB Capture, DB Diff, DB Propagate, DB Quick Change, DB Search, and Plan Manager.
Tracks metadata changes in databases.
Eliminates errors and loss of data when upgrading databases to support new applications.
Analyzes the impact and complex dependencies associated with application change and automatically performs database upgrades.
Allows you to find the database objects that match a set of search criteria that you specify.
Initiates change safely with easy-to-use wizards that teach the systematic steps necessary to upgrade.

Oracle Diagnostics Pack

Includes Oracle Performance Manager, Oracle Capacity Planner, Oracle Trace, Oracle TopSessions, and Oracle Event Tests that are provided with the Oracle Diagnostics Pack.
Monitors, diagnoses, and maintains the health of databases, operating systems, and applications. Both historical and real-time analysis are used to automatically avoid problems before they occur.
Provides powerful capacity planning features that enable users to easily plan and track future system resource requirements.

Oracle Tuning Pack

Includes Oracle Auto-Analyze, Oracle SQL Analyze, Oracle Expert, Oracle Index Tuning Wizard, and the Oracle Tablespace Manager.
Optimizes system performance by identifying and tuning major database and application bottlenecks such as inefficient SQL, poor data structures, and improper use of system resources.
Proactively discovers tuning opportunities and automatically generates the analysis and required changes to tune the system. Inherent in the product are powerful teaching tools which train DBAs how to tune as they work.
Instills "Consultant Quality" tuning expertise into developers and DBAs and increases their productivity.

Oracle Enterprise Manager Documentation

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

Oracle Enterprise Manager base documentation

The Oracle Enterprise Manager Readme provides important notes regarding the online documentation, updates to the software, and other late-breaking information.
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 Messages Manual describes the Oracle Enterprise Manager error messages and methods for diagnosing the messages.

Oracle Change Management Pack documentation

The Oracle Change Management Pack Readme provides important notes regarding the Change Management Pack online documentation, updates to the software, and other late-breaking information.
The Oracle Change Management Pack Installation CD-ROM insert provides information about installing the Oracle Change Management Pack.
The Oracle Enterprise Manager Getting Started with Oracle Change Management Pack manual provides an overview of the concepts and features of the Oracle Change Management Pack applications.

Oracle Diagnostics Pack documentation

The Oracle Diagnostics Pack Readme provides important notes regarding the Diagnostics Pack online documentation, updates to the software, and other late-breaking information.
The Oracle Diagnostics Pack Installation CD-ROM insert provides information about installing the Oracle Diagnostics Pack.
The Oracle Enterprise Manager Performance Monitoring and Planning Guide provides an overview of the concepts and features of the Oracle Performance Manager, Oracle Capacity Planner, and Oracle TopSessions applications. It also describes the Oracle Event Tests that are provided with the Oracle Diagnostics Pack, which allow you to manage database, listener, and service types.
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 Oracle Enterprise Manager Oracle Trace Developer's Guide explains how to instrument your application with Oracle Trace routines.

Oracle Tuning Pack documentation

The Oracle Tuning Pack Readme provides important notes regarding the Tuning Pack online documentation, updates to the software, and other late-breaking information.
The Oracle Tuning Pack Installation CD-ROM insert provides information about installing the Oracle Tuning Pack.
Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack provides an overview of the concepts and features of each of the applications in the Oracle Tuning Pack. The applications include Oracle Auto-Analyze, Oracle SQL Analyze, Oracle Expert, Oracle Index Tuning Wizard, and the Oracle Tablespace Manager. A description of how these applications can work together to tune an Oracle database is also provided.