Oracle PL/SQL Performance Tuning Tips & Techniques, (Paperback)
Oracle PL/SQL Performance Tuning Tips & Techniques, (Paperback)
Hero image 0 of Oracle PL/SQL Performance Tuning Tips & Techniques, (Paperback), 0 of 1

Oracle PL/SQL Performance Tuning Tips & Techniques, (Paperback)

(No ratings yet)

Key item features

  • Oracle PL/SQL Performance Tuning Tips & Techniques, (Paperback)
  • Author: Michael Rosenblum
  • ISBN: 9780071824828
  • Format: Paperback
  • Publication Date: 2014-08-13
  • Page Count: 336

Specs

Publication date, August, 2014Author, Michael RosenblumBook format, PaperbackGenre, Computing & InternetPages, 336Age group, Adult

About this item

Product details

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

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.

  • Oracle PL/SQL Performance Tuning Tips & Techniques, (Paperback)
  • Author: Michael Rosenblum
  • ISBN: 9780071824828
  • Format: Paperback
  • Publication Date: 2014-08-13
  • Page Count: 336
info:
We aim to show you accurate product information. Manufacturers, suppliers and others provide what you see here, and we have not verified it.  

Specifications

Publication date

August, 2014

Author

Michael Rosenblum

Book format

Paperback

Genre

Computing & Internet

Warranty

Warranty information

Please be aware that the warranty terms on items offered for sale by third party Marketplace sellers may differ from those displayed in this section (if any). To confirm warranty terms on an item offered for sale by a third party Marketplace seller, please use the 'Contact seller' feature on the third party Marketplace seller's information page and request the item's warranty terms prior to purchase.

Customer ratings & reviews

0 out of 5 stars
0 ratings|0 reviews
This item does not have any reviews yet
Current price is $61.33
Price when purchased online
  • Free shipping
  • Free Holiday returns until Jan 31

How do you want your item?

How do you want your item?
Ships to
Arrives between Nov 24 - Nov 30
|
Sold and shipped by Alibris Books
4.584860298895387 out of 5 stars
4.6 stars out of 5, based on 15390 seller reviews(4.6)
Extended holiday returns
Free Holiday returns until Jan 31

More seller options (1)

Starting from $57.20