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.

     

    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.

     

    BCOUG Tech Day 2018

    April 27, 2018 08:30 AM - 06:00 PM

    The British Columbia Oracle Users Group (BCOUG) is proud to present its inaugural 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.

     

    UPDATE: Attendees registered before April 13, 2018, 11 pm, will receive a $15 Starbucks card!

     

    Keynote Sessions

    IT Wars - DBA Versus Developer
    For decades developers and DBAs have battled over who controls the world. With each new development paradigm the battle flares again as developers push DBAs to adopt and support new data structures (JSON), new APIs (REST services), new technologies (In-Memory) and new platforms (Cloud). In this session, Gerald takes on the role of lead developer on a project to deploy a RESTful web-based application, while Maria takes on the role of the DBA. Through the use of live demos, they learn to work together to find a solution that will allow them to embrace a more agile development approach, as well as the latest technology trend without exposing the business to painful availability or security vulnerabilities. Can developers and DBAs peacefully coexist? Join us in this session and find out!
     

    Maria Colgan profile photo

    Maria Colgan
    Master Product Manager
    Oracle Corporation

     

    Gerald Venzl profile photo

    Gerald Venzl
    Senior Principal Product Manager
    Oracle Corporation

     

    Agenda

    Please go to our Event Website for the full list and schedules of great sessions that we have lined up for the event.

    Upgrade to Oracle 12.2 and 18c

    February 26, 2018 08:30 AM - 04:00 PM

    Mike Dietrich, the guru of Oracle Database upgrades, will be back in Vancouver on February 26, 2018. The British Columbia Oracle User Group is proud to welcome him to our beautiful city, for yet another day of learning and hands-on exercises.

    Seats are limited! With the impending release of 18c this year, you won't want to miss this FREE one-day event!

     

    Agenda

    8:30am - Registration
    9:00am - The new Release and Patching Model for Oracle Databases
    9:45am - Upgrade to Oracle Database 12.2 and 18c
    10:30am - Break
    10:45am - Real World Customer Examples
    11:15am - Hands-On Lab Exercise 1 - Upgrade
    12:00pm - Lunch provided (sponsored by Oracle Vancouver)
    1:00pm - Oracle Multitenant - More than a bunch of New Features
    2:15pm - Hands-On Lab Exercise 2/3 - Multitenant
    2:45pm - Break
    3:00pm - Ensure Performance Stability with Oracle 12.2/18c
    3:45pm - Debrief and End

     

    To participate in the workshop:

    Please bring a laptop with preinstalled Oracle VirtualBox 5.x and - VERY IMPORTANT - the Oracle VirtualBox Extensions.

    Download and install Oracle VirtualBox and the Extension Pack from: https://www.virtualbox.org/wiki/Downloads

    Furthermore it's important that your laptop meets to following criteria:

    • At least 4GB RAM - 8GB or more highly recommended
    • At least 62GB of free disk space 
    • External disk drives with USB 3.0-SSDs or Thunderbolt may work but slow down the lab usually. The lab does not run on USB thumb drives

     

    About Mike

    Based in Bavaria, Germany. >25 years IT experience. Database Upgrade and Migration specialist, currently in the role of a Master Product Manager working for Oracle for over 20 years. Interlink between customers/partners and the Oracle Upgrade Development. Holding technical workshops between Arctic and Antarctica. Assisting customers in their reference projects onsite and remotely worldwide. Troubleshooting upgrade and migration issues. Eager to learn something new every day. Experienced conference speaker. Music lover. LP/vinyl enthusiast. Mountain hiker. Runner.

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

     

    Session 1

    Topic: Securing Your DBA Monitoring & Backup Scripts (SEPS & The Oracle Wallet)

    Speaker: Simon Pane, Pythian

    Abstract

    All DBAs have OS and DB based scripts for performing tasks such as monitoring, backups, or application logic. However, are these scripts implemented as securely as possible without using some home-grown solution for DB credential management? Or are they a weak point or possible exposure in your organization's security implementation?

    This presentation discusses how to use Oracle's "Secure External Password Store" (SEPS) and Oracle Wallet files to maximize the security of DBA scripts. Both SQL and RMAN based scripts are reviewed including those scheduled via OS tools such as cron and those scheduled from within the database using the new Oracle Database 12c Scheduler job types.

    Issues and exposures with commonly used techniques and practices are identified. Then secure alternatives using SEPS and other security best practices are reviewed in detail with examples.

     

    Session 2

    Topic: Analyze Storage and Performance using Data Visualization Desktop 12c (DVD) - Like a BOSS !!

    Speaker: Fahd Saeed, Red Pill Analytics

    Abstract

    Database administrators and storage architects have a lot on their plate. With a bevy of SQL queries in their back pocket, being responsible for a multitude of databases, why wouldn’t they want to create custom data visuals that tie all this information together, to either report on issues, performances, or perhaps brag about the uptime, space and capabilities?

    Oracle’s newest data visualization tool, Data Visualization Desktop 12c (DVD), allows you to quickly connect to a number of datasets within minutes and produce sweet, succulent graphical charts (like a BOSS). In this presentation, we will take a look at quickly installing DVD, connecting DVD to SQL queries and CSV files to create visualization that you’ll be proud to show off within your organization.

     

    About the Speakers

    Simon Pane - Pythian

    Simon Pane is an Oracle Certified Professional, Oracle Certified Expert, and Oracle ACE. Working with the Oracle database since version 6, his focus has been on High Availability, Monitoring, Backup & Recovery, Migration & Consolidation, and Security, and he has experience with literally thousands of database environments at hundreds of client sites.

    Simon enjoys sharing technical knowledge and has presented at many user groups and at almost every major conference in Canada and the United States including Oracle OpenWorld and is a UKOUG speaker award winner.

     

    Fahd Saeed - Red Pill Analytics

    Fahd is a BI Consultant at Red Pill Analytics, based out of Salem Oregon. Plays with data integration tools and SQL for a living. Avoids getting seriously injured long boarding and skiing for fun. 

    Annual General Meeting 2017

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

    Victoria Oracle Users Group Society
    NOTICE OF ANNUAL GENERAL MEETING

    Wednesday, 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 2017. 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 (2016) AGM minutes
    • Report of the activities in 2017
    • Review and approval of the society's financial report for the current year, as of Oct 31st, 2017
    • Nomination and election of the board of directors
    • Other matters:
      • Activities and events for 2018

    Please note that this is a business meeting only and there are no presentations.

    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.

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

    Session 1

    Topic: Key Technical Features of Oracle RAC 12c & Beyond

    Speaker: Ian Cookson, Oracle

    Abstract

    Review the evolution of RAC 12c in terms of key technical and architectural features and functions.  Then consider where this will be leading us, to the Cloud and to on premise deployments.

     

    Session 2

    Topic: Data Storage Optimization

    Speaker: Chas. Dye, Pure Storage

    Abstract

    The topic of the presentation will be focused on data storage optimization in database / multiple database environments along with disaster-recovery strategies in those environments.

     

    About the Speakers

    Ian Cookson, Oracle

    Based now at Oracle HQ in California, Ian is the Product Manager for Oracle Clusterware, and the Oracle Liaison to the RAC SIG.  His background is varied, after spending over 20 years in Consulting, plus many years with the RAC Pack.

     

    Chas. Dye, Pure Storage

    Chas. Dye has been an Oracle DBA and Database Architect for over 20 years.

    He authored "Oracle Distributed Systems" and co-authored "Oracle Built-in Packages", both published by O'Reilly and Associates. He was personally responsible for the databases serving content to for web sites like eXcite.com and nike.com. In addition he served as a database architect at Yahoo! where he helped to design, test, and oversee the database disaster recovery infrastructure for Yahoo! properties around the globe.

    Chas. is the Database Architect who is responsible for ensuring the success of customer database deployments including Oracle, Microsoft SQL Server, PostgresSQL, or any other database environments.

     

    Registration

    Registration is free and required for security access. Registration and refreshments will begin at 5.30 pm and the first session at 6.30 pm. Please note that the building's elevators will be locked in the evening. You are advised to come before the first presentation begins, so that an Oracle staff or BCOUG volunteer can escort you up to the meeting venue.

     

    Acknowledgements

    We would like to thank Oracle Vancouver and Open Storage Solutions for generously providing us the venue and light dinner for the evening. 

    You are cordially invited to join the BCOUG at our next Vancouver event on May 25, 2017.

    Session 1

    Topic: Advanced Database Diagnostics with the Trace File Analyzer (TFA) Suite

    Speaker: Sean Scott, Bodybuilding.com

    Abstract

    Most database administrators know that Trace File Analyzer (TFA) is the preferred tool for collecting and preparing files for troubleshooting an issue with Oracle Support, but remain unaware that it is actually a robust suite of tools capable of capturing OS metrics, system changes, insights into alert and log files and automatically collecting diagnostic information to expedite troubleshooting of performance events and deadlocks. It's lightweight, cluster aware and suitable for standalone and RAC databases as well as engineered systems.

    This session will go beyond the basic diagcollect command to cover more advanced capabilities of TFA, including system and database log analysis, user management, redaction and repository maintenance. The use of Automatic Diagnostic Repository (ADR) and the SQL Test Case Builder for investigating database and performance issues will also be demonstrated.

     

    Session 2

    Topic: ADOP Patching gotchas!

    Speaker: Oti Ometie, Independant Consultant

    Abstract

    AD Online Patching(ADOP) as a utility eases the burden of constantly taking an outage to apply an E-Business Suite patch, however with that ease comes a complexity that can only be overcome with experience, creativity and an understanding of the documentation. This session aims to get you across pitfalls you may experience while using the utility. Walk you through scenarios you are likely to face when applying patches to multiple nodes and explain concepts like fs_clone and cleanup_mode = full. The session will be interspersed with interesting anecdotes and challenges I have encountered and resolved.

     

    About the Speakers

    Sean Scott - Bodybuilding.com

    Sean is a database administrator with over 20 years experience managing Oracle. For 15 years he managed a database consultancy specializing in RDBMS management, backup and recovery, disaster recovery, performance tuning and database design. He's developed high performance solutions to meet the extreme demands of online gaming and e-commerce and designed and implemented high availability solutions for clients including Intuit, the University of Phoenix and the military. He has presented at IOUG/Collaborate, Oracle Open World, OAUG and regional user groups across the US and his work featured in magazines. He currently works for Bodybuilding.com, the world's largest online sports nutrition retailer, overseeing the company's e-commerce database environment.

     

    Oti Ometie - Independent Consultant

    Oti is an Oracle Certified Expert (OCE) currently working as an Oracle E-Business Applications DBA. He has worked on 3 continents and has over 14 years’ experience in database design, administration and performance tuning. He has a M.Sc. in Information Systems, and an MBA.

     

    Registration

    Registration is free and required for security access. Please also note that light refreshments will be provided at the event.

    From Database Recovery to Complete Data Protection

    February 09, 2017 06:00 PM - 09:00 PM

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

    Session 1

    Topic: From Database Recovery to Complete Data Protection

    Speaker: Chris Veenstra, Oracle

    Abstract

    • Oracle’s Database Protection Strategy: From Database to Engineered Systems to Cloud 
    • Engineered Data Protection: Introducing Oracle’s Zero Data Loss Recovery Appliance 
    • Data Protection Advantages First Hand 
    • Real-World Customer Experience
    • General Discussion / Q&A

     

    Session 2

    Title: The Optimizer complexity is great, but...

    Speaker: Liron Amitzi, DBAces

    Abstract

    The Optimizer is one of the most complex components in Oracle. In this session we will talk about the optimizer from a slightly different perspective, its deterministic (and non-deterministic) behavior. We will explore the stability of plans and examine new features that ruin your system performance, just when we get it tuned just right.

     

    About the Speakers

    Chris Veenstra - Oracle

    Chris is a Sales Engineer with the Oracle North America Cloud and Infrastructure Solutions (NACIS) Sales Engineering Organization. With a strong end user background as an Oracle DBA he brings a wealth of knowledge and expertise to DB Protection initiatives including Oracle DB Backup, Recovery as well as Archive.

    He often speaks on matters involving Oracle DB, DB Protection and architecting Oracle Solutions for a wide array of customers both in the Public Sector as well as in the Private Sector and help them to achieve faster, more efficient mission success with Oracle's technologies, solutions and capabilities.

    While he works with customers all across Canada and the US, Chris calls the New England area home.

     

    Liron Amitzi - DBAces

    Liron is an Oracle ACE and a senior Oracle DBA, with over 18 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 is currently in Vancouver, BC, founding the Canadian branch of his Israeli Company, DBAces. Liron is also the president of BCOUG (British Columbia Oracle User Group) and US Events Chair and IOUG Liaison of Oracle RAC SIG.

    He mainly specializes in high availability solutions, performance, backup and recovery, and other infrastructure and application database areas. He is also a well-known senior instructor and lectures in Oracle courses, events and forums

     

    Registration

    Registration is free and required for security access. Please also note that light refreshments will be provided at the event.

    Annual General Meeting 2016

    December 15, 2016 06:00 PM - 08:00 PM

    Victoria Oracle Users Group Society
    NOTICE OF ANNUAL GENERAL MEETING

    Wednesday, December 15, 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 2016. 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 (2015) AGM minutes
    • Report of the activities in 2015
    • Review and approval of the society's financial report for the current year, as of Oct 31st, 2016
    • Nomination and election of the board of directors
    • Other matters:
      • BCOUG website, maintenance and community space on https://community.oracle.com/community/usergroups
      • Change of payment provider
      • Reorganization of email groups/aliases
      • Activities and events for 2017
      • Registration with TechSoup Canada as a non-profit organization

    Please note that this is a business meeting only and there are no presentations.

    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.

    EBS co-existence with Oracle SaaS and other systems

    November 08, 2016 06:00 PM - 08:00 PM

    You are cordially invited to join the BCOUG at our next Vancouver event.

    It is our pleasure to have Stewart St. Dennis, Consulting Director at Sierra Systems, present on the following topic:

    EBS co-existence with Oracle SaaS and other systems

    EBS Systems need to INTEGRATE! Traditionally, EBS systems use tightly coupled, point-to-point integrations. As a result, many organizations experience issues when related systems are shut down for maintenance or system upgrades. Also, upgrades and enhancements in one system can cause problems with other systems they are connected with.

    How can organizations unravel their integration spaghetti plate? How do they isolate the operations of one system from their network of systems? How can an organization prepare for hybrid, on premise/cloud solutions? Let me show you how to solve the interoperability issues for your organization in a better way.

    Registration

    Registration is free and required for security access. Please also note that light refreshments will be provided at the event.