| |
| |
| Preface | |
| |
| |
| I: Overview | |
| |
| |
| |
| Introduction to Oracle Performance Tuning Why Tuning? | |
| |
| |
| Who Tunes? | |
| |
| |
| When Do You Tune? | |
| |
| |
| A Look at Recent Versions How Much Tuning Is Enough? | |
| |
| |
| |
| What Causes Performance Problems? | |
| |
| |
| Problems with Design and Development | |
| |
| |
| Problems with System Resources Memory | |
| |
| |
| Problems and Tuning Disk I/O | |
| |
| |
| Problems and Tuning CPU | |
| |
| |
| Problems and Tuning Network | |
| |
| |
| Problems and Tuning | |
| |
| |
| II: Tuning for Managers and Planners | |
| |
| |
| |
| Planning and Managing the Tuning | |
| |
| |
| Process Managing the Problem of Response | |
| |
| |
| Time Managing the Problem of Long-Running | |
| |
| |
| Jobs Managing the Workload in Your System Making the Decision to Buy More Equipment | |
| |
| |
| Management Checkpoints Performance Hints for Managers | |
| |
| |
| |
| Defining System Standards Selecting a Common | |
| |
| |
| Design Methodology | |
| |
| |
| Selecting Your Software | |
| |
| |
| Selecting Your Hardware | |
| |
| |
| Setting Up Screen and Report | |
| |
| |
| Templates Using Modular Programming Techniques | |
| |
| |
| Defining System Libraries Enforcing | |
| |
| |
| Program Version Control | |
| |
| |
| Establishing Documentation Standards | |
| |
| |
| Establishing Database Environment Standards | |
| |
| |
| Security Standards | |
| |
| |
| Performance Standards | |
| |
| |
| III: Tuning for Designers and Analysts | |
| |
| |
| |
| Designing for Performance | |
| |
| |
| Common Design Problems | |
| |
| |
| Choosing an Architecture | |
| |
| |
| Tuning Your Data Model | |
| |
| |
| Tuning Indexes | |
| |
| |
| Testing the Data Model for Performance | |
| |
| |
| Denormalizing a Database | |
| |
| |
| Constraints Triggers Packages, Procedures, and Functions | |
| |
| |
| Designing a Very Large Database | |
| |
| |
| Application Miscellaneous | |
| |
| |
| Design Considerations | |
| |
| |
| IV: Tuning for Programmers | |
| |
| |
| |
| Tuning SQL | |
| |
| |
| SQL Standards | |
| |
| |
| The SQL | |
| |
| |
| Optimizer SQL | |
| |
| |
| Tuning Common Sense in SQL | |
| |
| |
| SQL Performance | |
| |
| |
| Tips and Hints Using | |
| |
| |
| Indexes to Improve Performance | |
| |
| |
| SQL Tuning Alternatives | |
| |
| |
| Identifying Poor SQL Statements | |
| |
| |
| Adjusting SQL Statements Over Time | |
| |
| |
| |
| Tuning PL/SQL | |
| |
| |
| PL/SQL and SQL | |
| |
| |
| What Does PL/SQL Offer? | |
| |
| |
| PL/SQL Limitations | |
| |
| |
| PL/SQL Coding Standards | |
| |
| |
| Tuning PL/SQL | |
| |
| |
| Exploiting the Power of PL/SQL | |
| |
| |
| Oracle PL/SQL Function Extensions | |
| |
| |
| |
| Selecting a Locking Strategy What Is Locking? | |
| |
| |
| Releasing Locks Avoiding the Dreaded Deadlock Locking | |
| |
| |
| Considerations for Oracle Features | |
| |
| |
| Overriding the Default Locking Strategy | |
| |
| |
| Internal Lock Contention Lock Detection Scripts | |
| |
| |
| V: Tuning for Database Administrators | |
| |
| |
| |
| Tuning a New Database Steps in Setting Up a Database | |
| |
| |
| Tuning Memory | |
| |
| |
| Tuning Disk I/O | |
| |
| |
| Creating the Database | |
| |
| |
| Creating the Tablespaces | |
| |
| |
| Creating Rollback Segments | |
| |
| |
| Creating Tables | |
| |
| |
| Creating Indexes | |
| |
| |
| Creating Views | |
| |
| |
| Creating Users INIT.ORA Parameter Summary | |
| |
| |
| Creating Very Large Databases | |
| |
| |
| |
| Diagnostic and Tuning Tools Monitor | |
| |
| |
| Monitoring System Activity Tables SQL_Trace | |
| |
| |
| Writing a Trace File TKPROF | |
| |
| |
| Interpreting the Trace File Explain Plan | |
| |
| |
| Explaining the Optimizer''s Plan ORADBX | |
| |
| |
| Listing Events Analyze | |
| |
| |
| Validating and Computing Statistics UTLBSTAT.sql and UTLESTAT.sql | |
| |
| |
| Taking Snapshots Other Oracle Scripts Some Scripts of Our | |