Oracle Database 11gR2 Performance Tuning Cookbook
Starting with Performance Tuning
Reviewing the performance tuning process
Exploring the example database
Acquiring data using a data dictionary and dynamic performance views
Analyzing data using Statspack reports
Diagnosing performance issues using the alert log
Analyzing data using Automatic Workload Repository (AWR)
Analyzing data using Automatic Database Diagnostic Monitor (ADDM)
Optimizing connection management
Improving performance sharing reusable code
Reducing the number of requests to the database using stored procedures
Reducing the number of requests to the database using sequences
Reducing the number of requests to the database using materialized views
Optimizing performance with schema denormalization
Migrating to index organized tables
Exploring index skip-scan and index range-scan
Introducing arrays and bulk operations
Tracing SQL activity with SQL Trace and TKPROF
Sorting—in-memory and on-disk
Writing top n queries and ranking
Using count, min/max, and group-by
Avoiding sorting in set operations: union, minus, and intersect
Troubleshooting temporary tablespaces
Using bind variables and parsing
Array processing and bulk-collect
Passing values with NOCOPY (or not)
Using short-circuit IF statements
Taking advantage of function result cache
Using triggers and virtual columns
Improving the Oracle Optimizer
Introducing Adaptive Cursor Sharing for bind variable peeking
Configuring and using SQL Baselines
Caching results with the client-side result cache
Inspecting indexes and triggers overhead
Loading data with SQL*Loader and Data Pump
Tuning memory to avoid Operating System paging
Tuning the Program Global Area and the User Global Area
Tuning at the disk level and strategies to distribute Oracle files
Striping objects across multiple disks
Choosing different RAID levels for different Oracle files
Detecting and preventing lock contention
Investigating transactions and concurrency
Tuning resources to minimize latch contention
Minimizing latches using bind variables
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning
A Summary of Oracle Packages Used for Performance Tuning