Oracle Performance Tuning for 10gR2 (Paperback, 2nd edition)

Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.
Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results.
* Fully updated for version 10gR2 and provides all necessary transition material from version 9i
* Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning
* Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective

General

Imprint:	Digital Press
Country of origin:	United Kingdom
Release date:	October 2006
First published:	September 2006
Authors:	Gavin JT Powell
Dimensions:	235 x 178 x 37mm (L x W x T)
Format:	Paperback
Pages:	960
Edition:	2nd edition
ISBN-13:	978-1-55558-345-3
Categories:	Books > Computing & IT > Computer software packages > Database software > Oracle
LSN:	1-55558-345-8
Barcode:	9781555583453

Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

Does this product have an incorrect or missing image? Send us a new image.

Is this product missing categories? Add more categories.

Review This Product

No reviews yet - be the first to create one!