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

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 Create Baseline, Oracle Compare Database Objects, and Oracle TopSessions charts.

Audience

This guide is written for 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, Create Baseline, Compare Database Objects, 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, Create Baseline, Compare Database Objects, DB Propagate, DB Quick Change, Find Database Objects, 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 Data Viewer, Oracle TopSessions charts, 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, Create Baseline, Compare Database Objects, Oracle Index Tuning Wizard, Oracle Performance Manager, and Oracle TopSessions charts.
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.
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.
Helps increase the productivity of developers and DBAs.

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.

Related Publications

For further details about the information provided in this manual, see the following manuals in the Oracle Server documentation set:

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 for Oracle Enterprise Manager and the Oracle Management Packs.
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.
The Oracle Intelligent Agent User's Guide provides configuration information and answers to crucial troubleshooting questions pertaining to the Oracle Intelligent Agent.
The Oracle Enterprise Manager Event Test Reference Manual describes Oracle Event Tests which allow you to implement automatic problem detection and correction on concurrent managers, databases, listeners, nodes, and SAP R/3 systems.

Oracle Management Pack Installation Documentation

The Oracle 9i Installation Guide Release 9.0.1 for UNIX Systems provides important information for installing the Oracle Enterprise Manager console and the management packs. This manual also contains information such as hardware and software requirements, installable components, and deinstallation procedures. The Oracle 9i Installation Guide Release 9.0.1 for UNIX Systems is located on the Oracle9i Online Generic Documentation CD-ROM, Release 1 (9.0.1) or you can get a free download from the Oracle Documentation Center at docs.oracle.com.

Oracle Change Management Pack documentation

The 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 Getting Started with the Oracle Diagnostics Pack provides an overview of the concepts and features of Oracle Performance Manager, Oracle Capacity Planner, Oracle Data Viewer, and the Oracle TopSessions charts.

Oracle Tuning Pack documentation

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, Reorg Wizard, Tablespace Map, Outline Management, and the Outline Editor. 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 R/3 Readme provides important notes regarding Oracle Management Pack for SAP R/3 online documentation, updates to the software, and other late-breaking information.
Getting Started with Oracle Management Pack for SAP R/3 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.
The Oracle Management Pack for SAP R/3 Installation Guide provides important information for installing the Oracle Management Pack for SAP R/3. This manual also contains information such as hardware and software requirements, installable components, and deinstallation procedures.

Oracle Management Pack for Oracle Applications Documentation

Getting Started with 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 Support

The Oracle MetaLink site provides access to information that will aid you in using Oracle products such as: hot topics, product reference, installation assistance materials, white papers, problem/solution articles, and more . To use this site you must be a licensed Oracle user with an active support service contract. Contact your Oracle sales representative for more information.

Documentation Accessibility

Oracle's goal is to make our products, services, and supporting documentation accessible to the disabled community with good usability. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program web site at http://www.oracle.com/accessibility/.

How to Find Oracle Documentation Online

To download free release notes or installation documentation, please visit the Oracle Documentation Center at http://docs.oracle.com/.

Printed documentation is available for sale in the Oracle Store at http://oraclestore.oracle.com/.