ShopSpell

Oracle PL/SQL Performance Tuning Tips & Techniques [Paperback]

$49.99     $60.00    17% Off      (Free Shipping)
88 available
  • Category: Books (Computers)
  • Author:  Dorsey, Paul, Rosenblum, Michael
  • Author:  Dorsey, Paul, Rosenblum, Michael
  • ISBN-10:  0071824820
  • ISBN-10:  0071824820
  • ISBN-13:  9780071824828
  • ISBN-13:  9780071824828
  • Publisher:  McGraw-Hill Education
  • Publisher:  McGraw-Hill Education
  • Binding:  Paperback
  • Binding:  Paperback
  • Pub Date:  01-Jul-2014
  • Pub Date:  01-Jul-2014
  • SKU:  0071824820-11-MPOD
  • SKU:  0071824820-11-MPOD
  • Item ID: 100238391
  • List Price: $60.00
  • Seller: ShopSpell
  • Ships in: 2 business days
  • Transit time: Up to 5 business days
  • Delivery by: Dec 31 to Jan 02
  • Notes: Brand New Book. Order Now.

Publisher'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.


Proven PL/SQL Optimization Solutions

InOracle PL/SQL Performance Tuning Tips & Techniques, 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.

  • Follow a request-driven nine-step process to identify and address performance problems in web applications
  • Use performance-related database tools, including data dictionary views, logging, tracing, PL/SQL Hierarchical Profiler, PL/Scope, and RUNSTATS
  • Instrument code to pinpoint performance issues using call stack APIs, error stack APIs, and timing markers
  • Embed PL/SQL in SQL and manage user-defined functions
  • Embed SQL in PL/SQL using a set-based approach to handle large volumes of data
  • Properly write and deploy data manipulation language triggers to avoid performance problems
  • Work with advanced datatypes, including LOBs and XML
  • Use caching techniques to avoid redundant operations
  • Effectively use dynamic SQL to reduce the amount of code needed and streamline system management
  • Manage version control and ensure that performance fixes are successfully deployed

Code examples in the book are available for download.

Part 1. Core ideas and elements of l“Y