Troubleshooting Oracle Performance

Front Cover
Apress, Aug 20, 2008 - Computers - 586 pages

Here is a fantastic addition to Apress's ever-growing line of performance optimization titles for Oracle developers and database administrators written by internationally acclaimed experts. This book forges a strong link in the chain from performance problem to performance solution by giving readers a systematic method for solving problems once they've been identified. Christian Antognini's emphasis on planning for performance as an application requirement represents clear and fresh thinking on the problem of database performance. His use of roadmaps to provide a repeatable path from an identified problem to a solution makes his book genuinely helpful to readers who want more than a random collection of performance tips. Readers of Jonathan Lewis, Tom Kyte, Craig Shallahamer will welcome the chance to add Christian Antognini to their shelves.

 

Selected pages

Contents

9179ch01final
2
9179ch02final
13
9179ch03final
33
9179ch04final
107
9179ch05final
169
9179ch06final
195
9179ch07final
247
9179ch08final
306
9179ch09final
339
9179ch10final
409
9179ch11final
459
9179ch12final
527
9179AppAfinal
549
9179AppBfinal
563
9179INDXfinal
567
Copyright

Other editions - View all

Troubleshooting Oracle Performance
Christian Antognini
No preview available - 2011
Troubleshooting Oracle Performance
Christian Antognini
No preview available - 2008
Troubleshooting Oracle Performance
Christian Antognini
No preview available - 2008

Common terms and phrases

A-Rows ACCESS BY INDEX access path application B-tree bind variables bitmap indexes Buffers bytes child cursor 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 IDENTIFYING PERFORMANCE PROBLEMS INDEX RANGE SCAN INDEX ROWID 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 OPTIMIZING DATA ACCESS Oracle Database 10g Oracle9i package dbms_stats parse partition pruning PARTITION RANGE 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 stored outline T_PK TABLE ACCESS FULL TKPROF trace file

About the author (2008)

Since 1995, Christian Antognini has been focusing on understanding how the Oracle database engine works. His main interests range from logical and physical database design, to the integration of databases with Java applications, the query optimizer, and basically everything else related to performance management and tuning. He is working as a senior consultant and trainer at Trivadis AG in Z rich, Switzerland. If he is not helping one of his customers to get the most out of Oracle, he is somewhere lecturing on optimization or new Oracle database features for developers. He is member of the Trivadis Performance Team and of the OakTable Network).

Bibliographic information

TitleTroubleshooting Oracle Performance
Professional and Applied Computing
Apress Access Books
Professional and Applied Computing (R0)
AuthorChristian Antognini
Editionillustrated
PublisherApress, 2008
ISBN1430204982, 9781430204985
Length586 pages
Subjects ›  › 

Computers / Database Administration & Management
Computers / Information Technology
Computers / Software Development & Engineering / General
  
Export CitationBiBTeX EndNote RefMan