{"product_id":"9780071780278","title":"Oracle Database 11g Release 2 Performance Tuning Tips \u0026 Techniques","description":"Implement Proven Database Optimization Solutions  \u003cp\u003eSystematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, \u003ci\u003eOracle Database 11g Release 2 Performance Tuning Tips \u0026amp; Techniques\u003c\/i\u003e details the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL\/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide.\u003c\/p\u003e  \u003cul\u003e \u003cli\u003eProperly index and partition Oracle Database 11\u003ci\u003eg\u003c\/i\u003e Release 2\u003c\/li\u003e  \u003cli\u003eWork with Oracle Exadata and Oracle Exalogic Elastic Cloud\u003c\/li\u003e  \u003cli\u003eEfficiently manage disk drives, RAID arrays, and memory\u003c\/li\u003e  \u003cli\u003eTune queries with Oracle SQL hints and the TRACE utility\u003c\/li\u003e  \u003cli\u003eTroubleshoot databases using V$ views and X$ tables\u003c\/li\u003e  \u003cli\u003eDistribute workload using Oracle Real Application Testing\u003c\/li\u003e  \u003cli\u003eGenerate reports using Oracle's Statspack and Automatic Workload Repository tools\u003c\/li\u003e  \u003cli\u003eUse sar, vmstat, and iostat to monitor system statistics\u003c\/li\u003e  \u003c\/ul\u003e  \u003cp\u003e“This is a timely update of Rich’s classic book on Oracle Database performance tuning to cover hot new topics like Oracle Database 11g Release 2 and Oracle Exadata. This is a must-have for DBAs moving to these new products.” --Andrew Mendelsohn, Senior Vice President, Oracle Database Server Technologies\u003c\/p\u003e","brand":"McGraw Hill LLC","offers":[{"title":"Default Title","offer_id":47076901880048,"sku":"9780071780278","price":72.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780071780278_p0.jpg?v=1763636004","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780071780278","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}