Oracle 9i. Database Performance Methods

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