Oracle Enterprise Manager Oracle Expert User's Guide Release 1.4.0 A53653_01

Library Product Index

Contents

Title and Copyright Information

Preface

Part I Overview of Oracle Expert

1 Introduction

Advantages of Using Oracle Expert

What Is Database Tuning?

Database Tuning Issues

Resolving Tuning Issues

What Are the Types of Performance Tuning?

Instance Tuning

Application Tuning

Structure Tuning

Ways to Use Oracle Expert

Work In Progress Dialog Box

Sample Tuning Session

2 Oracle Expert Methodology

Steps in Oracle Expert Methodology

Setting the Scope of the Tuning Session

Collecting the Data

Viewing and Editing the Collected Data

Analyzing the Data

Reviewing the Oracle Expert Recommendations

Implementing the Recommendations

Inputs and Outputs

Tuning Inputs

Generated Output

Part II Using Oracle Expert

3 Starting Oracle Expert

4 Creating and Working with Tuning Sessions

Oracle Expert Main Window

Identifying the Database to Tune

Creating a New Tuning Session

Setting the Scope of a Tuning Session

Instance Tuning

Application Tuning

Structure Tuning

Selecting Values for Control Parameters

Opening an Existing Tuning Session

Modifying a Tuning Session

Deleting a Tuning Session

5 Collecting the Data

Overview of Data Collection

Collecting the Collection Classes

How Oracle Expert Collects Class Data

Specifying the Class Data to Collect

Collecting Data Efficiently

Collecting the Database Class

Source Elements on the Database Collect Options Dialog Box

Options Elements on the Database Collect Options Dialog Box

Collecting Database Class Data from an Instance

Collecting Database Class Data from a File

Re-Collecting Database Class Data

Collecting the Instance Class

Source Elements on the Instance Collect Options Dialog Box

Options Elements on the Instance Collect Options Dialog Box

Collecting Instance Class Data from One or More Instances

Collecting Multiple Instance Statistics Samples During a Collection

Collecting Instance Class Data from a File

Getting Less Conservative Instance Tuning Recommendations

Re-Collecting Instance Class Data

Collecting the Schema Class

Source Elements on the Schema Collect Options Dialog Box

Options Elements on the Schema Collect Options Dialog Box

Collecting Schema Class Data from One or More Instances

Collecting Schema Class Data from a File

Re-Collecting Schema Class Data

Collecting the Environment Class

Source Elements on the Environment Collect Options Dialog Box

Options Elements on the Environment Collect Options Dialog Box

Entering Environment Class Data Manually

Entering Logical Device Data Manually

Entering System Data Manually

Collecting Environment Class Data from a File

Re-Collecting the Environment Class

Collecting the Workload Class

Source Elements on the Workload Collect Options Dialog Box

Options Elements on the Workload Collect Options Dialog Box

Collecting Workload Class Data from an Oracle Trace Database

Collecting Workload Class Data from a Database's SQL Cache

Collecting Workload Class Data from a File

Re-Collecting Workload Class Data

Collecting Workload Class Data Manually

Starting a Collection

Restrictions During a Collection

Canceling a Collection

Collecting Invalid Data

6 Viewing and Editing the Collected Data

Edit Pull-Down Menu

Add

Modify

Changing Values

Rules Page

Delete

Validate

Export

Default Rules

View/Edit Page

Databases

Instances

Schemas

Tablespaces

Public Synonyms

Database Users

System

Logical Devices

Workload Applications

Application

Business Unit

Transaction

Request

7 Analyzing the Data

Analyzing Data

Analyzing Data Efficiently

Tunable Rule

Deleting an Object

Restrictions During an Analysis

Canceling an Analysis

Invalid Objects Discovered During an Analysis

Invalidating an Analysis

8 Reviewing the Recommendations

Reviewing Tuning Recommendations

9 Implementing the Recommendations

Implementing Tuning Recommendations

How to Use the Implementation Files

10 Generating Reports

Generating a Session Data Report

Contents of a Session Data Report

Generating an Analysis Report

Contents of an Analysis Report

Generating a Recommendation Summary Report

Contents of a Recommendation Summary Report

Part III How and When to Use Oracle Expert

11 Using Oracle Expert Effectively

Defining the Appropriate Tuning Scope

Providing Complete and Accurate Data

Using Iterative Tuning for Improved Performance

Taking Advantage of Rules

12 Initial Configuration

Advantages of Using Oracle Expert

Configuring a New Database

Performing Initial Configuration for a Database

Improving the Initial Configuration of the Database

Viewing and Changing Default Instance Parameters for a Database Not Yet Created

User-Provided Information

Oracle Expert Recommendations

Part IV How to Use Autotune

13 Autotune

Starting Autotune

Stopping Autotune

Viewing Autotune Recommendations

Implementing Autotune Recommendations

A Managing Workloads

Database Workloads

Determining a Representative Workload for a Tuning Session

Collecting Workload Information with Oracle Trace

Providing Oracle Trace Workload Information to Oracle Expert

Collecting Workload Information from the SQL Cache

Providing SQL Cache Workload Information to Oracle Expert

Reducing the Size of a Collected Workload

Understanding the Workload Hierarchy

Specifying Importance Values for Workload Elements

Overwriting Workload Data

Appending to Workload Data

Glossary

Index

Next

Copyright © 1997 Oracle Corporation. All Rights Reserved.

Library Product Index