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

NYOUG Webinar on September 6, 2022 presented by Peter Koletzke

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.

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.

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)