{"product_id":"9780071822183","title":"Oracle PL\/SQL Performance Tuning Tips \u0026 Techniques","description":"Proven PL\/SQL Optimization Solutions  \u003cp\u003eIn \u003ci\u003eOracle PL\/SQL Performance Tuning Tips \u0026amp; Techniques\u003c\/i\u003e, Oracle ACE authors with decades of experience building complex production systems for government, industry, and educational organizations present a hands-on approach to enabling optimal results from PL\/SQL. The book begins by describing the discovery process required to pinpoint performance problems and then provides measurable and repeatable test cases. In-depth coverage of linking SQL and PL\/SQL is followed by deep dives into essential Oracle Database performance tuning tools. Real-world examples and best practices are included throughout this Oracle Press guide.\u003c\/p\u003e  \u003cul\u003e \u003cli\u003eFollow a request-driven nine-step process to identify and address performance problems in web applications\u003c\/li\u003e  \u003cli\u003eUse performance-related database tools, including data dictionary views, logging, tracing, PL\/SQL Hierarchical Profiler, PL\/Scope, and RUNSTATS\u003c\/li\u003e  \u003cli\u003eInstrument code to pinpoint performance issues using call stack APIs, error stack APIs, and timing markers\u003c\/li\u003e  \u003cli\u003eEmbed PL\/SQL in SQL and manage user-defined functions\u003c\/li\u003e  \u003cli\u003eEmbed SQL in PL\/SQL using a set-based approach to handle large volumes of data\u003c\/li\u003e  \u003cli\u003eProperly write and deploy data manipulation language triggers to avoid performance problems\u003c\/li\u003e  \u003cli\u003eWork with advanced datatypes, including LOBs and XML\u003c\/li\u003e  \u003cli\u003eUse caching techniques to avoid redundant operations\u003c\/li\u003e  \u003cli\u003eEffectively use dynamic SQL to reduce the amount of code needed and streamline system management\u003c\/li\u003e  \u003cli\u003eManage version control and ensure that performance fixes are successfully deployed\u003c\/li\u003e  \u003c\/ul\u003e  \u003cp\u003eCode examples in the book are available for download.\u003c\/p\u003e","brand":"McGraw Hill LLC","offers":[{"title":"Default Title","offer_id":46458299285745,"sku":"9780071822183","price":69.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0674\/5433\/7265\/files\/9780071822183_p0.jpg?v=1765832442","url":"https:\/\/shop.barnesandnoble.com\/products\/9780071822183","provider":"Barnes \u0026 Noble","version":"1.0","type":"link"}