{"product_id":"oracle-performance-tuning-for-10gr2-9781555583453","title":"Oracle Performance Tuning for 10gR2","description":"\u003cp\u003e • Author(s): Gavin Jt Powell\u003cbr\u003e • Publisher: Digital Press\u003cbr\u003e • Publisher Imprint: Digital Press\u003cbr\u003e • BISAC: Database Administration \u0026amp; Management\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eTuning 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.\u003c\/p\u003e \u003cp\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.\u003c\/p\u003e","brand":"Digital Press","offers":[{"title":"Paperback","offer_id":45309983785111,"sku":"9781555583453","price":5678.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9781555583453.webp?v=1769286741","url":"https:\/\/atlanticbooks.com\/products\/oracle-performance-tuning-for-10gr2-9781555583453","provider":"Atlantic Books","version":"1.0","type":"link"}