| |
| Title: |
Five Top Tips for Highly-Performant PL/SQL |
| Presenter: |
Peter Koletzke |
| Organization: |
Independent |
| |
| Summary: |
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. 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 those 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 presentation explains to both of these audiences, and groups in between, 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. |
| |
| Topic: |
Developer
Database/DBaaS Administration
|
| Session Type: |
One Hour Session |
| Target Audience: |
|
| Experience Level: |
|
| Session: |
7: 02/13/2025 8:30 am to 9:30 am |
| Location: |
Room 100C |
| |
| Biographical Sketch: |
Peter Koletzke is an Oracle ACE Director who has worked for over 39 years in the IT industry and has presented at various Oracle technology conferences around the world over 410 times. Additionally, he has won over a dozen user group awards from ODTUG, NYOUG, UTOUG, and ECO/SEOUC. Peter is also an Oracle Certified Master, UTOUG board member, member of the NYOUG steering committee, 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. |
| |
| |
