BEGIN:VCALENDAR VERSION:2.0 PRODID:-//173.231.211.74//NONSGML kigkonsult.se iCalcreator 2.26.9// CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALNAME:New York Oracle User Group X-WR-CALDESC:NYOUG X-FROM-URL:https://nyoug.org X-WR-TIMEZONE:America/New_York BEGIN:VTIMEZONE TZID:America/New_York X-LIC-LOCATION:America/New_York BEGIN:STANDARD DTSTART:20231105T020000 TZOFFSETFROM:-0400 TZOFFSETTO:-0500 RDATE:20241103T020000 TZNAME:EST END:STANDARD BEGIN:DAYLIGHT DTSTART:20240310T020000 TZOFFSETFROM:-0500 TZOFFSETTO:-0400 RDATE:20250309T020000 TZNAME:EDT END:DAYLIGHT END:VTIMEZONE BEGIN:VEVENT UID:ai1ec-2921@nyoug.org DTSTAMP:20240329T123919Z CATEGORIES: CONTACT: DESCRIPTION:PL/SQL 101: 5+ Basic Tips for Highly-Performant Code\nSpeaker: Peter Koletzke\nDescription\nEfficient applications require the best perf ormance from all components used to present the application. If you are us ing cloud services\, tuning of some components is out of your control. Sti ll\, regardless of your use of cloud\, your job as an application develope r 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 tha n to have to fix the code later when you find that it isn’t performing wel l in production.\nA small set of PL/SQL coding techniques that help perfor mance have been developed by developers in the Oracle community over the y ears\, 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 re view of the performance techniques they have been using.\nThis 101 present ation explains to both of these audiences the basic techniques for creatin g the most efficient PL/SQL code\, for example\, caching local variables\, iteration handling\, reducing context switching\, datatype selection\, an d various methods for cursor handling. Sample code will illustrate the pri nciples.\nPresenter Biography:\nPeter Koletzke is an Oracle ACE Director w ho has worked for over 38 years in the IT industry and has presented at va rious Oracle technology conferences around the world nearly 390 times. Add itionally\, he has won over a dozen user group awards from NYOUG\, UTOUG\, ODTUG\, and ECO/SEOUC. Peter is also an Oracle Certified Master\, UTOUG b oard 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 JDevel oper/ADF\, Oracle Forms and Reports\, and Oracle Designer.\n—\nThis 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 ) DTSTART;TZID=America/New_York:20220906T120000 DTEND;TZID=America/New_York:20220906T130000 SEQUENCE:0 SUMMARY:PL/SQL 101: 5+ Basic Tips for Highly-Performant Code URL:https://nyoug.org/event/pl-sql-101-5-basic-tips-for-highly-performant-c ode/ X-COST-TYPE:free X-ALT-DESC;FMTTYPE=text/html:\\n\\n
\\nPL/SQL 101: 5+ Basic Tips for Highly-Performant Code
\nSpeaker: Peter Koletzke
\nA small set of PL/SQL coding techniques that help performance have been d eveloped 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 perfo rmance techniques they have been using.
\nThis 101 presentation expl ains 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. p>\n
Presenter Biography:
\nPeter Koletzke is an Oracle ACE Directo
r 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\, UTOU
G\, ODTUG\, and ECO/SEOUC. Peter is also an Oracle Certified Master\, UTOU
G board member\, past board member of IOUG and NYOUG\, and co-author of ei
ght books – with Duncan Mills\, Avrom Roy-Faderman\, and Dr. Paul Dorsey a
nd published by Oracle Press (McGraw-Hill Professional) — about Oracle JDe
veloper/ADF\, Oracle Forms and Reports\, and Oracle Designer.
\n—
\nThis 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)