Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack
Release 9.0.1

Part Number A86647-01

Library

Product

Contents

Index

Go to previous page Go to next page


Preface

The Oracle Tuning Pack provides advanced tools that focus on tuning the highest impact database performance areas, such as: application SQL, indexing strategies, instance parameters controlling I/O, SGA performance, and object sizing, placement, and reorganization. The tools included in this pack are designed to work together to accomplish many database tuning tasks. The applications included in the Oracle Tuning Pack are: Oracle SQL Analyze, Oracle Expert, Outline Editor, Outline Management, Oracle Index Tuning Wizard, Reorg Wizard, and the Tablespace Map.

This preface covers the following topics:

Purpose

The purpose of this manual is to introduce you to the Oracle Tuning Pack applications. The manual describes how you can use each of the applications as part of an overall database tuning process.

Although this manual provides some guidelines for tuning your database, it does not attempt to be a definitive source for making tuning decisions. For more complete information about database and SQL application tuning, see the books listed in "Related Publications".

Audience

This manual is intended for database administrators, developers of Oracle-based applications, and all those responsible for the maintenance and performance of an Oracle database.

How This Manual is Organized

This manual contains the following six parts:

Part 1

Introduction to the Oracle Tuning Pack

This section briefly describes the individual pack applications and provides tips on choosing the right application to perform your database tuning tasks.

Part 2

Introduction to Oracle SQL Analyze

This section provides an overview of Oracle SQL Analyze. Oracle SQL Analyze helps you optimize the performance of SQL statements run against your databases.

Part 3

SQL Explain Plan

This brief chapter will introduce you to SQL Explain plans and help you read and understand them.

Part 4

Introduction to Oracle Expert

This section provides an overview of Oracle Expert. Oracle Expert is used to automate performance tuning and generate tuning recommendations.

Part 5

Introduction to Oracle Index Tuning Wizard

This section provides an overview of the Oracle Index Tuning wizard. This wizard identifies tables with inefficient indexes and makes recommendations which will improve access to those tables.

Part 6

Introduction to the Reorg Wizard

This section provides an overview of the Reorg Wizard. This wizard takes you step-by-step through a complete or partial tablespace reorganization to eliminate space usage problems.

Part 7

Introduction to the Tablespace Map

This section provides an overview of the Tablespace Map. This map provides a detailed graphical display of the segments within a selected tablespace. You can perform a segment analysis to see if the segments could benefit from a reorganization or rebuild.

Part 8

Introduction to Outline Management and Introduction to the Outline Editor

This section provides an overview of the Outline Management and Outline Editor tools. These tools are built on Oracle's Plan Stability functionality and allow you to create, modify, delete, and manage stored outlines.

Conventions

The following conventions are used in this manual:

Convention  Meaning 

boldface text 

Boldface type in text indicates a term defined in the text, the glossary, or in both locations. 

=>  

Indicates that you choose a menu option. For example, File=>Exit means select the Exit option from the File menu. 

[ ]  

A key name enclosed in brackets indicates that you press that key. For example, [F1] means the function key labeled "F1." 

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
Oracle Management Pack Installation documentation
Oracle Enterprise Manager Change Management Pack documentation
Oracle Enterprise Manager Diagnostics Pack documentation
Oracle Enterprise Manager Tuning Pack documentation
Oracle Management Pack for Oracle Applications documentation
Oracle Management Pack for SAP R/3 documentation

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/.


Go to previous page Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index