Oracle9
i
Database Performance Methods
Release 1 (9.0.1)
Part Number A87504-02
Home
Book List
Index
Master Index
Feedback
Contents
Title and Copyright Information
Send Us Your Comments
Preface
1 Designing and Developing for Performance
Oracle's New Methodology
Understanding Investment Options
Understanding Scalability
What is Scalability?
Internet Scalability
Factors Preventing Scalability
System Architecture
Hardware and Software Components
Configuring the Right System Architecture for Your Requirements
Application Design Principles
Simplicity In Application Design
Data Modeling
Table and Index Design
Using Views
SQL Execution Efficiency
Implementing the Application
Trends in Application Development
Workload Testing, Modeling, and Implementation
Sizing Data
Estimating Workloads
Application Modeling
Testing, Debugging, and Validating a Design
Deploying New Applications
Rollout Strategies
Performance Checklist
2 Monitoring and Improving Application Performance
Importance of Statistics
Statistics Gathering Tools
Importance of Historical Data and Baselines
Performance Intuition
The Oracle Performance Improvement Method
Introduction to Performance Improvement
Steps in The Oracle Performance Improvement Method
How to Check the Operating System
A Sample Decision Process for Performance Conceptual Modeling
Top Ten Mistakes Made by Oracle Users
Performance Characteristics of Hardware Configurations
3 Emergency Performance Techniques
Index
Copyright © 1996-2001, Oracle Corporation.
All Rights Reserved.
Home
Book List
Index
Master Index
Feedback