{"product_id":"oracle-performance-tuning-for-10gr2","title":"Oracle Performance Tuning for 10gR2","description":"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.\u003cbr\u003e\u003cbr\u003eGavin 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.\u003cbr\u003e\u003cbr\u003e* Fully updated for version 10gR2 and provides all necessary transition material from version 9i\u003cbr\u003e* Includes all three aspects of Oracle database tuning: data model tuning, SQL \u0026amp; PL\/SQL code tuning, physical plus configuration tuning\u003cbr\u003e* Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective","brand":"Elsevier S \u0026 T","offers":[{"title":"perpetual","offer_id":45192557396065,"sku":"9781555583453","price":34.5,"currency_code":"KWD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0268\/9869\/4241\/files\/480_65019df8-bed4-41e8-b9e3-bf72caf38ecd.jpg?v=1781564444","url":"https:\/\/ebooks.aafaqeducation.com\/products\/oracle-performance-tuning-for-10gr2","provider":"ebook.aafaqeducation","version":"1.0","type":"link"}