PL/SQL 101: 5+ Basic Tips for Highly-Performant Code

Efficient applications require the best performance from all components used to present the application. If you are using cloud services, tuning of some components is out of your control. Still, regardless of your use of cloud, your job as an application developer is to ensure that your database code runs as efficiently as possible. It is so much easier to create highly performant code in the first place than to have to fix the code later when you find that it isn’t performing well in production.

A small set of PL/SQL coding techniques that help performance have been developed by developers in the Oracle community over the years, but those who are relatively new to the language may not have been exposed to them. Those who have experience with PL/SQL may appreciate a review of the performance techniques they have been using.

This 101 presentation explains to both of these audiences the basic techniques for creating the most efficient PL/SQL code, for example, caching local variables, iteration handling, reducing context switching, datatype selection, and various methods for cursor handling. Sample code will illustrate the principles.

Presenter Biography:
Peter Koletzke is an Oracle ACE Director who has worked for over 38 years in the IT industry and has presented at various Oracle technology conferences around the world nearly 390 times. Additionally, he has won over a dozen user group awards from NYOUG, UTOUG, ODTUG, and ECO/SEOUC. Peter is also an Oracle Certified Master, UTOUG board member, past board member of IOUG and NYOUG, and co-author of eight books – with Duncan Mills, Avrom Roy-Faderman, and Dr. Paul Dorsey and published by Oracle Press (McGraw-Hill Professional) — about Oracle JDeveloper/ADF, Oracle Forms and Reports, and Oracle Designer.
—
This event is co-hosted by the New York Oracle Users Group (www.nyoug.org) and Oracle Professional Services firm, Viscosity North America (www.viscosityna.com)