search for books and compare prices
Tables of Contents for Oracle Performance Tuning
Chapter/Section Title
Page #
Page Count
Preface
xiii
I: Overview
1
40
Introduction to Oracle Performance Tuning
3
24
Why Tuning?
5
3
Who Tunes?
8
1
When Do You Tune?
9
8
A Look at Recent Versions
17
7
How Much Tuning Is Enough?
24
3
What Causes Performance Problems?
27
14
Problems with Design and Development
27
3
Problems with System Resources
30
3
Memory Problems and Tuning
33
2
Disk I/O Problems and Tuning
35
3
CPU Problems and Tuning
38
2
Network Problems and Tuning
40
1
II: Tuning for Managers and Planners
41
40
Planning and Managing the Tuning Process
43
20
Managing the Problem of Response Time
44
5
Managing the Problem of Long-Running Jobs
49
4
Managing the Workload in Your System
53
2
Managing the Decision to Buy More Equipment
55
2
Management Checkpoints
57
4
Performance Hints for Managers
61
2
Defining System Standards
63
18
Selecting a Common Design Methodology
64
1
Selecting Your Software
64
1
Selecting Your Hardware
65
3
Setting Up Screen and Report Templates
68
3
Using Modular Programming Techniques
71
1
Defining System Libraries
71
2
Enforcing Program Version Control
73
1
Establishing Documentation Standards
73
1
Establishing Database Environment Standards
74
2
Security Standards
76
1
Performance Standards
77
4
III: Tuning for Designers and Analysts
81
50
Designing for Performance
83
48
Common Design Problems
83
2
Choosing an Architecture
85
3
Tuning Your Data Model
88
10
Tuning Indexes
98
5
Testing the Data Model for Performance
103
3
Denormalizing a Database
106
11
Constraints
117
2
Triggers
119
2
Packages, Procedures, and Functions
121
1
Designing a Very Large Database Applications
121
9
Miscellaneous Design Considerations
130
1
IV: Tuning for Programmers
131
166
Tuning SQL
133
72
SQL Standards
134
4
The SQL Optimizer
138
10
SQL Tuning
148
15
Common Sense in SQL
163
10
SQL Performance Tips and Hints
173
10
Using Indexes to Improve Performance
183
8
SQL Tuning Alternatives
191
10
Identifying Poor SQL Statements
201
2
Adjusting SQL Statements Over Time
203
2
Tuning PL/SQL
205
64
PL/SQL and SQL
206
1
What Does PL/SQL Offer?
206
7
PL/SQL Limitations
213
5
PL/SQL Coding Standards
218
3
Tuning PL/SQL
221
21
Exploiting the Power of PL/SQL
242
18
Oracle PL/SQL Function Extensions
260
9
Selecting a Locking Strategy
269
28
What Is Locking?
269
3
Releasing Locks
272
2
Avoiding the Dreaded Deadlock
274
2
Locking Considerations for Oracle Features
276
8
Overriding the Default Locking Strategy
284
5
Internal Lock Contention
289
3
Lock Detection Scripts
292
5
V: Tuning for Database Administrators
297
350
Tuning a New Database
299
86
Steps in Setting Up a Database
301
1
Tuning Memory
302
7
Tuning Disk I/O
309
8
Creating the Database
317
3
Creating the Tablespaces
320
17
Creating Rollback Segments
337
7
Creating Tables
344
7
Creating Indexes
351
5
Creating Views
356
1
Creating Users
357
1
INIT.ORA Parameter Summary
358
21
Creating Very Large Databases
379
6
Diagnostic and Tuning Tools
385
58
MONITOR: Monitoring System Activity Tables
387
1
SQL_TRACE: Writing a Trace File
388
3
TKPROF: Interpreting the Trace File
391
6
EXPLAIN PLAN: Explaining the Optimizer's Plan
397
9
ORADBX: Listing Events
406
2
ANALYZE: Validating and Computing Statistics
408
2
UTLBSTAT.sql and UTLESTAT.sql: Taking Snapshots
410
14
Other Oracle Scripts
424
3
Some Scripts of Our Own
427
15
Oracle Performance Manager
442
1
Monitoring and Tuning an Existing Database
443
78
Identifying Untuned Application Code
444
9
Tuning Memory
453
26
Tuning Disk I/O
479
18
Avoiding Contention
497
24
Tuning Parallel Server
521
30
Introduction to Parallel Server
521
2
Parallel Server Architecture
523
2
Parallel Server Locking
525
4
Parallel Server Design
529
8
Parallel Server Database
537
3
Tuning Instances
540
1
INIT.ORA Parameters
541
4
Ongoing Tuning
545
6
Tuning Parallel Query
551
28
Introduction to Parallel Query
551
5
PQO Design Considerations
556
4
Constructing Your Database for PQO
560
4
INIT.ORA Parameters
564
6
Ongoing Tuning of Query Servers
570
4
Creating Indexes in Parallel
574
1
Using PQO to Speed Data Loads
575
1
Performing Parallel Recovery
576
3
Tuning Database Backup and Recovery
579
68
The DBA's Responsibility
579
1
Backing Up the Database
580
20
Preparing to Recovery the Database
600
28
Recovering the Database
628
19
VI: Tuning for System Administrators
647
69
Tuning Long-Running Jobs
649
34
Correctly Sizing Tables and Indexes
650
3
Exploiting Array Processing
653
3
Optimizing INIT.ORA Parameters
656
4
Disk Tuning
660
3
Running Jobs in Parallel
663
2
DBA Tuning for Long-Running Jobs
665
3
Creating Overnight Extract Tables
668
1
Index Operations
668
3
Using PL/SQL to Speed Up Updates
671
1
Inline Functions
672
5
Minimizing the Number of Updates
677
1
Tuning EXPORT and IMPORT Utilities
677
6
Tuning in the Client-Server Environment
683
33
What Is Client-Server?
684
2
Network Topology
686
3
Where Should You Put the Network Hardware?
689
3
Client-Server Performance Issues
692
14
Tuning Precompliers for Client-Server
706
1
Tuning the Network Itself
707
1
Tuning SQL*Net
708
8
Client-Server: Adapting It in the Real World
716