Pearson logo always learning logo

  Home > Oracle Certification >

Oracle PL/SQL Performance Tuning Tips & Techniques

Oracle PL/SQL Performance Tuning Tips & Techniques
 
List Price: $60.00
Our Price: $54.00
You save $6.00!


Product Code: 978-0-07-182482-8
Qty:

Description
 
Product Details

Book
  • ISBN-10: 0-07-182482-0
  • ISBN-13: 978-0-07-182482-8
  • Copyright 2014
  • Dimensions: 7.3" x 9"
  • Pages: 336
  • Edition: 1st


Proven PL/SQL Optimization Solutions

In Oracle 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

Share your knowledge of this product with other customers... Be the first to write a review

Browse for more products in the same category as this item:

Oracle Certification

GET SOCIAL!

Join the conversation for special offers and coupons!

JOIN OUR MAILING LIST

Get exclusive offers, sales and
special deals delivered to your inbox!