Presentation Title: Ten Rules for Doing a PL/SQL Performance Experiment
Speaker: Mr Bryn Llewellyn OakTable Member
Company: Oracle
Presentation abstract: I’ve all too often been asked to comment on a speed difference between two PL/SQL tests where each is presented to me as just SQL*Plus spool files (prompts and all). Sometimes this is copied and pasted into the text of an email. Often, the text of the second spool file differs from the text of the first in just a couple of tiny details. Worst of all, the times are measured, for just a single test run, using SET TIMING ON. And the times are shown, like “Elapsed: 00:00:12.36”, with indefensible precision. Sometimes the times are shorter. This is no way to conduct a performance experiment! This session tells you how to do your experiment properly with reference to a real, and interesting, case study. I said “PL/SQL” in the title, because that’s what I’m known for. But really, I’m talking about any single-user test that runs entirely inside Oracle Database. And I said “ten rules” because a talk has to have a catchy title. Of course there are many more rues than just ten.
Presentation begins: 03/12/2017 13:40
Presentation duration: 50
Presentation content level: 2 (1 = indepth, 5 = strategic overview)
Audience experience: All Experience Levels
Audience function: Oracle, Product User
Speaker biography: Bryn Llewellyn has worked in the software field for more than thirty-five years. He joined Oracle UK in 1990 at the European Development Center to work on the Oracle Designer team. He transferred to the Oracle Text team and then into consulting as the text specialist for Europe. He relocated to Redwood Shores in 1996 to join the Oracle Text Technical Marketing Group. He has been the product manager for PL/SQL since 2001. In 2005, he became responsible, additionally, for edition-based redefinition (EBR for short). This is the Oracle Database capability that supports online application upgrade.
Related topics: Database Development: Development Practices, Database Development: Mobile, Database Development: Technology, Database Development: Tools, Database Development: Web
Hall: Executive Room 2