Oracle Performance Survival Guide
A Systematic Approach to Database Optimization
Versandkostenfrei!
Nicht lieferbar
Oracle Performance Survival Guide offers a structured methodology for optimizing Oracle performance in the most systematic and efficient manner possible. Authored by leading Oracle expert Guy Harrison, this is the first book to contain up-to-the-minute guidance for optimizing the performance of the new Oracle 11g Release 2. Harrison helps DBAs and developers quickly and efficiently optimize performance by focusing on causes rather than symptoms, and by identifying the areas that will deliver the greatest "bang for the buck" in their applications and environments. Product Description
Oracle Performance Survival Guide
A Systematic Approach to Database Optimization
The fast, complete, start-to-finish guide to optimizing Oracle performance
Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest "bang for the buck."
Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2.
You'll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance.
Coverage includes
. "Tuning by layers," the most effective, highest-value approach to Oracle performance optimization
. Making the most of Oracle's core tools for tracing, monitoring, and diagnosing performance
. Highly efficient database logical and physical design, indexing, transaction design, and API use
. SQL and PL/SQL tuning, including the use of parallel SQL techniques
. Minimizing contention for locks, latches, shared memory, and other database resources
. Optimizing memory and physical disk IO
. Tuning Real Application Cluster (RAC) databases
guyharrison.net
informit.com/ph
Features + Benefits
1) Offers a structured methodology for Oracle performance tuning that addresses performance issues in the most systematic and efficient manner possible. In particular, this methodology attempts to address causes rather than symptoms.
2) Addresses all realms of Oracle performance management; from application design, through SQL tuning, contention management and through to memory and physical IO management.
3) Maintains a strong focus on tuning fundamentals. Fundamentals are usually where the biggest performance gains can be found and - if not addressed - usually limit the benefits gained through the application of advanced techniques.
4) Will likely sell at least as well as the author's previous book on Oracle SQL High Performance Tuning, which has sold approximately 11,000 copies domestic to date.
Backcover
Oracle Performance Survival Guide
A Systematic Approach to Database Optimization
The fast, complete, start-to-finish guide to optimizing Oracle performance
Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest "bang for the buck."
Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2.
You'll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance.
Coverage includes
. "Tuning by layers," the most effective, highest-value approach to Oracle performance optimization
. Making the most of Oracle's core tools for tracing, monitoring, and diagnosing performance
. Highly efficient database logical and physical design, indexing, transaction design, and API use
. SQL and PL/SQL tuning, including the use of parallel SQL techniques
. Minimizing contention for locks, latches, shared memory, and other database resources
. Optimizing memory and physical disk IO
. Tuning Real Application Cluster (RAC) databases
guyharrison.net
informit.com/ph
Preface
Part I: Methods, Concepts, and Tools
Chapter 1. Oracle Performance Tuning: A Methodical Approach
A Brief History of Oracle Performance Tuning
Moving Beyond a Symptomatic Approach
Stage 1: Minimizing the Application Workload
Stage 2: Reducing Contention and Bottlenecks
Stage 3: Reducing Physical IO
Stage 4: Optimizing Disk IO
Summary
Chapter 2. Oracle Architecture and Concepts
The Oracle APIs
Creating the Cursor
Checking for Cached SQL Statements
Parsing the SQL
Associating Bind Variables
Executing the SQL
Fetching Rows
Using Array Fetch
Processing Result Sets
Closing the Cursor
Optimizing Oracle API Calls
The Oracle Query Optimizer
Cost Based Optimization
Optimizer Goal
Optimizer Statistics
Bind Variable Peeking and Adaptive Cursor Sharing
Hints
Outlines, Profiles, and Baselines
Transactions and Locking
Oracle Server Architecture
Instances and Databases
The System Global Area
Data Caching
The Program Global Area
Memory Management
Segments and Files
Tables
Indexes
Blocks, Extents, Segments, and Partitions
Tablespaces and Data Files
Undo Segments
Redo Logs and Archive Logs
Flashback Logs
Server Processes
Background Processes
Real Application Clusters
Summary
Chapter 3. Tools of the Trade
Explaining SQL Statements
The Plan Table
Exploiting Cached SQL
DBMS_XPLAN
Interpreting the Execution Plan
Virtual Indexing
Tracing Oracle Execution
Tracing from Within Your Session
Identifying Your Trace File
Getting Tracing Status
Invoking Trace in Another Session
Tracing by MODULE, ACTION, or SERVICE
Starting a Trace Using a Login Trigger
Finding the Trace File
Other Specialized Traces
Formatting Traces with tkprof
The tkprof Sort Options
Other tkprof Options
Merging Multiple SQL Trace Files
Interpreting Tkprof Output
Execution Plans in tkprof
Wait Statistics and tkprof
Alternatives to tkprof
Using AUTOTRACE in SQL*PLUS
Monitoring the Oracle Server
The V$ table interface
Wait Interface
The Time Model
Integrating the Time Model and Wait Interface
Oracle Enterprise Manager
Spotlight on Oracle
Summary
Part II: Application and Database Design
Chapter 4. Logical and Physical Database Design
Logical Data Modeling
Normalization and Third Normal Form
Data Type Choices
Artificial Keys
Data Warehouse Design
Logical to Physical
Mapping Entities or Classes to Tables
Choosing a Table Type
Data Types and Precisions
Optional Attributes and NULL Values
Column Order
Exploiting Oracle Object Types
Denormalization
Replicating Column Values to Avoid Joins
Summary Tables
Vertical Partitioning
Implementing Denormalization
Star Schema Design
Star Schema Basics
Snowflakes Schemas
Dimension Hierarchies
Aggregations and Materialized Views
Materialized View Best Practices
Physical Storage Options
Manual and Automatic Segment Storage Management
Concurrent Inserts and Freelists
PCTFREE and PCTUSED
Compression
LOB Storage
Oracle Partitioning
Types of Partitions
Composite Partitions
Choosing a Partitioning Strategy
Enterprise Manager Partitioning Advisor
Summary
Chapter 5. Indexing and Clustering
Overview of Oracle Indexing and Clustering
B*-Tree Indexes
Index Selectivity
Unique Indexes
Implicit Indexes
Concatenated Indexes
Index Skip Scans
Guidelines for Concatenated Indexes
Index Merges
Null Values in Indexes
Reverse Key Indexes
Index Compression
Functional Indexes
Foreign Keys and Locking
Indexes and Partitioning
Bitmap Indexes
Features of Bitmap Indexes
Drawbacks of Bitmap Indexes
Bitmap Indexes and Cardinality
Bitmap Index Merge
Bitmap Join Indexes
Index Overhead
Index Organized Tables
Configuring the Overflow Segment
Periodic Rebuild of Index Only Tables
Clustering
Index Clusters
Hash Clusters
Nested Tables
Choosing the Best Indexing Strategy
Summary
Chapter 6. Application Design and Implementation
SQL Statement Management
Optimizing Parsing
Avoiding Unnecessary SQL Executions
The Array Interface
Implementing Array Fetch
Array Insert
Transaction Design
Isolation Levels
Transactions and Locks
Row Level Locking in Oracle
Application Locking Strategies
Using Stored Procedures to Reduce Network Traffic
Summary
Part III: SQL and PL/SQL Tuning
Chapter 7. Optimizing the Optimizer
The Oracle Optimizer
What Is Cost?
Optimizer Goal
Selectivity and Cardinality
Query Transformation
Cost Calculations
Object Statistics
Histograms
Bind Variable Peeking
Adaptive Cursor Sharing
Database Parameters
System Stati
Oracle Performance Survival Guide
A Systematic Approach to Database Optimization
The fast, complete, start-to-finish guide to optimizing Oracle performance
Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest "bang for the buck."
Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2.
You'll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance.
Coverage includes
. "Tuning by layers," the most effective, highest-value approach to Oracle performance optimization
. Making the most of Oracle's core tools for tracing, monitoring, and diagnosing performance
. Highly efficient database logical and physical design, indexing, transaction design, and API use
. SQL and PL/SQL tuning, including the use of parallel SQL techniques
. Minimizing contention for locks, latches, shared memory, and other database resources
. Optimizing memory and physical disk IO
. Tuning Real Application Cluster (RAC) databases
guyharrison.net
informit.com/ph
Features + Benefits
1) Offers a structured methodology for Oracle performance tuning that addresses performance issues in the most systematic and efficient manner possible. In particular, this methodology attempts to address causes rather than symptoms.
2) Addresses all realms of Oracle performance management; from application design, through SQL tuning, contention management and through to memory and physical IO management.
3) Maintains a strong focus on tuning fundamentals. Fundamentals are usually where the biggest performance gains can be found and - if not addressed - usually limit the benefits gained through the application of advanced techniques.
4) Will likely sell at least as well as the author's previous book on Oracle SQL High Performance Tuning, which has sold approximately 11,000 copies domestic to date.
Backcover
Oracle Performance Survival Guide
A Systematic Approach to Database Optimization
The fast, complete, start-to-finish guide to optimizing Oracle performance
Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest "bang for the buck."
Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2.
You'll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance.
Coverage includes
. "Tuning by layers," the most effective, highest-value approach to Oracle performance optimization
. Making the most of Oracle's core tools for tracing, monitoring, and diagnosing performance
. Highly efficient database logical and physical design, indexing, transaction design, and API use
. SQL and PL/SQL tuning, including the use of parallel SQL techniques
. Minimizing contention for locks, latches, shared memory, and other database resources
. Optimizing memory and physical disk IO
. Tuning Real Application Cluster (RAC) databases
guyharrison.net
informit.com/ph
Preface
Part I: Methods, Concepts, and Tools
Chapter 1. Oracle Performance Tuning: A Methodical Approach
A Brief History of Oracle Performance Tuning
Moving Beyond a Symptomatic Approach
Stage 1: Minimizing the Application Workload
Stage 2: Reducing Contention and Bottlenecks
Stage 3: Reducing Physical IO
Stage 4: Optimizing Disk IO
Summary
Chapter 2. Oracle Architecture and Concepts
The Oracle APIs
Creating the Cursor
Checking for Cached SQL Statements
Parsing the SQL
Associating Bind Variables
Executing the SQL
Fetching Rows
Using Array Fetch
Processing Result Sets
Closing the Cursor
Optimizing Oracle API Calls
The Oracle Query Optimizer
Cost Based Optimization
Optimizer Goal
Optimizer Statistics
Bind Variable Peeking and Adaptive Cursor Sharing
Hints
Outlines, Profiles, and Baselines
Transactions and Locking
Oracle Server Architecture
Instances and Databases
The System Global Area
Data Caching
The Program Global Area
Memory Management
Segments and Files
Tables
Indexes
Blocks, Extents, Segments, and Partitions
Tablespaces and Data Files
Undo Segments
Redo Logs and Archive Logs
Flashback Logs
Server Processes
Background Processes
Real Application Clusters
Summary
Chapter 3. Tools of the Trade
Explaining SQL Statements
The Plan Table
Exploiting Cached SQL
DBMS_XPLAN
Interpreting the Execution Plan
Virtual Indexing
Tracing Oracle Execution
Tracing from Within Your Session
Identifying Your Trace File
Getting Tracing Status
Invoking Trace in Another Session
Tracing by MODULE, ACTION, or SERVICE
Starting a Trace Using a Login Trigger
Finding the Trace File
Other Specialized Traces
Formatting Traces with tkprof
The tkprof Sort Options
Other tkprof Options
Merging Multiple SQL Trace Files
Interpreting Tkprof Output
Execution Plans in tkprof
Wait Statistics and tkprof
Alternatives to tkprof
Using AUTOTRACE in SQL*PLUS
Monitoring the Oracle Server
The V$ table interface
Wait Interface
The Time Model
Integrating the Time Model and Wait Interface
Oracle Enterprise Manager
Spotlight on Oracle
Summary
Part II: Application and Database Design
Chapter 4. Logical and Physical Database Design
Logical Data Modeling
Normalization and Third Normal Form
Data Type Choices
Artificial Keys
Data Warehouse Design
Logical to Physical
Mapping Entities or Classes to Tables
Choosing a Table Type
Data Types and Precisions
Optional Attributes and NULL Values
Column Order
Exploiting Oracle Object Types
Denormalization
Replicating Column Values to Avoid Joins
Summary Tables
Vertical Partitioning
Implementing Denormalization
Star Schema Design
Star Schema Basics
Snowflakes Schemas
Dimension Hierarchies
Aggregations and Materialized Views
Materialized View Best Practices
Physical Storage Options
Manual and Automatic Segment Storage Management
Concurrent Inserts and Freelists
PCTFREE and PCTUSED
Compression
LOB Storage
Oracle Partitioning
Types of Partitions
Composite Partitions
Choosing a Partitioning Strategy
Enterprise Manager Partitioning Advisor
Summary
Chapter 5. Indexing and Clustering
Overview of Oracle Indexing and Clustering
B*-Tree Indexes
Index Selectivity
Unique Indexes
Implicit Indexes
Concatenated Indexes
Index Skip Scans
Guidelines for Concatenated Indexes
Index Merges
Null Values in Indexes
Reverse Key Indexes
Index Compression
Functional Indexes
Foreign Keys and Locking
Indexes and Partitioning
Bitmap Indexes
Features of Bitmap Indexes
Drawbacks of Bitmap Indexes
Bitmap Indexes and Cardinality
Bitmap Index Merge
Bitmap Join Indexes
Index Overhead
Index Organized Tables
Configuring the Overflow Segment
Periodic Rebuild of Index Only Tables
Clustering
Index Clusters
Hash Clusters
Nested Tables
Choosing the Best Indexing Strategy
Summary
Chapter 6. Application Design and Implementation
SQL Statement Management
Optimizing Parsing
Avoiding Unnecessary SQL Executions
The Array Interface
Implementing Array Fetch
Array Insert
Transaction Design
Isolation Levels
Transactions and Locks
Row Level Locking in Oracle
Application Locking Strategies
Using Stored Procedures to Reduce Network Traffic
Summary
Part III: SQL and PL/SQL Tuning
Chapter 7. Optimizing the Optimizer
The Oracle Optimizer
What Is Cost?
Optimizer Goal
Selectivity and Cardinality
Query Transformation
Cost Calculations
Object Statistics
Histograms
Bind Variable Peeking
Adaptive Cursor Sharing
Database Parameters
System Stati
Oracle Performance Survival Guide offers a structured methodology for optimizing Oracle performance in the most systematic and efficient manner possible. Authored by leading Oracle expert Guy Harrison, this is the first book to contain up-to-the-minute guidance for optimizing the performance of the new Oracle 11g Release 2. Harrison helps DBAs and developers quickly and efficiently optimize performance by focusing on causes rather than symptoms, and by identifying the areas that will deliver the greatest bang for the buck in their applications and environments.