About Us

The British Columbia Oracle Users Group (BCOUG) is an independent, not for profit, organization created by users of Oracle software (DBAs, Developers, Analysts, and IT management) to enhance our knowledge and our communities in Vancouver, Victoria and the rest of B.C.

We support the community by organizing:

  • Education Seminars
  • Technical Presentations
  • Case Studies
  • Hands-on Workshops
  • Best Practice Symposiums
  • Special Guest Lectures
  • Networking Opportunities
  • Social Events

Upcoming Events

    Post-Tech Day Blues?

    June 20, 2018 06:00 PM - 09:00 PM

    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.

     

We thank our corporate sponsors for their contributions.