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, 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" and "Other References."

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

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 4

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 5

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 6

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

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

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 Server Concepts, Volume 1
Oracle Server Concepts, Volume 2
Oracle Server Reference
Oracle Server SQL Reference, Volume 1
Oracle Server SQL Reference, Volume 2
Oracle Server Tuning

Oracle Enterprise Manager Documentation

The Oracle Enterprise Manager Database Tuning with the Oracle Tuning 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 Application Developer's Guide describes the programming external interfaces to the Oracle Enterprise Manager console.
The Oracle Enterprise Manager Messages Manual describes the Oracle Enterprise Manager error messages and methods for diagnosing the messages.

Oracle Enterprise Manager Change Management Pack documentation

The Oracle Enterprise Manager Change Management Pack Readme provides important notes regarding the 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 Enterprise Manager Diagnostics Pack documentation

The Oracle Enterprise Manager Diagnostics Pack Readme provides important notes regarding the 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 Diagnostics Pack applications.
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 Enterprise Manager Tuning Pack documentation

The Oracle Enterprise Manager Tuning Pack Readme provides important notes regarding the Tuning Pack online documentation, updates to the software, and other late-breaking information.
The 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, Reorg Wizard, and the Tablespace Map. A description of how these applications can work together to tune an Oracle database is also provided.

Other References

The following books are further resources for learning more about Oracle database tuning. (Note that the books listed here are not specifically recommended by Oracle, nor does Oracle take responsibility for any information provided by these sources.)

Advanced Oracle Tuning and Administration, by Eyal Aronoff, Kevin Loney, and Noorali Sonawalla. Oracle Press series, Osborne McGraw-Hill, 1997.

High Performance Oracle8 SQL Programming and Tuning, by Pete Cassidy. The Coriolis Group, 1998.

High-Performance Oracle Database Applications : Performance and Tuning Techniques for Getting the Most from Your Oracle Database, by Donald K. Burleson. The Coriolis Group, 1996.

High Performance Oracle 8 Tuning, by Donald K. Burleson. The Coriolis Group, 1997.

Oracle and Unix Performance Tuning, by Ahmed Alomari. Prentice Hall Computer Books, 1997.

Oracle: The Complete Reference, third edition, by George Koch and Keven Loney. Oracle Press series, Osborne McGraw-Hill, 1997. (Oracle 7.3)

Oracle: The Complete Reference, Electronic Edition, by George Koch and Keven Loney. Oracle Press series, Osborne McGraw-Hill, 1997. (Oracle 7.3)

Oracle8 Tuning, by Michael Abbey, Michael J. Corey, Daniel J. Dechichio, and Ian Abramson. Oracle Press series, Osborne McGraw-Hill, 1997.

Oracle Performance Tuning (Nutshell Handbook), second edition, by Mark Gurry and Peter Corrigan. O'Reilly & Associates, 1996.

Oracle Performance Tuning and Optimization, by Edward Whalen. Sams Publishing, 1996.

Oracle SQL High-Performance Tuning, by Guy Harrison. Prentice Hall Computer Books, 1997.

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	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 4	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 5	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 6	Introduction to the Tablespace Map This section provides an overview of the Tablespace Map. This map provides a detailed graphical display of the segments withing a selected tablespace. You can perform a segment analysis to see if the segments could benefit from a reorganization or rebuild.