Download Troubleshooting Oracle performance : [methodically identify and

Contents
Foreword
by Jonathan Lewis
Foreword by Cary Millsap
Foreword from the First Edition
About the Author
xix
xxi
xxiii
xxv
About the Technical Reviewers
xxix
Acknowledgments
Acknowledgments
xxvii
from the First Edition
xxxi
xxxiii
Introduction
i Part I: Foundations
1
I
Chapter 1: Performance Problems
3
Do You Need to Plan Performance?
3
Requirements Analysis
4
Analysis and Design
5
Coding
and Unit
6
Testing
Integration and Acceptance Testing
Designing for
Lack of
Performance
Logical
Implementing
Not
Database
Design
Generic Tables
Using Constraints to Enforce Data Integrity
7
8
8
8
9
Physical Database Design
9
Not
Choosing the Right Data Type
9
Not
Using Bind Variables Correctly
10
Not
Using Advanced Database Features
10
Lack of
vii