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.