Tuning
Electronic Presentation
D11299GC11
Production 1.1
December 2001
D34225
Oracle9i Database Performance
Tuning
Electronic Presentation
Copyright © Oracle Corporation, 2001. All rights reserved.
This documentation contains proprietary information of Oracle Corporation. It is provided under a
license agreement containing restrictions on use and disclosure and is also protected by copyright
law. Reverse engineering of the software is prohibited. If this documentation is delivered to a U.S.
Government Agency of the Department of Defense, then it is delivered with Restricted Rights and the
following legend is applicable:
Restricted Rights Legend
Use, duplication or disclosure by the Government is subject to restrictions for commercial computer
software and shall be deemed to be Restricted Rights software under Federal law, as set forth in
subparagraph (c)(1)(ii) of DFARS 252.227-7013, Rights in Technical Data and Computer Software
(October 1988).
This material or any portion of it may not be copied in any formor by any means without the express
prior written permission of the Education Products group of Orac le Corporation. Any other copying is
a violation of copyright law and may result in civil and/or criminal penalties.
If this documentation is delivered to a U.S. Government Agency not within the Department of
Defense, then it is delivered with “Restricted Rights,” as defined in FAR 52.227-14, Rights in Data-
General, including Alternate III (June 1987).
The information in this document is subject to change without notice. If you find any problems in the
documentation, please report them in writing to Worldwide Education Services, Oracle Corporation,
500Oracle Parkway, Box SB-6, Redwood Shores, CA 94065. Oracle Corporation does not warrant
that this document is error-free.
Oracle and all references to Oracle Products are trademarks or registered trademarks of Oracle
Corporation.
All other products or company names are used for identification purposes only, and may be
trademarks of their respective owners.
Authors
Peter Kilpatrick
Shankar Raman
Jim Womack
Technical Contributors and
Reviewers
Mirza Ahmad
Harald Van Breederode
Howard Bradley
Howard Ostrow
Alexander Hunold
Joel Goodman
John Watson
Michele Cyran
Pietro Colombo
Ranbir Singh
Ruth Baylis
Sander Rekveld
Tracy Stollberg
Connie Dialeris
Wayne Stokes
Scott Gossett
Sushil Kumar
Benoit Dagerville
David Austin
Howard Bradley
Howard Ostrow
Janet Stern
Lilian Hobbs
Maria Senise
Roderick Manalac
Sander Rekveld
Scott Gossett
1
Copyright © Oracle Corporation, 2001. All rights reserved.
Overview of Oracle 9i Performance Tuning
1-2 Copyright © Oracle Corporation, 2001. All rights reserved.
Objectives
After completing this lesson, you should be able to
do the following:
• List the roles associated with the database tuning
process
• Describe the dependencies between tuning in
different development phases
• Describe service level agreements
• List the tuning goals
• List the most common tuning problems
• Describe tuning during development and production
• Describe performance and safety tradeoffs
1-3 Copyright © Oracle Corporation, 2001. All rights reserved.
Tuning Questions
• Who tunes?
– Application designers
– Application developers
– Database administrators
– System administrators
• Why tune?
• How much tuning?
