The Art and Science of Oracle Performance Tuning
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 prescriptionit involves matching application-specific knowledge with what's...
Search in google:
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 prescriptionit involves matching application-specific knowledge with what's happening inside the database. Based on author Christopher Lawson's long experience working with Oracle, The Art and Science of Oracle Performance Tuning book uses a five-step model to help identify and isolate the cause of nonperformance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success.
Introduction1Ch. 1The Challenge of Performance Tuning5Ch. 2Why Many Tuning Strategies Fail25Ch. 3The Oracle Physician53Ch. 4Dealing with Humans73Ch. 5The Oracle Detective95Ch. 6Gathering More Clues129Ch. 7The Oracle Pathologist159Ch. 8Analyzing SQL Bottlenecks189Ch. 9Analyzing SQL Joins227Ch. 10The Pathologist's Toolkit: Other Tactics269Ch. 11The Oracle Artist317Ch. 12The Artist's Palette: More on Devising Solutions357Ch. 13The Oracle Magician387Ch. 14Case Studies409App. AUseful V$ View Definitions429Index439
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
