Oracle PL/SQL Performance Tuning Tips & Techniques

$60.00 $44.12

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

Quantity

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.

Frequently Bought Together

  • Oracle PL/SQL Performance Tuning Tips & Techniques
    +
  • Troubleshooting Oracle Performance
    +
  • Oracle Database 12c New Features
    +
  • Oracle Database 12c Performance Tuning Recipes: A Problem-Solution Approach (Expert's Voice in Oracle)
  • Price for all: $127.07
Author

Michael Rosenblum, Paul Dorsey

Binding

Paperback

EAN

9780071824828

EANList

9780071824828

Edition

1

ISBN

0071824820

IsEligibleForTradeIn

1

ItemDimensions

70, hundredths-inches, 900, hundredths-inches, 125, hundredths-pounds, 730, hundredths-inches

Label

Mcgraw-Hill Osborne Media

Languages

English, Unknown, English, Original Language, English, Published

Manufacturer

Mcgraw-Hill Osborne Media

NumberOfItems

1

NumberOfPages

336

ProductGroup

Book

PublicationDate

2014-08-13

Publisher

Mcgraw-Hill Osborne Media

Studio

Mcgraw-Hill Osborne Media

TradeInValue

1287, USD, $12.87