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