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.

 

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
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.