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

    Monitoring and Killing Blocking Sessions

    February 07, 2019 06:00 PM - 09:00 PM

    You are cordially invited to join the BCOUG at our next Vancouver event on February 7, 2019.

     

    Session 1

    Topic: Monitoring and Killing Blocking Sessions

    Speaker: Karl Shen, Aviso Wealth

    Abstract

    When migrating to the new ODA in summer 2018, we encountered blocking session issues. The blocked sessions are from waiting classes Concurrency and Cluster. Whenever such events occur, it slows down our applications. The situation worsens if these blocking sessions are not dealt with in the next few minutes, causing application freeze. Given the severity of the situation, we must develop an emergency incident handling solution.

    One "Monitoring and Killing Blocking Sessions" Oracle procedure was developed and was set to run every minute. Once the procedure captured the blocking session, it issues a kill command to terminate the session. Our stats indicate that roughly 10-20 blocking sessions were terminated each day. Because of this, we have resolved the critical situation and met the HA business requirement.

     

    Session 2

    Topic: An Introduction to Oracle In-Memory Database

    Speaker: Doug Hood, Oracle

    Abstract

    Starting with Oracle 12.1, the Oracle Database supports both the traditional buffer cache [row store] for OLTP apps and an in-memory column store for faster analytics.

    This talk describes what Oracle In-Memory is, when it should be used, how it works, how to configure it, how it affects existing applications, and who is using it and has some demos.

     

    About the Speakers

    Karl Shen – Aviso Wealth

    Karl has worked as Sr. DBA and Sr. Developer at Aviso Wealth, one of Canada’s largest independent financial services provides, for 18 years. Karl has been involved in database development/design and performance optimization; completing Oracle databases upgrade from 10G (standalone) to 11G/12C (clusters) as well as real-time bi-directional data replication using Golden Gate between two data centres.

     

    Doug Hood - Oracle

    Doug is a product manager for Oracle TimesTen, Oracle In-Memory Database and Oracle NoSQL. He started using RDBMS with DEC Rdb/VMS and progressed to Oracle 5, 6, 7, 8i, 9i, 10g, 11g, 12c and 18c. Doug has worked as a consultant, developer and product manager at Oracle over the years. His technical interests are making things go fast [OCI, ODBC and PLSQL] and getting things to work together.

     

    BCOUG Tech Day 2019

    May 10, 2019 08:30 AM - 06:00 PM

    The British Columbia Oracle Users Group (BCOUG) is proud to present its second annual Tech Day. This is a full-day event with multiple parallel sessions to get up to speed on the latest developments in Oracle Database and developer technologies.

     

    Keynote Sessions

    Coding Therapy for Database Developers

    We've seen a major shift in the landscape when it comes to how databases are selected for use with new application development. In short, UI developers (many of them writing in JavaScript) are picking the database that is most expedient for them, without (from our backend view) much regard for data consistency and integrity. It’s easy to be disdainful of such choices. It’s a lot harder to figure out how to effectively communicate a message of the importance of database to application development. In this session, Steven offers some “therapy” to database developers to help them communicate and work with UI developers more effectively, as well more, ahem, standard therapy (dream therapy, shock therapy, game therapy, couples therapy) that will improve the way you write your code.

    Steven Feuerstein

    Steven Feuerstein
    Oracle Developer Advocate
    Oracle Corporation

     

    Agenda

    The Call for Papers will close on Feb 1, 2019. We expect the review to be completed by early March. Please check our event website at a later time for the full list and schedules of great sessions that we have lined up for the event.