Oracle PL/SQL Performance Tuning Tips & Techniques

PARTICore Ideas and Elements of PL/SQL Performance Tuning

Introduction to Part I

Performance tuning is the process of making your code run faster. Usually this process is prompted by reports that a user interface action or batch routine is taking longer than expected. However, performance tuning is not just about fixing slow code. Poorly performing code is not “just” slow. It is slow because it consumes excess resources, which can affect not only the problem code, but also the system as a whole. Writing well-tuned code from the start is the best way to reduce the number of routines that can cause problems later, thereby improving the overall performance ...