The Art and Science of Oracle Performance

Christopher Lawson

460 pages, parution le 03/03/2003

Ajouter à une liste

Indisponible

Résumé

The Art and Science of Oracle Performance Tuning:

Complete and approachable guide to tuning best practice
For novice to intermediate Oracle DBAs and developers

Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding the technology. It is more than tweaking parameters, or following a set prescription – it involves matching application-specific knowledge with what's happening inside the database.

Based on the author's long experience working with Oracle, the book uses a five-step model to help identify and isolate the cause of non-performance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success.

The Art and Science of Oracle Performance Tuning shows you:

A proven process for performance tuning
How to objectively categorize the problem
The human and business aspects of tuning as well as the technical know-how
How to trace problems to their root cause
Analyzing the cost of SQL statements
Gathering statistics – achieving quantifiable results
Devising and testing a solution
Case studies throughout illustrate key points

Curlingstone is a new imprint providing practical information on all aspects of the technology, techniques, and job roles that form the database community.

Contents

The Challenge of Performance Tuning
Why many Tuning Strategies Fail
The Oracle Physician
Dealing with Humans
The Oracle Detective
Gathering more Clues
The Oracle Pathologist
Analysing SQL Bottlenecks
Analysing SQL Joins
The Pathologist Toolkit: Other Tactics

Caractéristiques techniques

	PAPIER
Éditeur(s)	Curlingstone
Auteur(s)	Christopher Lawson
Parution	03/03/2003
Nb. de pages	460
Format	15 x 22,5
Couverture	Broché
Poids	635g
Intérieur	Noir et Blanc
EAN13	9781904347019