Ten (other) Top Tips for Improving PL/SQL Performance

Bulk processing (FORALL and BULK COLLECT), along with the function result cache, are the "big ticket" items when it comes to performance optimization with PL/SQL. But there's still more we can do to tweak our code for even better response times for our users. This third webcast in the performance series starts with the automatic compiler optimization,showcases the extraordinary speediness of PGA data manipulation (a.k.a., package variables) and demonstrates the effect of the simple NOCOPY hint. We finish up with an introduction to pipelined table functions and some thoughts on optimizing your algorithms.