close

Oracle Performance Tuning for 10gR2

Gavin Powell · ISBN 9781555583453
Oracle Performance Tuning for 10gR2 | Zookal Textbooks | Zookal Textbooks
Out of stock
$113.95  Save $13.70
$100.25
-
+
Zookal account needed
Read online instantly with Zookal eReader
Access online & offline
$95.65
Note: Subscribe and save discount does not apply to eTextbooks.
-
+
Publisher Digital Press
Author(s) Gavin Powell
Edition 2
Published 15th September 2006
Related course codes
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.
Translation missing: en.general.search.loading