Oracle PL/SQL Performance Tuning Tips & Techniques

Proven PL/SQL optimization solutions from Oracle Press Oracle PL/SQL Performance Tuning Tips & Techniques presents a hands-on approach to enabling better, faster, and safer results from PL/SQL. This is an intermediate guide for developers and programmers wanting to achieve profound results by deploy [...]
Visa längre beskrivning

Proven PL/SQL optimization solutions from Oracle Press Oracle PL/SQL Performance Tuning Tips & Techniques presents a hands-on approach to enabling better, faster, and safer results from PL/SQL. This is an intermediate guide for developers and programmers wanting to achieve profound results by deploying the latest and best methods for improving overall speed, reliability, and security. You will learn expert performance tuning methods that draw on decades of professional experience. A wide array of real-world examples are included. Coverage includes: The role of PL/SQL in contemporary development; The concept of performance tuning; DBA/developer borderline: tools/features/setup; Performance measuring techniques; Tuner's toolkit; Thinking in SETs; Pulling a trigger; Doing more; Do more with LESS; Keeping the cache; Shooting moving target; Effective utilization of PL/SQL in the web environment; Version control and editions; Tips, tricks and ideas