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



    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!



    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


    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


    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

    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.


    • 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


    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


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



    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


    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


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


    • 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


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

    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.


    • 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 is free and required for security access. Please also note that light refreshments will be provided at the event.

    You are cordially invited to join the BCOUG at our next Vancouver event, presented and sponsored by NetApp™!


    Session 1

    Speaker: Steve Schuettinger, Oracle Solution Architect, NetApp
    Topic: Oracle Application Integration

    Abstract: Please join Steve Schuettinger, Oracle Solution Architect, in a discussion that focuses on what’s important to you when deploying Oracle databases. Suggested topics include performance, scalability, availability, manageability, root cause analysis and backup/recovery. These are suggested because we’d like to encourage you to bring your top-of-mind questions to the session. Nothing is off limits. The objective is to help you understand how NetApp solutions can help you meet your service level objectives without increasing risk.

    NetApp has thousands of customers who have chosen to deploy their Oracle databases on NetApp. The value discussion points will be underscored with real world examples. You’ll also learn what NetApp and Oracle are engineering together with focus on you, the Oracle DBA.

    Session 2

    Speaker: Tony Lee, System Engineer Manager, NetApp
    Topic: Technical Demonstration – Oracle on AFF

    90% of all database performance issues can be traced to the storage tier. Reduce latency during peak loads, and boost Oracle Database performance where you need it most, by using NetApp All Flash FAS or EF-Series all-flash storage systems.

    • Decrease latency by up to 20x
    • Increase throughput by up to 4x
    • Increase your ROI and time to value by up to 50%

    Watch a technical demonstration of Oracle running on NetApp All Flash FAS storage arrays.

    About the Speakers

    Steven Schuettinger – Oracle Solution Architect, NetApp

    Steven began his career working as an application developer for a US defense contractor using Oracle version 5. He soon became a DBA where he focused on performance and manageability. Steve was the first Oracle DBA at Sun Microsystems, in Silicon Valley, in 1992 and worked as their technical alliance manager with Oracle. He has been consulting with customers for many years while managing the technical aspects of the relationship between NetApp, where he has worked since 2005, and Oracle. During his career he has developed an interactive style of working with DBAs where he talks about the challenges they face and the unique solutions NetApp provides. All of these discussions are delivered in the language of the DBA, rather than the storage administrator.

    Tony Lee, System Engineer Manager Canada West, NetApp

    Tony is a creative problem solver; and with 25 years of experience in the IT industry, he’s had ample opportunity to hone his skill. Tony started his career in the early days of the Internet and worked for several large outsourcers, including EDS and IBM Global Services, building and operating their network services (DNS, Email, Web, Firewall, etc.). In 2001, he joined Sun Microsystems and moved from an operational role to an architectural one. As a Sun Systems Engineer, Tony architected solutions to address some of Sun’s most challenging customer environments. For the last 8 years, Tony has been a Senior Storage Architect at NetApp where he’s continues to leverage his problem solving skills focusing on the ever-increasing challenges associated with data management.

    Tony has a BSc in Computer Science from Simon Fraser University.


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

    ORCLAPEX-YVR Meetup #3

    February 04, 2016 05:30 PM - 08:30 PM


    SQL Developer Integration with APEX

    Those of you already familiar with Oracle SQL Developer, the free graphical IDE for the Oracle Database, have experienced first hand how this feature rich tool can boost productivity. Many DBAs, developers, data modelers, and application architects alike have discovered how SQL Developer can help them do their jobs in less time with fewer clicks. However, did you know that SQL Developer is also a indispensable tool for working with APEX?

    Join us as former ODTUG President, Monty Latiolais, gives us an overview of SQL Developer, and then shows how SQL Developer can be used to administer, maintain and debug APEX applications. You are guaranteed to pick up a few SQL Developer tips and tricks that will help you go faster.

    APEX and the Future of Enterprise Development

    Development teams can easily get tied down with slow moving development cycles. Slow processes make it very difficult to keep up to date with rapidly evolving technology which can significantly affect a business’ ability to grow. Thankfully for organizations that use Oracle, they can leverage APEX: a web based rapid application development (RAD) tool. By using APEX, organizations can move into the the “IT fast lane” and quickly develop applications for their business needs.

    This presentation will highlight how APEX can be used to rapidly develop enterprise applications and leverage different web based technologies to help reduce development time and improve user experience.


    5.30 - 6.00 pm - Registration and light meal
    6.00 - 6.45 pm - SQL Developer Integration with APEX
    6.45 - 7.00 pm - Break
    7.00 - 7.45 pm - APEX and the Future of Enterprise Development
    7.45 - 8.30 pm - Q&A followed by networking

    About the Speakers

    Monty Latiolais

    Monty is a Senior Consultant with Insum Solutions - the largest APEX consultancy in North America. He has 30 years experience working in IT with more than 15 with Oracle technology. In 2014 he was designated as an Oracle ACE and served as President of ODTUG from 2012-2015.

    Prior to joining Insum Solutions, Monty spent time solving problems in the Oil and Gas, Legal and Healthcare industries. He spends his days working with Application Express, Oracle Forms, and Oracle Reports; writing complex analytics; and counting the days until the next KScope conference.

    He blogs regularly at montylatiolais.blogspot.com. Follow him on Twitter at: monty_latiolais

    Martin D'Souza

    Martin D'Souza is a senior consultant at Insum Solutions. He is also the vice president for ODTUG and founder of OraOpenSource. Martin’s career has spanned 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 www.talkapex.com and a designated Oracle ACE Director. He has co-authored and authored various APEX books and is an active participant in various open-source projects, such as Logger. Martin has presented at numerous international conferences, such as APEXposed, APEX World, Oracle OpenWorld, and ODTUG Kscope.

    Introduction to Kafka for Oracle DBAs and Business Analysts

    November 04, 2015 05:30 PM - 07:30 PM


    As DBAs and data architects there are some things we care a lot about: e.g. providing consistent performance on our OLTP databases, and making sure the ETL processes will land data correctlyand on-time into the data warehouse.

    Business analysts care a lot about other things -- like gettingthe newest data to their dashboards and being able to run crazy queries quickly without anyone killing the queries for silly reasons like "performance". They also want to get all the data they require without having to integrate with a gazillion data stores.

    Apache Kafka, a distributed queue developed at LinkedIn to solve the problem of integrating databases at large scale, offers a surprising solution to all these problems. Which probably explains why it is gaining popularity at an explosive rate.

    In this session we will explain what Apache Kafka is and why it is rapidly becoming the secret weapon in the fight to keep databases (and DBAs?) sane.

    About the Speaker

    Gwen is a system architect at Confluent helping customers achieve success with their Apache Kafka implementation. She has 15 years of experience working with code and customers to build scalable data architectures, integrating relational and big data technologies. She currently specializes in building real-time reliable data processing pipelines using Apache Kafka. Gwen is an Oracle Ace Director, an author of “Hadoop Application Architectures”, and a frequent presenter at industry conferences. Gwen is also a committer on the Apache Kafka and Apache Sqoop projects. When Gwen isn’t coding or building data pipelines, you can find her pedaling* on her bike exploring the roads and trails of California, and beyond.

    What is APEX and Why Should You Care?

    April 30, 2015 06:00 PM - 09:00 PM


    Would you like to learn how to build fast, secure and flexible web and mobile applications without needing to first become an expert in HTML, CSS, Javascript, and/or a complex web framework?

    Oracle Application Express (Oracle APEX), is a fully supported, rapid web application development tool that is included with the Oracle database as a no cost option. Using only a web browser and limited programming experience, you can develop and deploy professional web applications that are both fast and secure, which can be deployed for personal, departmental, or enterprise wide use.

    Many businesses are beginning to see the power of Oracle APEX for rapidly developing data centric applications, and yet many Oracle developers are unfamiliar with this "hidden gem", and are forced to leave web application development to others.

    Our goals is to change that. As part of the Vancouver Oracle User Group activities, we are starting a new Oracle APEX meetup here in Vancouver where we will discuss how to build web applications using Oracle APEX. This meetup group also joins a larger network (https://apex.world/ords/f?p=APEX_WORLD:MEETUPS) of other meetups that have sprung up worldwide.

    So, if you've ever been curious about building web applications, or may have heard of APEX and are interested in learning more, please join us at 6:00PM on April 30th at 1400 – 505 Burrard St. (Oracle Offices).

    To sign up, please join our meetup group and then RSVP to attend our inaugural event!

    Modern Platform Topics for Modern DBAs

    November 19, 2014 05:00 PM - 08:00 PM

    Please thank our meeting sponsor EMC for making this meeting possible!

    Oak Table charter member Kevin Closson will be presenting two informative in-depth topics focused on extreme database performance. This session will be of great interest to all DBAs who are planning, designing, implementing, maintaining or tuning the Oracle database.

    Understanding Key All-Flash Array Features and Characteristics that Matter in Oracle Database Performance and Manageability

    All-Flash Array (AFA) technology is mainstream. However, not all storage devices in the AFA category are created equal. We all know Flash is fast so this is not the typical speeds-and-feeds AFA presentation.

    How is an Oracle Database Administrator (DBA) to know which of the common features found in AFA devices are meaningful in Oracle Database use cases? How does in-line data de-duplication and compression impact Oracle Database? How is an Oracle DBA to know what testing methodologies will prove predictable performance during a proof of concept test cycle?

    Kevin will tackle these questions and more.

    This session focuses on AFA implementation architectures and Oracle-centric how-to information spanning test approaches and key performance indicators one should look for in Oracle Time Model (Automatic Workload Repository) data during AFA testing with Oracle Database.

    SLOB – Silly Little Oracle Benchmark For Accurate Testing of Physical I/O—and Much, Much, More!

    This session covers a fundamental review of Silly Little Oracle Benchmark (SLOB) and how one can use SLOB to further their expertise in Oracle Time Model Performance Method as well as to test and gain deep, practical understanding of new Oracle features such as Oracle Database 12c Multitenant and In-Memory Column Store features. This session is packed with modern platform topics for modern DBAs. Kevin Closson will weave in important topics like CPU hyperthreading (Intel SMT), Intel TurboBoost and NUMA as pertaining to performance characteristics of Oracle Database on modern industry-standard servers.

    About Kevin Closson
    Chief Performance Architect / Sr. Director, XtremIO Business Unit - EMC.

    Kevin's 25-year career has spanned Platform and Software product development, performance engineering, technical marketing, support and application development positions specializing in Oracle, non-Oracle databases and clustered platforms.

    Before EMC, Kevin was the Performance Architect in Oracle's Exadata development group (System Technology Group). Prior to his tenure with Oracle, Kevin held positions within HP/PolyServe, IBM, Sequent Computer Systems, Veritas and Altos where his main engineering focus was developing port-level throughput and scalability enhancements of the Oracle server on high-end Unix SMP and Clustered Systems.

    Kevin holds patents in SMP locking algorithms and database caching methods. Kevin invented and maintains the very powerful platform testing toolkit SLOB (Silly Little Oracle Benchmark). In addition to book collaborations (Apress/Rampant), Kevin's written works have appeared in IBM Redbook, Oracle Magazine, Oracle Internals Magazine, SELECT and CMG.

    Kevin is a charter member of the Oaktable Network organization (membership 2002). Kevin maintains a very popular technical blog at kevinclosson.net.

    Vancouver Oracle Users Group Meeting - April 23, 2014

    April 23, 2014 05:00 PM - 08:00 PM

    Database Replication, Bill Brunt

    Database replication as an architectural strategy moved into mainstream several years ago. Today, all the major players including IBM, Oracle and Dell offer high speed, log based, fault tolerant, asynchronous streaming replication solutions. This presentation will first cover the fundamentals of replication and then quickly dive into specific implementation considerations for several use cases including disaster recovery, load isolation, auditing and more.

    About Bill

    Bill Brunt started working with Oracle in 1988, presenting 4 previous times at OOW and its predecessor. He has worked with SharePlex for both Dell and as a customer. He has helped hundreds of customers increase the availability and deploy scalable infrastructures. His experience with Oracle includes database administration, architecture, data warehousing, Oracle EBS and application development. Hands on experience with replication technology includes change data capture, messaging queues, block level disk writes, enterprise application integration, extract transformation and load.

    Poor Man's Auditing with Log Miner, Caleb Small

    The need for database auditing is a topic that most DBAs have heard loud and clear. Oracle offers many auditing solutions including the standard audit trail, trigger based auditing, Total Recall and Audit Vault. The specific requirements of each individual application must be assessed before choosing the appropriate strategy.

    One of the simplest, yet most powerful solutions is the time tested LogMiner. Oracle LogMiner allows reconstruction of past SQL statements with values from the on-line and archived redo logs, provided that some simple configuration requirements are met. While there is some additional overhead imposed on the database, for the most part all the necessary mechanisms are already in place and no additional audit trails or log files need to be maintained. 

    This presentation steps through the decision criteria for selecting this option, and the actual database implementation steps.

    About Caleb

    Caleb is a senior consulting Oracle DBA with decades of experience in IT, and specifically with Oracle high availability installations since version 7. He has deployed dozens of production systems on both scratch built and engineered systems including the the Oracle Database Appliance. This, in combination with his experience as a professional instructor, and featured speaker for user groups around North America makes his presentations both informative and entertaining.