Cloud vs. On Premises!

    September 28, 2021 05:30 PM - 07:30 PM

    BCOUG is proud to present a panel of experts who will discuss issues and considerations when migrating workloads to the cloud.

    BCOUG Virtual Meetup April 2021

    April 28, 2021 12:00 PM - 01:00 PM

    BCOUG is proud to present our next virtual meetup to be held in the comfort of your own room.

    BCOUG Virtual Meetup February 2021

    February 17, 2021 12:00 PM - 01:00 PM

    BCOUG is proud to present our next virtual meetup to be held in the comfort of your own room.

    Annual General Meeting 2020

    December 08, 2020 06:00 PM - 08:00 PM

    Victoria Oracle Users Group Society - Annual General Meeting 2020

    BCOUG Virtual Meetup November 2020

    November 24, 2020 05:00 PM - 07:00 PM

    BCOUG is proud to present our next virtual meetup to be held in the comfort of your own room. We have an interesting line-up of speakers.

    BCOUG Virtual Meetup October 2020

    October 20, 2020 05:00 PM - 07:00 PM

    BCOUG is proud to present our next virtual meetup to be held in the comfort of your own room. We have an interesting line-up of speakers.

    BCOUG Virtual Meetup September 2020

    September 22, 2020 05:00 PM - 07:00 PM

    After a great summer, the BCOUG is excited to be meeting with members again in a very different format that we've been used to.

    February 2020 Meeting - Oracle Licensing

    February 20, 2020 06:00 PM - 09:00 PM

    Learn how to take control of your Oracle licenses and make sure that your coverage is just right.

    Annual General Meeting 2019

    December 10, 2019 06:00 PM - 08:00 PM

    Victoria Oracle Users Group Society
    NOTICE OF ANNUAL GENERAL MEETING

    Date:
    Tuesday, December 10, 6:00 - 8:00pm

    Location:
    BC Liquor Distribution Branch
    3383 Gilmore Way
    Burnaby, BC V5G 4S1

    Dear Members,

    You are cordially invited to attend the society's Annual General Meeting (AGM) for 2019. Registration is required for security purposes.

    The Victoria Oracle Users Group Society is the IOUG sponsored incorporated entity that oversees the operation of the BC Oracle User Group. This is the required legal body that is able to accept donations, pay expenses, and conduct business. The AGM is a legal requirement, during which financial statements are presented and the board of directors are elected.

    Agenda

    • AGM call to order
    • Review and approval of last year's (2018) AGM minutes
    • Report of the activities in 2019
    • Review and approval of the society's financial report for the current year, as of Oct 31st, 2019
    • Nomination and election of the board of directors
    • Activities and events for 2020
    • Any other business

    Please note that this is a business meeting only. There are no presentations, but a light dinner and refreshments will be provided.

     

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

    IMPORTANT: Please note the change in address for BC LDB.

     

    Session 1

    Topic: Polymorphic Table Function Deep Dive

    Speaker: Darryl Hurley, ImpleStrat Solutions

    Abstract

    Introduced in Oracle 18, Polymorphic Table Functions (PTFs) are the next step in the evolution of table functions. They provide detailed PL/SQL access to the inner workings of SQL query functionality (parse, open, fetch, and close) to create flexible data access and control. This session begins at the surface of PTFs but quickly delves into the details to give attendees everything they need to create effective PTFs.

     

    Session 2

    Topic: Oracle OpenWorld 2019 Summary

    Speaker: Liron Amitzi, Independent Consultant (gotoDBA.com)

    Abstract

    Liron returns from San Francisco with a bag of news to share. Please join us for this short session to hear about the latest announcements, what's new in 19c and 20c and what he has learned during the four-day event.

     

    Session 3

    Topic: Members' Discussion and Q&A

    Abstract

    For this session, the floor will be opened and members are encourage to tell the board members, what topics and activities they would like organised for Fall/Winter 2019.


    Please share any comments, ideas or feedback so we will have a great content for you next year.

     

    About the Speakers

    Darryl Hurley – ImpleStrat Solutions

    Darryl has been working with Oracle technology for 20+ years with a focus on database administration and PL/SQL development. He has created two sets of videos on PL/SQL topics available for O'Reilly Safari. He enjoys learning new technology and helping others learn as well.

     

    Liron Amitzi - Independent Consultant (gotoDBA.com)

    Liron is an Oracle ACE and a senior Oracle DBA consultant, with 20 years of experience. During these years Liron worked as a senior consultant with a large number of companies in various fields and managed an Oracle Professional Services Team. He mainly specializes in high availability solutions, performance, backup and recovery, and other infrastructure and application database areas. Liron is the president of BCOUG (British Columbia Oracle User Group) and he is also a well-known instructor and lectures in Oracle courses, events and forums.

     

    BCOUG Tech Day 2019

    May 10, 2019 08:30 AM - 04:30 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

    It was a tough call to make, but the conference abstract selection committee has decided on the slate of speakers. This year, we are pleased again to present a "spade-studded" list of international speakers, with a wide range of topics that should appeal to both DBAs and Developers!

    • Carlos Sierra (Oracle ACE Director)
      • My query was performing well until last night. How do I fix it now?
    • Charles Kim (Oracle ACE Director)
      • PDB Me, ASAP! Deep Dive Into Oracle Database 12.2/18c/19c Multitenancy
    • Franky Weber Faust (Oracle ACE)
      • Oracle Partitioning for DBAs and Developers. Why, when and how to use it?
    • Karen Lopez (Microsoft MVP)
      • The Tricky Part About Doing Tricky Things in Your Database
    • Michelle Hardwick (Oracle ACE Director)
      • Leveraging Advanced SQL for Analytics
      • Finding Patterns in your Data with SQL
    • Rene Antunez (Oracle ACE)
      • How DBAs can garner the power of the Oracle Public Cloud
    • Scott Spendolini (Oracle ACE Director)
      • APEX Security Checklist
      • At Your Service: APEX & Web Services
    • Simon Pane (Oracle ACE)
      • Important steps to make your Oracle DB more secure, right now!

    For abstracts and schedules, please refer to our event website. Thank you!

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

     

    IMPORTANT: Please note the change in address for BC LDB.

     

    Session 1

    Topic: Using Docker for Oracle Database Professionals

    Speaker: Sean Scott, Pythian

    Abstract

    When I first started using Docker as a platform for delivering databases to development teams, I had no idea what I was doing. The terminology was foreign. Docker's stateless and immutable nature seemed contradictory for use with a database. The usefulness of Oracle within Docker containers appeared narrow.

    Since then I've learned that Oracle on Docker elegantly addresses a multitude of situations faced by database administrators and developers. Docker is now my go-to solution when I need an Oracle environment for testing or experimentation. It's surprisingly easy and fast once you're used to it, and the learning curve need not be steep.

    In this talk, I share the things I wish I'd known about Docker when I first started using it, provide examples of common problems encountered by database professionals that are solved by Docker, and walk the audience through the steps for creating and using Oracle databases in Docker containers.

    This presentation is intended for DBAs and developers new to Docker and containers who want to increase their understanding of the technology and begin using databases on Docker. Though the focus of the presentation is on Oracle, the material is applicable to other SQL and noSQL databases.

    Participants will learn:

    • Docker terminology
    • The structures of containers and how they run and interact with a host
    • Practical examples of Oracle on Docker as a superior approach to traditional methods
    • Steps for installing and creating Oracle databases on Docker
    • How to configure programs running on the host, like SQL*Developer, to interact with a database
    • How to persist datafiles and data to achieve permanence outside of containers
    • How to move or share a database between containers, hosts, and operating systems
    • How to save customizations to Docker images
    • How to prepare an Oracle/Docker container to support more complex installations such as APEX

     

    Session 2

    Topic: Building Castles in the Air

    Speaker: Adrian Png, Insum

    Abstract

    Moving beyond hype to reality, the Oracle Cloud has matured and is growing with new data centres coming online in 2019, including Canada. In this session, we will condense Oracle Cloud Infrastructure (OCI) offering and examine what are the decision points to consider and steps in building an Oracle Application Express (APEX) Infrastructure on the cloud.

     

    About the Speakers

    Sean Scott – Pythian

    Sean has been administering Oracle databases since the late 20th century. His interests lie primarily in performance tuning, high availability, RAC, and automation.

     

    Adrian Png - Insum

    Adrian Png is a Senior Consultant at Insum. He has spent the last two decades designing and implementing software solutions using a wide variety of programming languages. Adrian has a deep passion for Oracle Application Express, and using this tool, he has helped many organizations succeed in developing robust data management practices. As a full-stack developer, he also does double-duty as a database and cloud administrator. 'Design for the user' is his motto, and he continually seeks to optimize processes and adopt new strategies and technologies to improve how data is captured, integrated, and used effectively.

     

    Blocking Sessions and Oracle In-Memory Database

    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.

     

    Annual General Meeting 2018

    December 06, 2018 06:00 PM - 08:00 PM

    Victoria Oracle Users Group Society
    NOTICE OF ANNUAL GENERAL MEETING

    Thursday, December 06, 6:00 - 8:00pm
    BC Liquor Distribution Branch
    3200 East Broadway
    Vancouver, BC

    Dear Members,

    You are cordially invited to attend the society's Annual General Meeting (AGM) for 2018. Registration is required for security purposes.

    The Victoria Oracle Users Group Society is the IOUG sponsored incorporated entity that oversees the operation of the BC Oracle User Group. This is the required legal body that is able to accept donations, pay expenses, and conduct business. The AGM is a legal requirement, during which financial statements are presented and the board of directors are elected.

    Agenda

    • AGM call to order
    • Review and approval of last year's (2017) AGM minutes
    • Report of the activities in 2018
    • Review and approval of the society's financial report for the current year, as of Oct 31st, 2018
    • Nomination and election of the board of directors
    • Activities and events for 2019
    • Any other business

    Please note that this is a business meeting only. There are no presentations, but a light dinner and refreshments will be provided.

    For members unable to attend the event in person, you may be able to join us via conference call. Please indicate in your registration that you wish to attend the meeting remotely and details will be provided to you.

    Real Life SQL Tuning and Logger

    October 10, 2018 06:00 PM - 09:00 PM

    You are cordially invited to join the BCOUG at our next Vancouver event on October 10, 2018.

     

    Session 1

    Topic: Real Life SQL Tuning: From 4 Minutes to 8 Seconds in an Hour

    Speaker: Liron Amitzi, DBAces

    Abstract

    In 20 years of SQL tuning, I have learned many things. The number of elements that affect query tuning is huge: tables' structure, indexes, optimizer behavior and the SQL text itself are only some of them. In this session we will dive into an example of SQL tuning, based on real life experience. Together we will identify the problem, analyze it (from understanding the schema and the application logic to looking at the object structure and SQL text) and fix it, while learning the techniques and gaining some best practices of performance tuning. As a side note, we will also see why the relationship between the DBA and the developer is so important.

     

    Session 2

    Topic: Logger: Everyone's Using It, Why Aren't You?

    Speaker: Martin D'Souza, Insum Solutions

    Abstract

    Code Instrumentation (i.e. logging) can be a huge time saver in your code. Most organizations don't instrument their code, do a hack job (using dbms_output and then removing it before release), create their own logging platform, or use Logger (github.com/oraopensource/logger).

    For those not using Logger, this talk is for you. It'll cover the basics of Logger, an open source PL/SQL logging tool. If you're already using Logger, this talk will cover new features and future plans.

    This talk is suitable for both managers and developers as proper code instrumentation can significantly reduce development/debugging time and aid in production issues.

     

    About the Speakers

    Liron Amitzi - DBAces

    Liron is an Oracle ACE and a senior Oracle DBA consultant, with 20 years of experience. During these years Liron worked as a senior consultant with a large number of companies in various fields and managed an Oracle Professional Services Team. He mainly specializes in high availability solutions, performance, backup and recovery, and other infrastructure and application database areas. Liron is the president of BCOUG (British Columbia Oracle User Group), the US Events Chair and IOUG Liaison of Oracle RAC SIG, and he is also a well-known instructor and lectures in Oracle courses, events and forums.

     

    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.