Oracle PL/SQL Tuning: Expert Secrets for High Performance Programming

Front Cover
Rampant TechPress, 2006 - Computers - 301 pages
3 Reviews
Oracle experts know that PL/SQL tuning makes a huge difference in execution speed. As one of the world's most popular and respected experts, Dr. Tim Hall shares his secrets for tuning Oracle PL/SQL. This indispensable book shows how to hypercharge Oracle applications gaining as much as 30x improvement in execution speed using under-documented code tricks. Packed with working examples, learn how to re-write SQL into PL./SQL and how to use advanced Oracle bulk array processing techniques to achieve super high performance. You can save your company millions of dollars in hardware costs by making your applications run at peak efficiency. Targeted at the Senior Oracle DBA and developer, this advanced book illustrates powerful techniques that can make PL/SQL run faster than ever before. This book is not for beginners and should only be purchased by seasoned Oracle professionals who must turbocharge their applications. Your time savings from a single script is worth the price of this great book.
 

What people are saying - Write a review

User Review - Flag as inappropriate

It's a very easy to understand and provided great concept through simplest example. At the end of the day it will make you expert in Oracle Tuning.
Enjoy,
Shailendra Nagina
OCA(OC1087536)
 

Contents

Using the Online Code Depot
1
My Ideal Environment
35
Bulk binds in PLSQL
52
Implicit vs explicit cursors
59
Duplication of builtin string functions
67
Efficient function calls
75
Using PLS_INTEGER and BINARY_INTEGER types
82
Decoupling cheating for performance
91
Dynamic SQL and Bulk Operations
135
Using Package Variables to Store Global Data
148
Conclusion
162
Defining Cursor Variables
175
Host Variables as Cursor Variables
192
Introduction
205
Deterministic Functions in PLSQL
223
Introduction to PLSQL Monitoring
228

Conclusion
97
FORALL in PLSQL
113
BULK_ROWCOUNT
126
Identifying the Impact of Code at the Database Level
274
Conclusion
299
Copyright

Other editions - View all

Common terms and phrases

About the author (2006)

Dr. Timothy Hall is an Oracle Certified Professional DBA who has published more than 200 Oracle-related articles on www.oracle-base.com.

Bibliographic information