Oracle performance tuning for 10gR2
By: Gavin Powell
Edition: 2nd ed.
Publisher: Digital Press
Published: 2007
Place of publication: Burlington, MA
Language: eng
Format: [elektronische middelen] /
Number of pages: 904
ISBN-13: 9780080492025
Subjects: Electronic books; Relational databases
Notes: Previous ed. published: New York : Digital Press, c2004, under title: Oracle high performance tuning for 9i and 10g.

Includes index.
Table of contents: title: Pt. 1. Data model turning; title: The relational database model; title: Turning the relational database model; title: Different forms of the relational database model; title: A brief history of data modeling; title: Pt. 2 SQL code tuning; title: What is SQL?; title: The basics of efficient SQL; title: Advanced concepts of efficient SQL; title: Common-sense indexing; title: Oracle SQL optimization and statistics; title: How Oracle SQL optimization works; title: Overriding optimizer behavior using hints; title: How to find problem queries; title: 10g automated SQL tuning; title: Pt. 3. Physical and configuration tuning; title: Tuning Oracle database file structures; title: Object tuning; title: Low-level physical tuning; title: Hardware resource usage tuning; title: Tuning network usage; title: Oracle partitioning and parallelism; title: Pt. 4. Tuning everything at once; title: Ratios: possible symptoms of problems; title: Wait events; title: Latches; title: Tools and utilities; title: The wait event interface; title: 9i tuning with STATSPACK.