Oracle PL/SQL Performance Tuning Tips & Techniques

<h4>Proven PL/SQL Optimization Solutions</h4><p>In <i>Oracle PL/SQL Performance Tuning Tips & Techniques</i> 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.</p><ul> <li>Follow a request-driven nine-step process to identify and address performance problems in web applications</li><li>Use performance-related database tools including data dictionary views logging tracing PL/SQL Hierarchical Profiler PL/Scope and RUNSTATS</li><li>Instrument code to pinpoint performance issues using call stack APIs error stack APIs and timing markers</li><li>Embed PL/SQL in SQL and manage user-defined functions</li><li>Embed SQL in PL/SQL using a set-based approach to handle large volumes of data</li><li>Properly write and deploy data manipulation language triggers to avoid performance problems</li><li>Work with advanced datatypes including LOBs and XML</li><li>Use caching techniques to avoid redundant operations</li><li>Effectively use dynamic SQL to reduce the amount of code needed and streamline system management</li><li>Manage version control and ensure that performance fixes are successfully deployed</li></ul><p>Code examples in the book are available for download.</p>