Gavin JT Powell, “Oracle Performance Tuning for 10gR2, Second Edition”
Digital Press | ISBN 1555583458 | September 15, 2006 | 960 Pages | PDF | 11.1 MB
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. (more…)