Troubleshooting Oracle Performance
The Oracle database engine has become a huge piece of software. This not only means that a single human can no longer be proficient in using all the features provided in recent versions, but it also means that some of them will rarely be used. Actually, in most situations, it is enough to know and take advantage of a limited number of core features in order to use the Oracle da- base engine efficiently and successfully. This is precisely why in this book I will cover only the features that, based on my experience, are necessary to troubleshoot most of the databa- related performance problems you will encounter. Structure of This Book This book is divided into five parts: Part 1 covers some basics that are required to read the rest of the book. Chapter 1, “Perf- mance Problems,” explains not only why it is essential to approach performance problems at the right moment and in a methodological way but also why understanding business needs and problems is essential. Chapter 2, “Key Concepts,” describes the operations carried out by the database engine when parsing and executing SQL statements. It also introduces some terms that are frequently used in the book. Part 2 explains how to approach performance problems in an environment that is based on the Oracle database engine. Chapter 3, “Identifying Performance Problems,” provides a detailed analysis road map for identifying performance problems. Several tools and te- niques that can be used with it are also described.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Other editions - View all
A-Rows ACCESS BY INDEX access path application B-tree bind variables bitmap indexes Buffers Chapter child cursor clause client column configuration CREATE data dictionary Database 10g Release database engine datatype default value described enabled execution plan EXPLAIN PLAN Figure following example following query FULL SCAN full table scan function gathering HASH JOIN hints histograms INDEX RANGE SCAN INDEX ROWID index scan initialization parameter JDBC library cache logical reads materialized view Name nested loop joins NESTED LOOPS Note NULL number of logical number of rows object statistics Oracle Database 10g Oracle9i package dbms_stats parse partition pruning PARTITION RANGE performance problems PL/SQL possible primary key provides Pstart query optimizer query rewrite result cache script shows SELECT STATEMENT server slave processes specified SQL plan baseline SQL profile SQL statement SQL trace sql_id statement caching STATEMENT_ID stored outline TABLE ACCESS FULL TKPROF trace file