Release 1.4.0
A53653_01
 Library |
 Product |
 Contents |
 Index |
| Oracle Enterprise Manager Oracle Expert User's Guide Release 1.4.0 A53653_01 |
|
Oracle Expert is an Oracle Enterprise Manager integrated application used to automate performance tuning. Oracle Expert complements and automates many of the elements of a good structured tuning methodology.
Oracle Expert automates the process of collecting and analyzing performance tuning data, and provides expert database tuning recommendations. Additionally, Oracle Expert generates scripts that assist with the implementation of tuning recommendations.
This information describes the Oracle Expert software. Read this manual to learn how to use Oracle Expert and to discover all its features. This preface covers the following topics:
The purpose of this manual is to introduce you to the Oracle Expert software. This manual describes Oracle Expert and gives an overview of the graphical user interface.
This manual is written for database administrators and all those responsible for the maintenance and performance of an Oracle Server.
This manual is divided into a number of parts and chapters, appendix, glossary, and index. The descriptions follow.
This chapter introduces the reader to Oracle Expert. It explores the issues of database tuning and how Oracle Expert solves the tuning dilemma.
Chapter 2, "Oracle Expert Methodology"
This chapter explores the methodology used by Oracle Expert.
Chapter 3, "Starting Oracle Expert"
This chapter shows you how to start Oracle Expert.
Chapter 4, "Creating and Working with Tuning Sessions"
This chapter introduces the concept of a tuning session and explains how to create and modify a tuning session.
Chapter 5, "Collecting the Data"
This chapter explains how to collect the data used by Oracle Expert. It provides information on the different collection classes and describes how to collect each class.
Chapter 6, "Viewing and Editing the Collected Data"
This chapter describes how to view and edit the data you collect. It provides an in-depth description of how to use the Edit pull-down menu in conjunction with the View/Edit page.
Chapter 7, "Analyzing the Data"
This chapter describes how Oracle Expert analyzes the data it is provided.
Chapter 8, "Reviewing the Recommendations"
This chapter explains how to review the recommendations made by Oracle Expert.
Chapter 9, "Implementing the Recommendations"
This chapter explains how to implement the Oracle Expert recommendations.
Chapter 10, "Generating Reports"
This chapter introduces the reports generated by Oracle Expert: the Analysis report, the Session Data report, and the Recommendation Summary report.
Chapter 11, "Using Oracle Expert Effectively"
This chapter explains various types of tuning and how to use Oracle Expert effectively in these scenarios.
Chapter 12, "Initial Configuration"
This chapter describes how to use Oracle Expert to configure a new database.
This chapter describes how to use the Autotune option of Oracle Expert.
Appendix A, "Managing Workloads"
This appendix provides guidelines for collecting and managing Oracle Expert workloads.
The glossary provides definitions for terms specific to Oracle Expert.
Every reader of this manual should read Part I. These chapters explain the purpose of Oracle Expert and how it works.
Part II provides step-by-step information on how to use the various parts of Oracle Expert.
Part III describes how to use Oracle Expert in different tuning situations. Read these chapters for additional information on how and when to use Oracle Expert.
Part IV describes how to use the Autotune option of Oracle Expert.
The following table shows the conventions used in this manual.
The following documentation provides additional information about Oracle Enterprise Manager:
Oracle Corporation also publishes a README file, which is available on your distribution media. This file provides information about software functionality and restrictions that was not available at the time product documentation was published. For software updates that are not accompanied by new manuals, this file may also describe any minor changes in the product.
It is important that you read the README file so that you have an accurate understanding of the software's functionality.
