Preface

This section describes the purpose and organization of this guide: Getting Started with the Oracle Standard Management Pack. Specifically, it covers the following topics:

• Purpose of This Guide

• Audience

• How This Guide Is Organized

• Conventions Used in This Guide

• Oracle Enterprise Manager Pack Information

• Oracle Enterprise Manager Documentation

Purpose of This Guide

This guide provides an overview of the Oracle Standard Management Pack applications and their features. As the guide describes how to use the Oracle Standard Management Pack applications, it also introduces you to key concepts and terminology in the following products: Oracle Performance Manager, Oracle Index Tuning Wizard, Oracle Baseline Viewer, Oracle Change Manager, Oracle DB Capture, Oracle DB Diff, and Oracle TopSessions.

Audience

This guide is written for the Oracle Standard Management Pack users who want to monitor and diagnose problems, tune high impact indexes, and track and compare changes in their Oracle environment.

How This Guide Is Organized

This guide is organized as follows:

Chapter 1, "Overview"

Provides a general description of the Oracle Standard Management Pack.

Chapter 2, "Post-Installation Configuration"

Describes how to configure Performance Manager and TopSessions.

Chapter 3, "Introduction to Oracle Performance Manager"

Provides an overview of the Oracle Performance Manager application and its features.

Chapter 4, "Introduction to Oracle Index Tuning Wizard"

Provides an overview of the Oracle Index Tuning wizard.

Chapter 5, "Overview of the Change Management Applications"

Provides an overview of the Baseline Viewer, DB Capture, DB Diff, and Change Manager applications and their features.

Chapter 6, "Using Change Manager"

Provides an overview of the Change Manager application.

Chapter 7, "Using Oracle TopSessions"

Provides an overview of the Oracle TopSessions application and its features.

Appendix A, "Troubleshooting Appendix"

Provides solutions to problems you may encounter while working with the Standard Management Pack.

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 the Oracle Standard Management Pack applications. 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 the following packs: Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Standard Management Pack, Oracle Tuning Pack, Oracle Management Pack for SAP R/3, and Oracle Management Pack for Oracle Applications. Each pack is fully integrated into the Oracle Enterprise Manager Console framework.

Oracle Change Management Pack

• Includes Baseline Viewer, Change Manager, DB Alter, DB Capture, DB Diff, DB Propagate, DB Quick Change, DB Search, and Plan Editor.

• 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 Standard Management Pack

• Includes Baseline Viewer, Change Manager, DB Capture, DB Diff, Oracle Index Tuning Wizard, Oracle Performance Manager, and Oracle TopSessions.

• Monitors and diagnoses problems, tunes high impact indexes, and tracks and compares changes in your Oracle environment.

Oracle Tuning Pack

• Includes Oracle Auto-Analyze, Oracle SQL Analyze, Oracle Expert, Oracle Index Tuning Wizard, Oracle Tablespace Map, and Oracle Reorg Wizard.

• 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 Management Pack for SAP R/3

• Includes Oracle Performance Manager, Oracle Capacity Planner, and Oracle Event Tests that are specific to monitoring your SAP R/3 environment.

• Monitors, diagnoses, and maintains the health of a SAP R/3 system. 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 Management Pack for Oracle Applications

• Includes Oracle Performance Manager, Oracle Capacity Planner, Concurrent Processing Tuning Assistant, and Oracle Applications Event Tests.

• Enables you to monitor all aspects of your system, including databases and concurrent managers.

• Enables the monitoring, diagnosing, and capacity planning of the Oracle Applications environment.

Oracle Enterprise Manager Documentation

The Getting Started with the Oracle Standard Management Pack manual 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 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 Intelligent Agent User's Guide provides configuration information and answers to crucial troubleshooting questions pertaining to the Oracle Intelligent Agent.

Oracle Change Management Pack documentation

• The Oracle Change Management Pack Readme provides important notes regarding the Oracle Change Management Pack online documentation, updates to the software, and other late-breaking information.

• 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 Oracle Diagnostics Pack online documentation, updates to the software, and other late-breaking information.

• The Getting Started with the Oracle Diagnostics Pack 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.

Oracle Standard Management Pack documentation

• The Oracle Standard Management Pack Readme provides important notes regarding the Oracle Standard Management Pack online documentation, updates to the software, and other late-breaking information.

• The Getting Started with the Oracle Standard Management Pack provides an overview of the concepts and features of Baseline Viewer, Change Manager, DB Capture, DB Diff, Oracle Index Tuning Wizard, Oracle Performance Manager, and Oracle TopSessions.

Oracle Tuning Pack documentation

• The Oracle Tuning Pack Readme provides important notes regarding the Oracle Tuning Pack online documentation, updates to the software, and other late-breaking information.

• Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack provides an overview of the concepts and features of each of the applications included in the Oracle Tuning Pack. The applications include Oracle SQL Analyze, Oracle Expert, Oracle Index Tuning Wizard, Oracle Reorg Wizard, and the Oracle Tablespace Map. A description of how these applications can work together to tune an Oracle database is also provided.

Oracle Management Pack for SAP/R3 Documentation

• Oracle Management Pack for SAP/R3 Readme provides important notes regarding Oracle Management Pack for SAP R/3 online documentation, updates to the software, and other late-breaking information.

• Oracle Enterprise Manager Getting Started with Oracle Management Pack for SAP/R3 provides an overview of the concepts and features of Oracle Performance Manager and Oracle Capacity Planner. It also describes Oracle Event Tests that are provided with the Oracle Management Pack for SAP/R3.

Oracle Management Pack for Oracle Applications Documentation

• Oracle Management Pack for Oracle Applications Readme provides important notes regarding Oracle Management Pack for Oracle Applications online documentation, updates to the software, and other late-breaking information.

• Getting Started with the Oracle Management Pack for Oracle Applications provides an overview of the concepts and features of Oracle Performance Manager, Oracle Capacity Planner, and Concurrent Processing Tuning Assistant. It also describes Oracle Applications Event Tests and Jobs that are specific to monitoring your Oracle Applications environment.

• Oracle Intelligent Agent User's Guide provides configuration information and answers to crucial troubleshooting questions pertaining to the Oracle Intelligent Agent.

---