Oracle 9i. Database Performance Methods

This book describes ways to improve Oracle performance by starting with good application design and using statistics to monitor application performance. It explains the Oracle Performance Improvement Method and the Emergency Performance Method, and it provides techniques for dealing with performance problems. Contents......Page 3 Send Us Your Comments......Page 5 Preface......Page 7 Related Documentation......Page 8 Conventions......Page 9 Documentation Accessibility......Page 12 1 Designing and Developing for Performance......Page 13 Understanding Investment Options......Page 14 What is Scalability?......Page 15 Internet Scalability......Page 16 Factors Preventing Scalability......Page 18 Hardware and Software Components......Page 19 Configuring the Right System Architecture for Your Requirements......Page 22 Simplicity In Application Design......Page 25 Table and Index Design......Page 26 Using Views......Page 29 SQL Execution Efficiency......Page 30 Implementing the Application......Page 31 Trends in Application Development......Page 34 Estimating Workloads......Page 35 Application Modeling......Page 36 Testing, Debugging, and Validating a Design......Page 37 Rollout Strategies......Page 38 Performance Checklist......Page 39 2 Monitoring and Improving Application Performance......Page 41 Importance of Statistics......Page 42 Statistics Gathering Tools......Page 46 Importance of Historical Data and Baselines......Page 47 Performance Intuition......Page 48 Introduction to Performance Improvement......Page 49 Steps in The Oracle Performance Improvement Method......Page 50 A Sample Decision Process for Performance Conceptual Modeling......Page 52 Top Ten Mistakes Made by Oracle Users......Page 53 Performance Characteristics of Hardware Configurations......Page 55 3 Emergency Performance Techniques......Page 57 Index......Page 61