{"product_id":"oracle-pl-sql-performance-tuning-tips-techniques-9780071824828","title":"Oracle PL\/SQL Performance Tuning Tips \u0026 Techniques","description":"\u003cp\u003e • Author(s): Michael Rosenblum\u003cbr\u003e • Publisher: McGraw-Hill Education\u003cbr\u003e • Publisher Imprint: McGraw-Hill Education\u003cbr\u003e • BISAC: Languages - SQL\u003c\/p\u003e\u003cp\u003ePublisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.\u003cbr\u003e\u003cbr\u003eProven PL\/SQL Optimization Solutions\u003c\/p\u003e\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\n\u003cli\u003eFollow a request-driven nine-step process to identify and address performance problems in web applications\u003c\/li\u003e\n\u003cli\u003eUse performance-related database tools, including data dictionary views, logging, tracing, PL\/SQL Hierarchical Profiler, PL\/Scope, and RUNSTATS \u003c\/li\u003e\n\u003cli\u003eInstrument code to pinpoint performance issues using call stack APIs, error stack APIs, and timing markers\u003c\/li\u003e\n\u003cli\u003eEmbed PL\/SQL in SQL and manage user-defined functions \u003c\/li\u003e\n\u003cli\u003eEmbed SQL in PL\/SQL using a set-based approach to handle large volumes of data \u003c\/li\u003e\n\u003cli\u003eProperly write and deploy data manipulation language triggers to avoid performance problems\u003c\/li\u003e\n\u003cli\u003eWork with advanced datatypes, including LOBs and XML\u003c\/li\u003e\n\u003cli\u003eUse caching techniques to avoid redundant operations\u003c\/li\u003e\n\u003cli\u003eEffectively use dynamic SQL to reduce the amount of code needed and streamline system management\u003c\/li\u003e\n\u003cli\u003eManage version control and ensure that performance fixes are successfully deployed\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eCode examples in the book are available for download. \u003c\/p\u003e","brand":"McGraw-Hill Education","offers":[{"title":"Paperback","offer_id":45116037759127,"sku":"9780071824828","price":6052.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9780071824828.webp?v=1767143531","url":"https:\/\/atlanticbooks.com\/products\/oracle-pl-sql-performance-tuning-tips-techniques-9780071824828","provider":"Atlantic Books","version":"1.0","type":"link"}