You are cordially invited to join the BCOUG at our next Vancouver event on June 20, 2018.
Session 1
Topic: SQL Plan Baseline Methods and Use Cases
Speaker: Frank Liu, Save on Foods
Abstract
Have you seen a query that is hanging suddenly, when it normally run in seconds?
Have you seen a query that runs significantly slow after upgrade?
They are all related to plan regression, and it could impact user experience, or causing application outage in worst case.To address this issue, we need to understand plan regression, and use SQL plan management to stabilize execution plans.
This presentation discusses different methods to create a SQL baseline. These methods can be applied to different use cases, such as query with bind variables, query without bind variables, plan migration between databases, plan stabilization in upgrades, etc.
Session 2
Topic: APEX 18.1 New APIs
Speaker: Martin D'Souza, Insum Solutions
Abstract
APEX comes with a set of APIs that help simplify both your APEX and PL/SQL development. Most developers aren't aware of the many features in the set of APIs. This presentation will introduce the APEX APIs while highlighting some of the best APIs released as part of APEX 18.1.
About the Speakers
Frank Liu - Save on Foods
Frank is an Oracle certified professional. He has over 20 years development and database administration experience, currently working as database administrator.
He has worked on oracle upgrade, performance tuning, Oracle Internet Directory, Oracle Enterprise Security, and Exadata administration.
Martin D'Souza - Insum Solutions
Martin D'Souza is the director of innovation at Insum. He is also the founder of OraOpenSource. Throughout his career, Martin has held a range of positions within award-winning companies. His experience in the technology industry has been focused on developing database-centric web applications using the Oracle technology stack. Martin is the author of the popular blog talkapex.com and a designated Oracle ACE director. He has co-authored and authored various APEX books and is an active participant in a number of open-source projects, such as Logger. Martin has also presented at numerous international conferences such as APEX Connect, Oracle OpenWorld, and ODTUG Kscope.