Oracle PL/SQL performance tuning tips & techniques
By: Michael Rosenblum and Dr. Paul Dorsey
Contributors: Dorsey, Paul, author
Publisher: McGraw-Hill Education; McGraw Hill
Published: 2014
Language: eng
Number of pages: 306
ISBN-13: 9780071824828
Subjects: PL/I (Computer program language); SQL/ORACLE (Computer program language)
Description: "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"--
Notes: Includes index.

"Oracle Press book."
Table of contents: title: The role of PL/SQL in contemporary development; title: DBA/Developer Borderline: tools and features; title: Code instrumentation in PL/SQL; title: Expanding the SQL horizons; title: Thinking in sets; title: Pulling the trigger; title: Going beyond scalar dataypes; title: Keepind the cache; title: Shooting at a moving target; title: Tales from the trenches; title: Code management in real-world systems; title: Extra tips, tricks, and ideas.