Training Days 2022  Session Details

Our Virtual Training Days 2022 was once again an amazing event with over 100 sessions by  an amazing group of speakers. The list below provides the links to presentation details and slides (if available). Click the Presentation Title to be linked to that session directly to view the Session details. Or you can use your browser find tool to search for a specific speaker, paper, or topic.

Session recordings are available now in our Members-Only section of this website. To View the session recordings available:

  • Login at the upper right corner of this page and then go to the Members menu item.
  • Select "Training Days 2022 -Re-Runs" from the drop-down for the list of sessions and links to the recordings.

To view the status of your RMOUG membership and to renew your membership, please login and view your Profile.

Not a Member?    Join RMOUG Now!

If you have any questions or issues, please email our RMOUG IS Director at isdir@rmoug.org

  
 Date & Time
Session Presentation Title Speaker Topic





Monday 2/7/22



 10:00:00 AM 1-1 Why You Should Consider an Oracle to Amazon RDS Migration Brandon Webb Cloud Platform Services
  10:00:00 AM 1-2 Oracle Developer Roundtable: 2022 IT Trends Mia Urman - AuraPlayer  Sponsor - AuraPlayer
  10:00:00 AM1-310 Tips on Choosing the Best Oracle Analytics Strategy: The Differences Between OBIA, EPM, OTBI, and the New FAWGustavo Gonzales
 Analytics / Big Data
  10:00:00 AM 1-4 Get To Know Your Program by  Instrumentation (30-minute Quick Tip) Patrick Barel Application Development
  10:00:00 AM 1-5 Introducing the Oracle Converged Database Sean Stacey Database Administration
 10:00:00 AM 1-6 Next Level PL/SQL - A Live Code Review! Steven Feuerstein Application Development
  11:10:00 AM 2 Keynote Address: The Future of Oracle Database Maria Colgan Keynote - Oracle
  12:35:00 PM 3-1 Oracle Database In-Memory Best Practices For Getting Started Andy Rivenes Analytics / Big Data
  12:35:00 PM 3-2 Automating Oracle Cloud Infrastructure for Dummies Bobby Curtis Automation
  12:35:00 PM 3-3 Automate and Bulletproof Your Data Guard Charles Kim Database Administration
  12:35:00 PM 3-4 Help Me Move Away From Oracle Lucas Jellema System Architecture / Administration
  12:35:00 PM 3-5 Building Generic Search Screens Using Dynamic SQL Michael Rosenblum Application Development
  12:35:00 PM 3-6 Zero Downtime Migration (ZDM) of Large Databases (100Tb+ ) Valli Ramanathan Database Administration
  2:20:00 PM 4-1 Modernizing Database Infrastructure With Exadata Cloud Bryce Cracco Cloud Platform Services
  2:20:00 PM 4-2 Oracle Real Application Testing Chris Bradham Database Administration
  2:20:00 PM 4-3 Oracle APEX New Features & Roadmap Marc Sewtz Application Development
  2:20:00 PM 4-4 Machine Learning 101 Deep Dive (Part 1) Rich Niemiec Emerging Technologies
  2:20:00 PM 4-5 New Features in Data Pump for Oracle Database 21c, Best Practices, 19c Superpatch William Beauregard Database Administration
  3:35:00 PM 5-1 Top 10 Ways to Totally Mess Up an AWR Analysis Craig Shallahamer Database Administration
  3:35:00 PM 5-2 Google and Oracle: You've Got a Friend in Me? Rene Antunez Cloud Platform Services
  3:35:00 PM 5-3 Machine Learning 101 Deep Dive (Part 2) Rich Niemiec Emerging Technologies
  3:35:00 PM 5-4 Data-Centric Security: Protecting Data from Cradle to Grave Shawn McElhinney System Architecture / Administration
  3:35:00 PM 5-5 SPOF (Single Point of Focus) or How to Pay Attention and get Stuff Done! Stephen Andert Professional Development





Tuesday 2/8/22








  9:00:00 AM 6-1 xTTS - Lesson(s) learned Christian Gohmann Database Administration
  9:00:00 AM 6-2 AAS Predictions Using Deep Learning Neural Networks With Sysmetric Data Craig Shallahamer Emerging Technologies
  9:00:00 AM 6-3 E-Business Suite & Fusion Cloud Automated Setup Loading and Migration Gordon Halley - ConfigSnapshot  Sponsor - Config Snapshot
  9:00:00 AM 6-4 Customer Experience - How toBuild aModern Oracle DBaaS Service With Ansible Tower, vRA, vRO, PCA, ZFS, & Co. Martin Berger Automation
 9:00:00 AM 6-5 Oracle Graph: A How-to for DBAs & Developers Melliyal Annamalai Analytics / Big Data
  9:00:00 AM 6-6 Implementing Business Rules Code with a PL/SQL Table API Peter Koletzke Application Development
  9:00:00 AM 6-7 Getting Started With Python and Oracle Autonomous Database (30 minute Quick tip) Sharad R. Chandran  Application Development
  10:10:00 AM 7-1 ZDLRA, What It Is? Is It Worth It? Fernando Simon System Architecture / Administration
  10:10:00 AM 7-2 Exadata Smart Scan: Live & Uncensored Franky Faust Database Administration
 10:10:00 AM 7-3 Boosting Database Performance in Oracle 19c and 21c Databases With Persistent Memory Kai Yu Database Administration
  10:10:00 AM 7-4 Kickoff Terraform CI/CD Into the Oracle Cloud Michel Schildmeijer Automation
  10:10:00 AM 7-5 Building a Starter Online Shopping App with Oracle APEX! (Part 1) Monica Godoy Application Development
  10:10:00 AM 7-6 Oracle GovCloud 2022: A Portrait Cloud Computing Excellence Nitin Vengurlekar/Clarke Colombo Cloud Platform Services
  11:25:00 AM 8-1 Tune that SQL: Now What Do I Do? Gary Gordhamer Database Administration
 11:25:00 AM 8-2 After 15+ Years Running on EBS, Ten Learnings of the First Year Running on Fusion Apps Gustavo Gonzalez System Architecture / Administration
  11:25:00 AM 8-3 From DBA to DSE:  Becoming a Data Science Engineer Jim Czuprynski Professional Development
 11:25:00 AM 8-4 Building a Starter Online Shopping App with Oracle APEX! (Part  2) Monica Godoy Application Development
  11:25:00 AM 8-5 Oracle Enterprise Manager: 7 Robust Features to Put in Action Zane Warton - Datavail  Sponsor - Datavail
  1:10:00 PM 9-1 Building a Comprehensive, Multi-Layer Security Strategy   Greg Wendt - Appsian  Sponsor - Appsian
 1:10:00 PM 9-2 The Real Story - Lessons Learned Moving to Oracle Cloud ERP Jim Haag/Tom Heldt Cloud Platform Services
  1:10:00 PM 9-3 Converged Database is Oracle's Best Kept Secret Rich Niemiec/Jim Czuprynski/           Nitin Vengurlekar Database Administration
  1:10:00 PM 9-4 Deploy RESTful Services in Your Database Robert Marz Application Development
  1:10:00 PM 9-5 OCI -- Architecting for Performance Roger Cornejo System Architecture / Administration
  1:40:00 PM 9-6 Let's Talk Oracle Cloud Fixed Assets: A Springboard for Understanding Data Enrichment, Data Migration, and Data Loads (30 minute Quick Tip) Ishaan Khanna/Dennis Gray Cloud Platform Services
  2:20:00 PM 10-1 Oracle Real Application Clusters Internals Anil Nair Database Administration
  2:20:00 PM 10-2 IaaS, Oracle DBaaS, Autonomous, ExaCS, CloudCustomer  How to Choose the Right Database Service on OCI Biju Thomas Cloud Platform Services
  2:20:00 PM 10-3 The Rise of the PDBs Charles Kim Database Administration
 2:20:00 PM 10-4 Oracle Audit Vault and Database Firewall 20.4 - Live and in Action! (Part 1) Gavin Soorma Database Administration
  2:20:00 PM 10-5 Meet Visual Builder, Oracle's Other Low Code Development Tool Karen Cannell Application Development
  3:35:00 PM 11-1 Oracle Data Management Strategy With Exadata - Cloud, Cloud@Customer, On-Premises Ashish Ray Database Administration
 3:35:00 PM 11-2 Google Data Analytics Solutions Overview Daniel Liu Cloud Platform Services
  3:35:00 PM 11-3 Oracle Audit Vault and Database Firewall 20.4 - Live and in Action! (Part 2) Gavin Soorma Database Administration
  3:35:00 PM 11-4 Oracle Operator Access Control for ExaC@C: Oracle's Next Step at Cloud Security for Financial Services and Mission-critical Infrastructure Jeff Wright Cloud Platform Services





Wednesday 2/9/2022








  9:00:00 AM 12-1 The Blair Witch (DB) Project Liron Amitzi/Monika Lewandowska Application Development
 9:00:00 AM 12-2 6Reinventing Oracle Systems in a Cloudy World Lucas Jellema Cloud Platform Services
  9:00:00 AM 12-3 Automate Database Using Ansible Osama Mustafa Automation
 9:00:00 AM 12-4 Licensing Rules and Tips Across the Key Areas of Compliance with Oracle Programs Paul Buckley - Data Intensity  Sponsor - Data Intensity
  9:00:00 AM 12-5 Deploy OAS as a Managed Service on Container Engine for Kubernetes Stewart Bryson Analytics / Big Data
  9:00:00 AM 12-6 Oracle GoldenGate Microservices - Centralized HUB Veeratteshwaran Sridhar Database Administration
  10:10:00 AM 13-1 Three Important Changes from JDE Release 22 that Will Impact Your Business Now Allen Jacot - Syntax  Sponsor - Syntax
  10:10:00 AM 13-2 Oracle Scheduler - Technical Deep Dive (30 minute Quick Tip) Arsalan Dehghani S Database Administration
  10:10:00 AM 13-3 There Is No MAA Without ZDLRA! Fernando Simon System Architecture / Administration
  10:10:00 AM 13-4 Managing Database Applications With APEX Mike Gangler Application Development
  10:10:00 AM 13-5 Automatically Deploy Schema Changes With Ansible and Liquibase Robert Marz Automation
  10:10:00 AM 13-6 The Unsung, Perhaps Unexplored Features of Oracle Data Pump William Beauregard Database Administration
  11:25:00 AM 14-1 New Features in Oracle Database In-Memory Andy Rivenes Analytics / Big Data
  11:25:00 AM 14-2 One PDB to Go, Please! Christian Gohmann Database Administration
  11:25:00 AM 14-3 Implementing an AI Chatbot With Dialogflow  Daniel Liu Emerging Technologies
  11:25:00 AM 14-4 Natively Integrating SAML 2 0 Oracle E-Business Suite | How Appsian Makes it Simple! Greg Wendt - Appsian  Sponsor - Appsian
  11:25:00 AM 14-5 Managing the Earthquake: Surviving Major Database Architecture Changes Michael Rosenblum Application Development
  11:25:00 AM 14-6 Cloud Migration -- Oracle on OCI, AWS, & Azure - Migration and Performance Valli Ramanathan Cloud Platform Services
  1:10:00 PM 15-1 Running EBS on Cloud? Beware of This Overlooked Performance Metric (30 minute Quick Tip) Andy Haack Cloud Platform Services
  1:10:00 PM 15-2 Histograms (In Oracle Database 11g to Oracle Database 21c) Could Be Your Friend Anuj Mohan Database Administration
  1:10:00 PM 15-3 Oracle In-Database Machine Learning With Enterprise Data and Enterprise Applications Kai Yu Emerging Technologies
  1:10:00 PM 15-4 Modals and Popups and Dialogs, Oh My!  Which to Use When, How and Why Karen Cannell Application Development
  2:20:00 PM 16-1 Making the Move to Oracle Autonomous Database Brandon Webb Database Administration
  2:20:00 PM 16-2 Crisis Survival Guide of Oracle DBA Emre Baransel Database Administration
  2:20:00 PM 16-3 Creating Order in the Database Patching Chaos Liron Amitzi Database Administration
  2:20:00 PM 16-4 From Cloud to Conversational: The Future of Oracle Forms Mia Urman Application Development
  3:35:00 PM 17-1 Introducing the Oracle Cloud Infrastructure (OCI) Best Practices Framework Ahmed Aboulnaga System Architecture / Administration
  3:35:00 PM 17-2 Take your Oracle DBA Career to the Cloud Biju Thomas Database Administration
  3:35:00 PM 17-3 Build High Performance Applications in Node.js for Oracle Database Christopher Jones Application Development
  3:35:00 PM 17-4 Deep Dive into SQL Tuning Gary Gordhamer Application Development
  3:35:00 PM 17-5 Oracle Database New Features and Product Roadmap Sean Stacey Database Administration





Thursday 2/10/22








 9:00:00 AM 18-1 Terraform - Objects will become People (30 minute Quick Tip) Brandon Webb System Architecture / Administration
  9:00:00 AM 18-2 Grafting Grifters: Identify & Display Patterns of Corruption With Oracle Graph Studio Jim Czuprynski Application Development
  9:00:00 AM 18-3 Augmenting Oracle Data Integrator for DataOps Jon Mead Analytics / Big Data
  9:00:00 AM 18-4 Container only-- New Features for Multitenant in Oracle 21c Markus Flechtner Database Administration
  9:00:00 AM 18-5 Efficient Data Handling Techniques in Python for Oracle Database Sharad R. Chandran  Application Development
  10:10:00 AM 19-1 Board Game Trivia Datavail   Sponsor - Datavail
  10:10:00 AM 19-2 Backoffice System Re-engineering -- Key Success Factors - Case Study Monika Lewandowska Application Development
  10:10:00 AM 19-3 Best Practices of Infrastructure as Code with Terraform Osama Mustafa Cloud Platform Services
  10:10:00 AM 19-4 DevOPS for DBAs: Your Automation Power Toys Rene Antunez Automation
  11:25:00 AM 20-1 Upgrade from Oracle 12.2 to 19c With Container/Pluggable Chris Bradham Database Administration
  11:25:00 AM 20-2 Can an Old Oracle Expert Tune Queries in SQL Server? Janis Griffin Database Administration
  11:25:00 AM 20-3 Script Your Way Into the Cloud Using Cloud CLI (OCI/Azure/AWS) and Interactive Shell Scripts Kosseila Haddalene Cloud Platform Services
  11:25:00 AM 20-4 Streaming ETL, and the Disentangling Power of Events Stewart Bryson Emerging Technologies
  1:10:00 PM 21-1 Everything You Need to Know About the Microsoft Azure and Oracle Cloud Interconnect Ahmed Aboulnaga Cloud Platform Services
  1:10:00 PM 21-2 Database 12c to 21c Journey of Key Feature Sets Anuj Mohan Database Administration
  1:10:00 PM 21-3 Tips and Tricks with the Compression Features Included with Oracle Database Gregg Christman Database Administration
  1:10:00 PM 21-4 Get Your Database Vaccinated: Oracle Transparent Data Encryption with Almost Zero Downtime! Heema Satapathy Database Administration
  1:10:00 PM 21-5 PL/SQL 101: 5+ Basic Tips for Highly-Performant Code Peter Koletzke Application Development
  1:10:00 PM 21-6 Practical Use Cases for Secrets Management in Oracle Key Vault (Part 1) Peter Wahl System Architecture / Administration
  2:25:00 PM 22-1 Covid-19 Can't Stop Our Hospital ERP Implementation Audrey Vicino Cloud Platform Services
  2:25:00 PM 22-2 MySQL Indexes Versus Histograms David Stokes Database Administration
 2:25:00 PM 22-3 Practical Use Cases for Secrets Management in Oracle Key Vault (Part 2) Peter Wahl System Architecture / Administration
  2:25:00 PM 22-4 Performance Tuning Using the Advisor Framework Roger Cornejo Database Administration
  2:25:00 PM 22-5 Automate On-Premise and Cloud Infrastructure - The Ansible Way Sumeet Kabra Automation
  3:35:00 PM 23-1 Keynote Address: A fireside chat with Oracle Database PMs Markus Michalewicz and Gerald Venzl Markus Michalewicz/Gerald Venzl Keynote - Oracle
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         

 

Session_1-1

 

Does your current Oracle deployment truly fit your organization’s needs? Whether you’re currently using an on-premises, hybrid, or cloud-based infrastructure, Amazon RDS offers several compelling advantages that make it worth the migration.

 

Amazon RDS for Oracle streamlines the process of getting Oracle deployed and optimized in the cloud. You end up freeing up technical resources and specialists that were previously tied up in database administration, which opens the door to greater innovations. You also have many avenues for cost-reduction through multiple pricing options, which include paying for usage on an hourly basis and reserving database instances for up to three years.

 

In this session, we’ll cover:

• The licensing models used by Amazon RDS for Oracle.

• How using a fully managed Oracle database empowers your organization in many areas.

• The improvements in database availability and reliability thanks to RDS functionality that includes automated fail-over, simple replication configuration, and other features.

• Things to keep in mind when deciding to migrate your databases.

• Choosing the databases that would be best suited for cloud-based deployment.

• Best practices for preparing your Oracle database for migration.

• Whether you should choose a database migration partner as part of the process.

• Getting the most out of multiple availability zones.

• How to move to Amazon RDS without large disruptions of daily business operations.

 

You’ll be able to use this information on Oracle to Amazon RDS migrations to make the best decision for your organization. This session is best suited for technology decision-makers, including CTOs, IT directors, and others in similar roles.

 

Brandon Webb is an internationally ranked team player: determined to become a multi-talented No-SQL and Relational Database Administrator & Application Architect, through understanding data and the systems it moves through from the source systems to the key business leaders. A visionary, driven by business intelligence/analytics to improve businesses processes and increase productivity. An innovator and forward thinker always on the move! He has energy like none other

 

Presentation Slides: 1-1_Why You Should Consider an Oracle to Amazon RDS Migration.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_1-2

 

Join us for a Development Roundtable where we will discuss digital strategy and the latest trends and technologies, including automation, digital assistants/chat, and machine learning. Come equipped with lots of questions, best practices, and words of wisdom to share with fellow participants.

 

Mia Urman is an Oracle ACE Director and world-class expert in Oracle Forms, Oracle Mobile with over four years of experience presenting, supporting, training, and consulting Oracle products. In her seven years at Oracle, Mia was both a Senior Support Analyst and Product Manager of Oracle Developer Suite, JDeveloper, and IAS technologies. While providing consulting, architecture design, and project development services to customers, Mia became intimately familiar with some of the leading challenges facing Oracle Forms/ERP clients and co-founded AuraPlayer (formerly OraPlayer), a development house providing modernization solutions for Oracle Forms to mobile/cloud/web services. AuraPlayer creates web services from Oracle Forms business logic that can be exposed and run from mobile, cloud computing, or SOA systems. She currently serves as AuraPlayer's CEO.

 

Mia is a seasoned presenter on Oracle technologies and has presented at various conferences including Oracle OpenWorld, ODTUG Kscope, UKOUG, and IOUG Collaborate. She is also a former member of the ODTUG Board of Directors.

 

Presentation Slides: No Presentation Slides

Presentation Recording: Session recordings are available now in our Members-Only section of this website.


Session_1-3

 

The addition to the Oracle Analytics Portfolio of Fusion Analytics Warehouse or FAW brings an analytical application that maximizes the value of ERP Cloud data by turning finance data into actionable insights. Learn how to choose the right analytical tool today.

 

In short, Fusion Analytics Warehouse, or FAW, is an analytical application that maximizes the value of ERP Cloud data by turning finance data into actionable insights. It empowers finance users to monitor business performance with pre-built or custom key performance indicators (KPIs)

 

It is adaptable to combine ERP Cloud Data with data from other sources to enable cross-functional insight and a single trusted view of the enterprise. We will provide a description and roadmap of the products in the Oracle Analytics space and how they would apply to solve your data requirements needs.

 

We'll review the tech aspects of FAW, which is powered by ADW and OAC.

 

We will explore some capabilities and support timelines on OBIA, OTBI, EPM, and OAX, and why a combination provides a complete finance analytic solution.

 

A final review on implementation aspects for security, extensibility, and deployment will be presented.

 

Gustavo is IT Convergence’s Chief Technology Officer (CTO) leading internal Cloud SaaS implementation as well as helping customers on their journey to the cloud.

 

Presentation Slides: 1-3_ChoosingBestOracleAnalyticsStrategy_03.pdf

Presentation Recording: No Presentation Recording Due To Technical Difficulties

 

Session_1-4

 

When we create our programs, we usually donít anticipate anything will go wrong. And it wonít, during development and testing. But in production there is always someone who does something unexpected and your code fails. When running in dev you can easily step through your code and see what happens, but in production you are not allowed to do this. How great would it be that you could see what was happening in the production environment? But logging every step takes up a lot of the performance. Installing debuggable code in production just to see whatís going on is usually a no-go. By instrumenting your code you can get the information you need by ëflipping a switch.í

 

This session shows how easy it is to instrument your code using the Open Source Logger Framework to trace the steps in production without having to install a new piece of code.

 

Patrick Barel is a PL/SQL Developer for Qualogy [http://www.qualogy.com/] in the Netherlands. Besides working with SQL and PL/SQL he wrote different plug-ins [http://plugins.bar-solutions.com/] for PL/SQL Developer [http://www.allroundautomations.com/]. He publishes articles on his own blog [http://blog.bar-solutions.com/]. In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category. In 2019 he has been promoted to ACE Director.  [http://www.allroundautomations.com/]. He publishes articles on his own blog [http://blog.bar-solutions.com/].

In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category.

 

In 2019 he has been promoted to ACE Director.

  

Presentation Slides: 1-4_GetToKnowYourProgramByInstrumentation[RMOUG20220207].pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_1-5

 

Are you a DBA or architect, or perhaps both, who is being asked by your developers to support their new application that is built on a single purpose data store? Are they convinced that this new small footprint single data solution is the only way forward for the problem they are trying to solve?

 

Well there's good news. Oracle has your back. Only Oracle has a converged database solution that can meet their DevOps needs of CI/CD, event-driven, and microservices while also supporting their data requirements, whether it's noSQL key value pairs, or document storage, or spatial and graph, or whatever other data persistence they are seeking. Not only that, Oracle's converged database bridges the divide to embrace their needs with your mission critical enterprise requirements like security and high availability and performance.

 

Hear from Oracle Database Product Management about how the Oracle Converged Database can meet these requirements as well as why it should be the first platform to consider when looking to run with these development paradigms. 

 

Best of all, these features are available completely free of charge, so you can start using them when you get home.

 

Sean Stacey is a Director of Product Management in Oracle's Server Technologies organization. Sean joined Oracle in 1997, and during his time with Oracle has focused much of his time supporting Oracle's partner community with programs primarily around the adoption of the Oracle Database. Most recently Sean has been working with Oracle customers and partners to help them move to the Oracle Cloud.

 

Sean's expertise in the Oracle database is both theoretical as well as hands-on. He frequently provides technical advisory services and education to Oracle customers and partners to ensure they are getting the most benefits from their Oracle software investment. In addition to these program activities, he has authored several white papers and frequently presents sessions at Oracle user conferences.

 

Prior to joining Oracle, Sean was a software developer and then Oracle Database administrator in Australia, the United Kingdom as well as the United States. He currently resides in Raleigh, North Carolina.

 

Presentation Slides: 1-5_Introducing the Oracle Converged Database.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.


Session_1-6




Reviewing code is fun for everyone, especially the person who wrote the code. In the session, Steven will review a piece of real code with the author of that code. Attendees will be invited to join in.

 

Steven has been working with, writing about, and generally having lots of fun with the Oracle PL/SQL language since 1992.

 

Presentation Slides: No Presentation Slides

Presentation Recording: NO RECORDING - You Tube Link below provided by Steven Feuerstein https://youtu.be/0fzLoyO62Uo

 

Session_2

 

The Oracle Database is the world's leading database technology. Over the last four decades, Oracle Database has brought innovations to the data management space revolutionizing the way we store, manage and derive value from data. As a result, thousands of customers worldwide trust Oracle to run their businesses on, from the regular day-to-day data retrieval operations to some of the world's largest and most demanding workloads. With every release of the Oracle Database, the boundaries of what's possible are pushed further. In this session, you will learn more about the road that lies ahead for Oracle Database and how it will help you meet your customers' needs from tomorrow.

 

Maria Colgan is a master product manager at Oracle and has been with the company since version 7.3 was released in 1996. Her core responsibility is the Oracle DB In-Memory Option, evangelizing new functionality, and getting feedback from Oracle customers and partners incorporated into future releases. Before this role, she was the product manager for the Oracle DB query optimizer. Based on Maria’s extensive experience in Oracle’s Server Technology Performance Group, she creates material and lectures on the Oracle DB In-Memory Option and the best practices for incorporating it into Oracle environments. She is also a contributing author to the Oracle Optimizer blog and the new Oracle DB In-Memory blog.

 

Presentation Slides: 2_The_Future_Of_Oracle_Database.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_3-1

 

Oracle Database In-Memory is the industry-leading in-memory database technology. It seamlessly accelerates analytic queries as well as improving mixed workload applications on databases of any size without requiring any application changes. Join Oracle Product Management to learn how to get started with Database In-Memory, how to identify which objects to populate in memory, how to identify which indexes can be dropped, and details on how to integrate with other performance enhancing features of Oracle Database. This session will also describe how Database In-Memory works under the covers to speed up your analytic workload and will provide a step-by-step guide on how to configure Oracle Database to get the biggest performance benefits and help you avoid having to re-invent the wheel.

 

Andy Rivenes is a Product Manager at Oracle for Database In-Memory. Prior to that Andy was a Product Manager for Heat Map, Automatic Data Optimization, SecureFiles and DBFS. Andy has spent a large part of his career managing Oracle databases and he now spends his time helping customers implement Database In-Memory as well as providing information about Database In-Memory through blogs, conferences, and customer visits. You can visit the Database In-Memory blog at https://blogs.oracle.com/in-memory or follow his tweets as @TheInMemoryGuy.

 

Presentation Slides: 3-1_DBIM_Best_Practices.pdf

Presentation Recording: No Recording Due To Technical Difficulties

 

Session_3-2

 

Are you new to Oracle Cloud Infrastructure (OCI)? Are you looking for ways to manage Oracle Cloud Infrastructure? This session will help you get started with Oracle Cloud Infrastructure and automation techniques. Using code examples to include OCI CLI and HashiCorp Terraform, youíll learn the essential skills needed to automate your OCI platform.

 

 Takeaways:

 1.     Why automation is important.

 2.     An understanding of Oracle Cloud Infrastructure (OCI) and OCI CLI.

 3.     Knowing how HashiCorp Terraform automates OCI.

 

Bobby Curtis is the President and Senior Consultant at RheoData, a global systems integrator based out of Atlanta, Georiga. As an Oracle ACE Director Alumni and published author, he has a wide range of knowledge from database technologies, data movement, and cloud architectures. Before running RheoData, Bobby worked for Oracle as the core product manager for Oracle GoldenGate and various consulting firms specializing in creating, maintaining, tuning, and integrating enterprise database solutions to help solve business problems. Bobby hosts a blog, http://dbasolved.com, which is respected as a source of information for solving complex issues related to Oracle technologies, especially Oracle GoldenGate. Along with his blog, Bobby is active on Twitter under the handle @DBASolved. During his downtime, Bobby enjoys spending time with his family while traveling to watch his children compete in their respective sports. Outside of work, he is a geek, either writing the next chapters of an upcoming book or looking for technical solutions to solve.

 

Presentation Slides: 3-2_RheoData_OCI_Automation_Dummies-RMOUG2022.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_3-3

 

Learn how you can setup Data Guard with all the best practices.  Attendees will get a brief history of Data Guard and how it became Data Guard.  Then we will dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c.  In addition to demonstrating how simple it is to setup Data Guard, this session will disseminate fundamental Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem. The author of the Oracle Data Guard Handbook will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard).

 

 The session concentrates on:

  o Building the Physical Standby

  o Monitoring and Maintaining the Physical Standby

  o Configuring Data Guard Broker

  o Performing Backup and Recovery with RMAN

  o Setting Archive Retention

  o Switchover with Refreshable PDBs

  o Subset Standbys with PDBs

 

Charles Kim is an Oracle ACE Director, VMware vExpert, an Oracle Certified DBA, Certified Exadata Specialist, and a Certified Oracle Linux, Oracle Cloud,  and RAC Expert. Charles was selected in to the Oracle ACE Program on May 2008 and became an Oracle ACE Director as of December 2009. Charles has been an Oracle ACE Director every year since 2009. Charles became a VMware vExpert in the class of 2013.   Charles specializes in Cloud, Exadata, RAC, and Virtualization (VMware, KVM and Oracle VM) and co-authored ten books around the Oracle EcoSystem:

 

        Oracle Cloud Pocket Reference Guide,  A Handbook on Oracle Cloud Infrastructure

        PDB Me to Oracle Cloud,  A Lazy DBA's Guide to Mastering Multi-Tenant

        Exadata Expert Handbook

        Oracle Database 11g New Features for DBA and Developers

        Linux Recipes for Oracle DBAs

        Oracle Data Guard 11g Handbook

        Virtualizing Business Critical Oracle Databases: Database As A Service

        Oracle ASM 12c Pocket Reference Guide

        Virtualizing Hadoop

        Solaris and Linux Recipes for Oracle DBAs 

 

Charles is the Founder and CEO of Viscosity North America, a highly specialized niche consulting organization comprised of industry experts in Oracle Engineered Systems, RAC, Oracle Cloud, Virtualization and Performance Tuning.   Charles holds certifications in Oracle Databases, VMware, Red Hat & Oracle Linux, and Microsoft and has over 30 years of Oracle experience on mission and business critical databases. Charles presents regularly at local, regional, national and international Oracle conferences including IOUG Collaborate, VMware World, RMOUG, UKOUG, New Zealand/Australia Oracle User Group, and Oracle OpenWorld on topics of Oracle Cloud, RAC, Exadata, Database Consolidations, Private Database Cloud, ASM, Linux Best Practices, Data Guard Best Practices, Performance Tuning, VMware Virtualization Best Practices, and 7/24 High Availability Considerations.     His linkedin profile is: http://www.linkedin.com/in/chkim  His twitter tag is: @racdba

 

Presentation Slides: 3-3_Automate and Bulletproof Your Data Guard.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_3-4

 

Organizations with decades of investment in Oracle technology sometimes (and increasingly) express a wish to move away from Oracle. In this session, we will first explore where the desire to move away from Oracle might come from. Then we describe what the term Oracle represents -- more than 2.000 products on all layers in the technology stack and in different business areas. Finally, we map out what the ëmoving away fromí consists of: defining where you ëmove toí and subsequently actually going there.

 

 It will become clear why you should give considerable thought about dropping Oracle, or any other vendorsí technology, when youíre not pleased with your current IT situation. You need to focus on the actual problems and objectives and define the suitable roadmap to fit your real needs. It turns out that the quest is usually for modernization and flexibility - and Oracle can very well be a part of that future.

 

Lucas Jellema is solution architect and CTO at AMIS and member of the Conclusion Architecture Board, The Netherlands. The running theme through most of his activities is transfer of knowledge and enthusiasm (and live demos). Lucas is JavaOne 2015 Rockstar, Oracle Groundbreaker Ambassador and ACE Director and a frequent speaker at conferences such as Oracle Code, Oracle OpenWorld, CodeOne (JavaOne), Devoxx and on Groundbreaker tours. He publishes techy stuff at Github, Medium, Slideshare, DZone, OTN, and the AMIS Technology Blog (https://technology.amis.nl). He is the author of two books with O’Reilly Press.

 

Presentation Slides: 3-4_HelpMeMoveAwayFromOracle.pdf

Presentation Recording:  Session recordings are available now in our Members-Only section of this website.

 

Session_3-5

 

Most modern computer applications include an "advanced search" screen that allows users to enter multiple criteria and parameters. Unfortunately, behind the scenes, this functionality can cause major implementation headaches on the back end because the resulting queries may reference an unknown number of tables and/or columns and may return unknown numbers of rows. In addition, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency.

 

This presentation will demonstrate how to handle generic search functionality within an Oracle database by utilizing Dynamic SQL, object collections, and a bit of creativity. Attendees will not only learn to solve problems efficiently using Dynamic SQL -- but solve them securely!

 

Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006), PL/SQL Performance Tuning Tips & Techniques (Oracle Press, 2014), contributing author of Expert PL/SQL Practices (APress, 2011), and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal) and conference papers. Michael is an Oracle ACE, a frequent presenter at various Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award.

 

Presentation Slides: 3-5_Building Generic Search Screens Using Dynamic SQL.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_3-6

 

What are some methods that can guarantee a no downtime migration of 100Tb database? With the increase in demand for 24x7 availability, upgrades and migrations are becoming a challenge. We need fool proof migrations/upgrades while ensuring no downtime. This is challenging enough without adding the size of the database in question to be several terabytes.

 

 I will explore some options to successfully migrate large databases with zero downtime. Detailing the methods and illustration of the requirements will help audience understand options available to reproduce the migrations in their client space.

 

 As DBAs, we are constantly challenged to improve our techniques for upgrades and migration and achieve zero downtime feats. This presentation will be beneficial to all technical folks. Customer case study is included.

  

Manager Database Engineering and application support with over 20+ yrs of experience. Design, install, configure and deliver enterprise database solutions end to end. Expertise in Real Application Clustering, Oracle 7x--12c, SQL Server, My SQL, Postgres. Critical analysis and quick problem resolution is one of my key expertise which helps resolve issues in a timely fashion and optimize solutions for the company. Highly motivated, self starter.

 

Recent emphasis on all things cloud.

 

Certified Oracle Cloud Architect Professional. Masters in Cloud Computing Architecture from Univ of Maryland

 

Presentation Slides: 3-6_Zero Downtime Migration of Large Databases .pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_4-1

 

Oracle Exadata has become a gold standard for database infrastructure within critical environments. With advanced security and availability features, Exadata has been helping meet the most stringent regulatory mandates as well as the most demanding performance requirements for both analytical and transactional workloads. Today, some of the worldís largest institutions are using Exadata to run their most critical databases.

 

Now, with Exadata Cloud products -- Exadata Cloud@Customer in the data center, and Exadata Cloud Service in the public cloud -- Oracle has brought these traditional Exadata benefits to cloud infrastructure. In addition, Oracle Autonomous Database, which is an option available on both Exadata Cloud@Customer and Exadata Cloud Service, completely automates all database and infrastructure management with built-in, self-driving capabilities. Oracleís Exadata Cloud portfolio provides modernizing customers a continuum to work with as they deploy new database services and move toward a cloud infrastructure model.

 

This presentation will help you understand the Exadata Cloud portfolio and how it can help you to modernize database infrastructure and support cloud initiatives.

 

Bryce Cracco is a Senior Principal Product Manager at Oracle. Bryce has extensive product management and technology experience in areas spanning public cloud infrastructure, Kubernetes infrastructure, enterprise storage, and web applications. Currently, Bryce is focused on product definition for Oracle’s Exadata Cloud portfolio of services. These services help Oracle customers to modernize data management infrastructure by removing common barriers to moving these critical systems to a cloud model.

 

Presentation Slides: 4-1_Modernizing Database Infrastructure With Exadata Cloud-Deck 6.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_4-2

 

This session will provide a walkthrough of Oracle Real Application Testing (RAT), how to implement it highlighting both command line and OEM methods. The discussion will also include how to interpret the results and best practices.

 

Executive Director AEM Corporation Speaking Engagements: Oracle East Coast User Conference, Oracle Fed Forum, Adjunct Instructor at George Mason University.

 

Over 20 years of professional IT experience with extensive focus on Oracle Database Administration. Experience implementing complex Oracle technologies such as Exadata, Advanced Replication, Dataguard, GoldenGate, Oracle RAC, WebLogic, and Oracle RAT.

 

Certifications:

Oracle Cloud Infrastructure Architect Associate

Oracle Exadata Implementation Specialist

Oracle Real Application Clusters and Grid Infrastructure Administration

Oracle Certified Professional

Certified Information Security Manager (CISM)

Project Management Professional

 

Presentation Slides: 4-2_Oracle Real Application Testing-020722-AEM .pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_4-3

 

Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere. Using APEX,developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. In this session, we are showing new features introduced with APEX 21.1 and APEX 21.2. We'll demonstrate the new maps region, support for spatial data types, and the new geolocation item type.You'll see several enhancements to Faceted Search including support for Cards region and multi-value columns. We'll round out this session with a preview of the new built-in support for progressive web apps (PWA).

 

Marc Sewtz is Director of Software Development for Oracle APEX at Oracle America, Inc. He is responsible for the development and delivery of APEX and manages a global team of software engineers. APEX is Oracle’s premiere Low-Code development platform, which enables customers to build modern, scalable, and secure enterprise apps. Marc has been with Oracle since 1998. After working for Oracle Consulting in Hamburg (Germany), New York, Washington DC and Chicago for several years, he joined the APEX development team in 2002.

 

Presentation Slides: 4-3_Oracle APEX New Features and Roadmap - MSewtz.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.


 

Session_4-4 and Session_5-3


This presentation will focus on what specific Algorithms that are inside Oracle can be applied to Business Problems. Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man's Mind to further replace man's most basic tasks.

 

 This session will focus on ML 101 and building the future ahead. Some business issues are seasonal, some relate to customers with certain attributes, some relate to customers we don't know exist, but all can be solved by using the correct algorithm to quickly prescribe a better corporate future. We will also dive into where AutoML fits in the process with many examples of Machine Learning.

 

 Objectives:

 -Learn ML algorithm uses.

 -Learn what ML is in Oracle.

 -Learn how ML solves business problems.

 

Rich Niemiec is a world renowned Oracle Expert. Rich is an Oracle Ace Director and was a co-founder and the CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions started in 1988. Rich has served as President of Rolta TUSC and Rolta EICT. TUSC was the Oracle Partner of the Year in 2002, 2004, 2007, 2008, 2010 (Rolta TUSC), & 2011, 2012 (Rolta). Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). Rich won IOUG’s Chris Wooldridge Award in 2012. Rich is one of six originally honored worldwide Oracle Certified Masters. In 2012, he authored the #1 Oracle bestseller "Oracle11g Release 2 Performance Tuning Tips & Techniques," an update of his previous 3 Oracle best sellers on Oracle8i, Oracle9i, and Oracle10g Performance Tuning. Rich was inducted into the Entrepreneurship Hall of Fame in 1998.

 

Presentation Slides: 4-4-_5-3_Machine_Language_101.pdf

Presentation Recording:


Part 1 - Session recordings are available now in our Members-Only section of this website.


Part 2 - Session recordings are available now in our Members-Only section of this website.

 

Session_4-5

 

Oracle Data Pump is one of the most widely used features by DBAs, and comes free as a part of every database edition. With each release more features and functionality are added to help move large volumes of data and metadata between and into Oracle Database.

 

This session will cover the new features added to Data Pump for Oracle Database 21c Cloud and on-premises, and will present two cloud migration demos. It will also cover several Data Pump best practices and the 19c "SuperPatch" merge patch. Time and interest permitting it will recap highlights of new features in 19c, 18c, and 12.2.0.1.  Whether you use Data Pump for table-mode exports, schemas, full databases, or transportable tablespace migrations, you will find new features to make your work faster and easier than ever before!

 

Bill Beauregard is a Senior Principal Product Manager in the Oracle Upgrades, Migrations and Patching group. Bill is responsible for Oracle Database Utilities product management, and release management for Upgrades, Migrations and Patching. He presents at Oracle User Group events and works with Oracle customers in collaboration with Oracle Presales and Oracle Support. Find more information at https://www.oracle.com/database/technologies/upgrades.html.

 

Presentation Slides: 4-5_New Features in Data Pump for Oracle Database 21c, Best Practices, 19c Superpatch.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_5-1

 

You think you have seen it all... and then you see something new. I have studied literally hundreds of AWR reports and thought through thousands of performance scenarios.

 

While I know how to use an AWR or Statspack report to analyze Oracle performance, I have also learned how to totally mess-up the analysis.

 

 There are some obvious ways to totally invalidate your analysis. But there are also some subtle mess-ups that fool you into thinking your time-based analysis is rock solid...yet it's worthless and probably misleading.

 

Join me for a light-hearted session as we explore what NOT to do.

 

Craig is a long time Oracle DBA who specializes in Oracle tuning and machine learning. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker a passionate teacher and an Oracle ACE Director.

 

Presentation Slides: No Presentation Slides

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_5-2

 

Randy Newman composed the song for Toy Story called "Youíve Got a Friend in Me" where it mentions ìYou got troubles, Iíve got ëem too.î In this talk, we will discuss how Google Cloud Platform and Oracle RDBMS can work together to give you the best of both worlds.

 

We will detail how backups to GCP can be used to meet different needs of their organization and how to justify the use of new technology within their business. Learn how to create a clone of your database with GCP snapshots or set up an NFS mount from a GCP filestore for RMAN backups. Learn how to orchestrate your Oracle Database 19c (PDB) in GCP, and last but not least modernize Oracle operations with Kubernetes Google Cloud and Oracle Databases.

 

Currently I am an Oracle ACE; Speaker at Oracle Open World, Oracle Developers Day, OTN Tour Latin America and APAC region and IOUG Collaborate ; Prior Co-President of ORAMEX (Mexico Oracle User Group), Web Events Chair for IOUG Cloud Computing Special Interest Group (SIG) ; At the moment I am Cloud Architect at Eclipsys.

 

Formerly I worked for Oracle as a Cloud Solution Architect in which it involved in many challenging projects including, Exadata, ODA and EM 12c implementation, as well as upgrade projects specialising in backup strategy and high availability solutions.

 

In my free time I like to say that I’m Movie Fanatic, Music Lover and bringing the best from México (Mexihtli) to the rest of the world and in the process photographing it. 

 

Presentation Slides: 5-2_Google and Oracle You've Got a Friend in Me_Eclipsys.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_5-4

 

For years security teams have preached the importance of layered security or Defense in Depth. This created a check-the-box mentality among IT practitioners and a whole new market of security products that would theoretically help an organization ìbe secure.î

 

The problem with this mentality is it focuses on a single point-in-time, for example, preparing for an audit. Boxes are checked, audit is complete, now you can forget about security until the next audit.

 

This approach misses the mark because while your security configuration will remain stagnant during this period, your data most certainly will not nor will the tactics of your adversaries that want your data. This method leads to a fundamental shift in the approach to security, making data the critical component, not the underlying infrastructure.

 

This presentation will focus on leveraging the data life-cycle to ensure your sensitive data is properly identified and secured from creation through disposal and discuss the following broad topics:

 

  - What is Data-Centric Security?

  - How can one achieve this state?

  - When can it be implemented in the project life-cycle?

  - What is the data life-cycle and how does it impact security?

  - What role can system analysis and design play in data-centric security?

  - What tools can be utilized to maximize data security?

 

Ultimately this discussion will enable attendees to better assess what data they should consider protecting, how to assess where data is at risk, and finally engage the appropriate resources to ensure it is secure.

 

I am a CISSP, CCSP and OCP technologist with over 20 years of implementation life cycle experience. I've worked across public and private sector providing consulting services focused on Oracle technologies, now I'm working with Rubrik to provide customers with improved data security & recoverability.

 

Presentation Slides: 5-4_Data-Centric Security Protecting Data from Cradle to Grave.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.


Session_5-5

 

Have you ever grabbed your phone to unwind for "just a minute," and the next thing you knew, it was an hour (or more) later?

 

What did you want to do with that hour?

 

What would recovering just some of that lost time do for your career, your family, your marriage, or your health?

 

Join me to find out how to recover your lost time.

 

For over 20 years, Stephen Andert has been engaged in a variety of leading-edge IT technologies including many years as a Database Administrator. Stephen's appearances at local and international conferences have been well received and highly rated by attendees. Stephen has written a book on Oracle performance tuning and another on business travel.

 

Stephen spent five years as a Corporate Storage Solutions Architect with IBM, building relationships around the world, with a focus on Latin America. Now he is working for Crunchy Data, helping customers find solutions to their thorniest open-source database problems.

 

Presentation Slides: 5-5_SPOF - Single Point of Focus or How to Pay Attention and get Stuff Done-Andert.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.


 

Session_6-1

 

Transportable Tablespaces (TTS) have existed since Oracle 8i, and they are a method used to exchange data between databases in an efficient way. With every new release, the capabilities have been enhanced, for example, Cross-platform TTS (xTSS) in Oracle 10g or Restore Foreign Tablespace/Datafile in Oracle 12c.

In the last few months, I was involved in a customer project where the main goal was to upgrade/migrate an existing Oracle 11gR2 databases to 19c (including the switch to the CDB architecture). For a lot of databases, the TTS approach was used.

 

This presentation summarizes the experiences gathered with the TTS procedure including all ups and downs. After an introduction to TTS itself, different methods of copying the datafiles are presented - for example, DBMS_FILE_TRANSFER or Foreign Tablespace/Datafile Restore with RMAN. The next part of the presentation covers pitfalls and challenges with the actual data migration.

 

New features and enhancements introduced with 19c and 21c are also part of the presentation.

 

Christian Gohmann is currently working as Principal Consultant and Instructor at Trivadis Germany GmbH in Dusseldorf, Germany. His main focus lies in helping customers in the areas of architecture planning, implementation, and migration - with a specialization on high availability solutions, like Data Guard, Oracle RAC.

 

Since 2006, Christian Gohmann is working with Oracle and the Oracle Database and was part of a huge amount of different projects for customers in the German-speaking areas.

 

Besides his consultancy activities, he is the main developer and the responsible person for TVD-Backup - a product distributed by Trivadis, which is responsible for the intelligent backup and recovery of an Oracle database.

 

In his spare time, he shares his knowledge on his blog https://www.christian-gohmann.de.

 

Presentation Slides: 6-1_ xTTS - Lesson(s) learned.pdf 

Presentation Recoording: Session recordings are available now in our Members-Only section of this website.


 

Session_6-2

 

Smooth database operations are hindered when unexpected performance incidents occur. What if we could predict an incident was likely to occur within the next 60 seconds? Using Oracle Sysmetric data with Deep Learning neural networks, this can be a reality. This presentation will begin with recognizing patterns and how neural networks try to do the same. Then weíll look at Sysmetric data, understanding and leveraging its time-series nature.

 

 Now weíre ready to understand why neural networks and deep learning are sought after in performance prediction. An Oracle Cloud-Free Tier account is enough for a mind-blowing graphical demonstration of making real-time performance predictions. You can download everything necessary to replicate my demonstration and enabling you to tinker and explore! Once you get a glimpse of what is possible, a whole new world of performance monitoring and alerting will appear before you. Join me for a fascinating applied Machine Learning presentation for the Oracle DBA of the future.

 

Craig is a long time Oracle DBA who specializes in Oracle tuning and machine learning. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker a passionate teacher and an Oracle ACE Director.

 

Presentation Slides: No Presentation Slides

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_6-3

 

Flexibility to target and load specific setup is key in any E-Business Suite or Fusion Cloud implementation, roll out, release cycle, upgrade / patch cycle etc. ConfigSnapshot puts this flexibility in your hands in a matter of minutes.

 

ConfigSnapshot is a unique tool developed over the past 20 years to provide comprehensive yet flexible and agile control around the E-Business Suite and Fusion Cloud applications. Used in all stages of the application lifecycles, it quickly finds and tracks change across patch levels, environments / pods, business entities and time. Using ConfigSnapshot you have clear concise visibility of change, putting you in control of it.  You can then be more proactive, drive and automate changes across environments / pods, business entities, updates etc using ConfigSnapshot.

 

Hundreds of organisations globally use ConfigSnapshot today to support a wide range of requirements including generation of documentation (BR100s / MC050 etc), identification of EBS customisations, upgrade / patch impact analysis, comparisons across environment, entities, versions and time, automation of setup creation and migration (including migrations from EBS to Cloud), change tracking and user access / segregation of duties reporting etc.

 

During this session we will outline the various areas of the ConfigSnapshot functionality used to manage, control and automate change in the E-Business Suite and Cloud Applications. We will then focus on the setup loading / migration functionality and provide a product demonstration. The session should be of interest to all users of the E-Business Suite and Cloud Applications.

 

Gordon Halley initially worked as a Management Consultant on various business improvement projects in Europe and Asia. He has spent the last 20 years working in a variety of roles globally to deliver Oracle E-Business Suite projects, architecting E-Business Suite solutions and more recently as part of the ConfigSnapshot team in product and business development (E-Business Suite and Cloud Applications).

 

 

Presentation Slides: No Presentation Slides 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_6-4

 

What do you need to build a fully automated DBaaS stack? Hardware, Software, and a heterogeneous team with a passion for automation. I am proud to be part of the team which has ramped up in the last months a DBaaS for a large Swiss customer with a huge bandwidth of technology. From PCA to ZDLRA, from VMWare vRA to Ansible Tower, from Jira Tasks to Scaled Agile Framework, each team member brought in his expertise to bring the service to the market.

 

I will show you what you need to build such a service from scratch. And what I can tell you, the passionate team is the key to success. I am not talking only about tech stuff, we want to see what is required in the back, and how long the way is from the first sprint planning to customer readiness.

 

Since 2007 I have been working in the area of Oracle databases and middleware products. I have a degree in Computer Science Engineering, am an Oracle Database Cloud Certified Administrator and have completed Module 1 as an adult educator (AWeb) at the University of Applied Sciences Northwestern Switzerland in Basel. I work for Trivadis - Part or Accenture as a Platform Architect for our customers and teach courses on topics such as Oracle Architecture and Oracle Cloud Infrastructure OCI. And since June 2020, I am an Oracle ACE Associate.

 

I live with my family in Switzerland in a small village at the southern foot of the Jura, centrally located in relation to the centers of Berne, Basel and Zurich. When I’m not roaming around on Oracle products to discover new features, I enjoy my free time with my family, out in nature or in some animal park. Or on duty or in training with the fire department.

 

This is my blog where I write on a regular base about Oracle or other stuff: martinberger.com

 

Presentation Slides: 6-4_From DBA to DevOps - How to build a modern DBaaS Platform.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_6-5

 

Graphs are a different way of looking at data, and a graph data model provides new insights based on the connections and relationships in data. Growing numbers of developers and data scientists want to access graph capabilities to find clusters, detect paths, and uncover unusual patterns in data. The graph feature of Oracle Database enables developers to create graphs from database tables, search for graph patterns, and apply graph algorithms to data.

 

This session is a how-to for DBAs and developers to support their organizations in using the graph feature of Oracle Database. We will explain what the graph feature is, how it can be installed, what components are necessary, what tools are available, and how developers can get started with querying and analyzing graphs in a short time.

 

Melli Annamalai is a distinguished product manager at Oracle. Starting with her career as a developer, she has 20+ years experience in working with unstructured and semi-structured data in the database, including multimedia data, data in Apache Hadoop platforms, property graphs, and RDF knowledge graphs. Her current focus area is graph database and analytics, in particular on ways to make it easy for developers to use graphs in any application. She enjoys working with developers as they develop and deploy solutions to solve business problems, so that she can better tailor product enhancements to what developers need. She is a regular presenter at industry events, Oracle User Group meetings and techcasts, and Oracle Developer events. Melli has a Ph.D. in Computer Science From Purdue University.

 

Presentation Slides: 6-5_OracleGraphHow-ToForDBAsandDevelopers_RMOUG.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_6-6

 

Business rules define the requirements that data needs to satisfy so that it is fully valid for the business. A PL/SQL Table API provides a centralized location for the code you write to represent those business rules. Regardless of your development environment -- APEX, ADF, MAF, JET, MAX, VB/VB Studio, Java, JavaScript, or any other framework -- using a Table API to implement business rules validations has many benefits including better performance, reduced cloud database costs, simplification of user interface code, and more secure applications.

 

This session explains the benefits of this kind of centralized code in more detail and gives advice about how to incorporate it into your development practices. It then focuses on the code components and strategies relevant to using a PL/SQL Table API. In addition, the session discusses several methods for calling Table API code. The presentation also describes and demonstrates methods for automatically generating a large part of the code and shows examples of generated code as well as code that calls the Table API.

 

 

Peter Koletzke is an Oracle ACE Director who has worked for over 37 years in the IT industry and has presented at various Oracle technology conferences around the world over 380 times. Additionally, he has won over a dozen user group awards from ODTUG, NYOUG, UTOUG, and ECO/SEOUC. Peter is also an Oracle Certified Master, UTOUG board member, past board member of IOUG and NYOUG, and co-author of eight books – with Duncan Mills, Avrom Roy-Faderman, and Dr. Paul Dorsey and published by Oracle Press (McGraw-Hill Professional) -- about Oracle JDeveloper/ADF, Oracle Forms and Reports, and Oracle Designer.

 

Presentation Slides: 6-6_Implementing Business Rules Code with a PLSQL Table API.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_6-7

 

Learn how to install and build Python applications that connect to Oracle Autonomous Database on the cloud. This session shows building a web service from the ground up. It uses the popular Flask framework and shows how connection pooling, batch statement execution, and other unique Oracle features can make the web service scalable and highly available.

 

Sharad Chandran is the Principal Product Manager for the Data Access Group at Oracle. He and his team work on building client-side interfaces and APIs for the Oracle DB in various languages like C/C++, Python, Node.js, etc. Sharad has developed various well-documented features such as pre-compile directives and external library interfaces for Oracle in his earlier capacity as a Senior Programmer. He has published multiple articles that explain how to interface Python frameworks with Oracle Database in his current role. Sharad blogs at http://blogs.oracle.com/opal. His Twitter handle is @SharadChan87.

 

Presentation Slides: 6-7_Getting-Started-with-Python-and-Oracle-Autonomous-Database.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_7-1

 

The first is simple to answer: Zero Data Loss Recovery Appliance (ZDLRA) is an Oracle Engineering System. But what does this mean?

 

Here I will share my experience about using it, showing what ZDLRA is, and how to use features like virtual full backups, Real-Time Redo transport, and native replication. You will see how they can help you in your daily work and check if it is worth it.

 

I am not an Oracle employee, so, this is not a marketing session. I will share my experience of using ZDLRA and hope that this will help you to understand it better. In this session, you will see how the features work and how to protect your database using ZDLRA.

 

I am Senior Database Architect with experience with Oracle Database, working since 2010 with Exadata and since 2014 with ZDLRA to design mission-critical and high availability environments with MAA using RAC, Data Guard, HA, and/for multi-site protection. But also experience with fieldwork activities like resource manager, impact estimation, upgrade, patch deploy, and patch apply. Worked to design and implement the first ZDLRA in Brazil, and one of the first of replicated ZDLRA project of the world (2015). The same for Exadata V2 (2010) in Brazil. Oracle ACE, LUXOUG Board member, and speaker in several Oracle Conferences (OOW), and usergroups conferences as well.

 

Presentation Slides: 7-1_ZDLRA What It Is- Is It Worth It-2022.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_7-2

 

Come and learn how to play with the Smart Scan. We'll use a lot of examples to explain and demonstrate how Smart Scan works on Exadata. Understand the scenarios Smart Scan will be used and the ones it won't, and why it was not used.

 

 Column projection, predicate filtering, storage index, SQL offloading ... understand all of this and how they make Exadata what it is.

 

 This will be a live session, so anything can happen.

 

"Franky Faust works for Pythian as Senior Oracle Database Consultant. He has extensive knowledge in Oracle Exadata and High Availability technologies and in other databases like Snowflake DB, MySQL, Cassandra and SQL Server.

 

He is always improving his skills focusing on researching Oracle performance and HA. Franky has been involved in some major implementations of multi node RAC in AIX, Linux and Exadata and multisite DataGuard environments. He is OCP 12c, OCE SQL, OCA 11g, OCS Linux 6 and RAC 12c, OCI and AWS Solutions Architect, Snowflake SnowPro certified and was nominated Oracle ACE in 2017.

 

He is well known in the Brazilian community for his blog http://loredata.com.br/blog and for all the contribution he provides to the Oracle Brazilian community. Franky is also a frequent writer for OTN and speaker at some Oracle and database conferences around the world. Feel free to contact him on social media."

 

Presentation Slides: 7-2_ Exadata Smart Scan_ Live and uncensored.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_7-3

 

The Latest Persistent Memory such as Intel Optane Persistent Memory (PMEM) combines near-DRAM performance with the data persistence of storage. It can be configured in memory mode or application direct mode. When memory mode is used, PMEMs can be considered as volatile and can be used as main memory and DRAM is treated as a write-back cache. PMEMs can also be configured in application direct mode to store database files and redo logs.

 

 This presentation will discuss the use cases of PMEM:

 1) In memory mode, using PMEMs for Oracle In Memory store.

 2) in App-direct  mode to store the database files. We will discuss this App-direct mode as supported with Oracle Memory Speed File system (OMS) in 19c and  directly mapped buffer cache and Persistent Memory Filestore (PMEM Filestore) in Oracle 21c.

 

 We will also discuss the significant performance benefits that can be achieved from either of these two modes.

 

Kai Yu is a Distinguished Engineer in Dell EMC Solutions Engineering and a member of Dell Technical Leadership Community. Kai has 26 years’ experience of architecting and implementing various IT solutions by specializing in Oracle RAC database, Oracle BI and Oracle EBS, Virtualization/Cloud. Kai has been a frequent speaker at various IT/Oracle conferences with over 190 presentations in more than 20 countries. He also authored 35 articles in technical journals such as IEEE Transactions on Big Data, IOUG Select and Dell Power Solutions and co-authored Apress book “Expert Oracle RAC12c”. Kai has taken some leadership positions in IOUG such as IOUG conference committee member, IOUG RAC SIG president and IOUG Cloud SIG co-founder and the current vice president. Kai has been an Oracle ACE Director since 2010 and was featured as Oracle ACE Spotlight by OTN. He also received the 2011 OAUG Innovator of Year award the 2012 Oracle Excellence Award: Technologist of the Year: Cloud Architect by Oracle Magazine. Kai has shared all his technical articles and conference presentations on his Oracle blog: https://kyuoracleblog.wordpress.com/

 

Presentation Slides: 7-3_Boosting Database Performance in Oracle 19c and 21c Databases With Persistent Memory.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_7-4

 

Managing Infrastructure as code is one of the pillars on the road to fully automation of your applications and their underlying infrastructure. DevOps teams are in need to automate to the highest level of order. Customers these days are migrating more and more into the Oracle Cloud, but are in need of more automation and uniform methods to provision their systems into the Oracle Cloud.

 

This session tells about how to do this using cloud native tools such as Terraform, Kubernetes, and cloud native pipelines using Jenkins(X), Tekton, and others.

 

Having made his start in the pharmacy sector, Michel transitioned to IT in 1996, working on a UNIX TTY terminal-based system and the MUMPS language. He currently works as a solutions architect at Qualogy, with a focus on middleware, application integration and service-oriented architecture. His passion for middleware started in 2000 with middleware such as BEA WebLogic and Tuxedo. Michel is an expert on the WebLogic platform. He serves customers in his role as architect and advises them in all aspects of their IT landscape. He became an Oracle ACE in 2012 and ACE Director in 2019. He wrote two books about WebLogic: Oracle WebLogic Server 11gR1 PS2: Administration Essentials and Oracle WebLogic Server 12c: First Look.

 

Since a few years he is also a contributor to the OpenSource community and solutions regarding containerization and DevOps.

 

Furthermore, he is a well known expert in the several communities and speaks regular on big events in the EMEA region and worldwide, such as KubeCon, Continuous Delivery Summit, Oracle OpenWorld, Groundbreakers Developers Tours and several other tech conferences.

 

Read also more at: http://www.qualogy.nl/techblog/author/michel-schildmeijer

 

Presentation Slides: 7-4_Kickoff Terraform CI CD into the Oracle Cloud.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_7-5 and Session_8-4

 

Learn how to quickly and easily build a Shopping Cart app with APEX. Using this app, administrators can manage products, customers, and stores. On the other side, customers can review and add products to the cart and eventually proceed to checkout.

 

You start with installing a sample dataset and then building the app with pages such as Dashboard, Products, and multiple reports. Then, you add pages such as Orders and Shopping Cart. Lastly, you will be updating some of the components to improve the initial app.

 

 The application will have two application roles:

 

 - Administrators

      - To manage the products, customers, and stores.

      - To run a dashboard to identify the top products.

 - Customers

      - To review, add, delete, or edit the number of products in the shopping cart.

      - To submit orders.

 

Mónica Godoy is a Product Manager at Oracle in Cali, Colombia. With more than 10 years of experience, Mónica has worked using Oracle Technologies such as, Oracle Application Express, Oracle Forms & Reports. She has presented at conferences in Latin America like OTN, Oracle Code and Oracle Groundbreakers Tour. Mónica also manages the Women in APEX Group: https://www.womeninapex.com/

 

Presentation Slides: 7-5_8-4__Building a Starter Online Shopping App with Oracle APEX.pdf

Presentation Recording:

Part 1 - Session recordings are available now in our Members-Only section of this website.

Part 2 - Session recordings are available now in our Members-Only section of this website.


Session_7-6


Cloud is the new frontier of computing for government agencies, and transitioning to cloud services is an essential step toward reliable, scalable, and cost effective IT solutions. A cloud-enabled IT infrastructure is critical to the security of U.S. defense and intelligence agencies, as well as civilian, and state and local governments.

 

Oracleís FedRAMP-compliant cloud services span applications and infrastructure solutions across SaaS, PaaS, and IaaS, making it easier than ever for government agencies to digitally transform legacy mission systems securely, efficiently, and effectively. Oracle services are compliant with†GSAís FedRAMP†standards, with engineered industry-leading security features that include encryption, optimization for critical workloads, and superior performance, with speeds 10x faster than other providers.

 

By moving to the cloud, Federal Agencies can mitigate security risks, reduce operational costs, and stay on top of ever-changing citizen needs. Oracleís cloud infrastructure and applications follow rigorous processes and use effective security controls in all phases of cloud service development and operation.

 

In this session we will review how Oracleís government cloud offers the consistent performance that agencies and contractors need for mission-critical workloads, and how it provides the management and monitoring capabilities that IT teams need to optimize cloud resources. We will focus on Oracleís FedRAMP solutions that allows federal, state, and local agencies to migrate workloads to the cloud more securely, enabling government to focus on their core mission to deliver modern citizen services.

 

Nitin Vengurlekar is the Chief Technology Strategist for Oracle Government and Education, with Thought Leadership, Sales Enablement, and Full stack implementation architect, as the primary responsibilities. Nitin is recognized as the premiere thought leader in the Oracle Community and is a well-known and highly recognized technologist in the areas of Storage, High Availability, and Cloud. Nitin has written many papers on storage, database tuning, and served as a contributor to Oracle documentation as well as Oracle education material.

 

For the recognition of Oracle Community leadership, Nitin earned Oracle ACE Director and VMware vExpert recognition. Nitin has presented at Oracle Open World consecutively from 2004-2019, and lead many other Oracle conferences (IOUG, AIOUG, RMOUG, etc). In a previous stint at Oracle (1995-2012), Nitin was key member of the Real Application Cluster (RAC) engineering group, RAC Product Management Team (the famous RacPack team), and original member of the Exadata Test Team. Nitin has written eight Oracle technology books, four of these books are considered to be the “bible” and premiere sources of information in its respective field.

 

Nitin sits on the curriculum board for the following colleges: Collin College - Computer Systems/Web & Mobile Applications Advisory Committee Dallas Community Colleges (DCCCD) - Cloud curriculum Advisory Board.

 

Presentation Slides: 7-6_Oracle GovCloud 2022_ A Portrait Cloud Computing Excellence.pdf

Presentation Recording: No Presentation Recording

 

Session_8-1

 

Tuning SQL statements in Oracle is more of an art than a science. In this session we will cover the basic tools and steps to tuning a SQL statement starting with finding the SQL statement and collecting the right information. How does the Optimizer work to transform SQL into an execution plan? What information is an execution plan is trying to show? Finally, what are some of the things that can be tuned as well as tools Oracle has provided to make things easier. If you are new to tuning SQL in Oracle or trying to freshen up your skills, this session should have enough information for everyone.

 

Gary Gordhamer has spent much of his career focusing on enterprise application landscape and business process digitization. His technical experiences range from Oracle e-Business suite, middleware, database and related technologies for the past 27 years. His professional background covers many industries including healthcare, manufacturing, utilities, and government. He is an active member of the QUEST IOUG Database & Technology Community, serving on the advisory board. Gary is an Oracle ACE associate, and frequent presenter at Oracle OpenWorld and COLLABORATE.

 

Presentation Slides: 8-1_Tune that SQL_Now What Do I Do.pdf 

Presentation Recording: No Presentation Recording Due To Technical Difficulties

 

Session_8-2

 

Join this session to hear from an E-Business Suite veteran, with more than two decades supporting E-Business Suite running the business, about his first year running in Fusion Applications. What are the key considerations and how to get a sustainable long-term IT plan for Oracle SaaS?

 

As an Oracle customer for almost two decades, we've been taking our own medicine by running for our operations E-Business Suite since version 11.5.8 up to release 12.2. As a natural evolution of our organization, our journey to the cloud involved the uptake of EBS to Oracle Cloud SaaS, including Oracle Cloud ERP, HCM, and PPM.

 

The Pandemic hit us during our implementation, but that did not stop us from going live in November 2020.  We've been running all our operations globally since then.

 

In this session, attendees will hear about the ten most significant changes needed to adapt while transitioning from an on-premise system to a Software as a Service enterprise solution -- a learning experience from the administration, reporting, and integration.

 

We'll share details of some important aspects that have changed, such as planning of POD P2T, changes Oracle technology impacts our POD, reporting strategy, and more. Finally, since we have global operations, we will share what is needed to successfully implement LATAM Globalizations (Argentina, Brazil, & Mexico).

 

Gustavo is IT Convergence’s Chief Technology Officer (CTO) leading internal Cloud SaaS implementation as well as helping customers on their journey to the cloud.

 

Presentation Slides: 8-2_After 15_ Years Running on EBS, Ten Learnings of the First Year Running on Fusion Apps.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_8-3

 

Had enough of the pressures and demands of the modern Oracle DBA role? If youíre frustrated enough to consider leaving the IT industry altogether as a result, take heart and instead learn how to make the transition to the new role of Data Science Engineer (DSE). Weíll chat about the ongoing stresses most DBAs face today, including ever-increasing responsibility for an average of 100 databases per person, the challenges of keeping all those environments patched and secured, and the ongoing transition between migration to public clouds vs. private on-premises datacenters. Best of all, weíll delineate how much of what DBAs already do today fit perfectly into this new, in-demand role.

 

 This session will:

 - Explain what the DSE role often entails in forward-looking IT teams.

 - Describe what current skills are needed to fulfill the role, and what upskilling is required.

 - Discuss how best to maintain relevance for your careerís foreseeable future.

 

Jim Czuprynski has over forty years of professional experience in Information Technology, serving diverse roles at various Fortune 1000 companies before becoming an Oracle DBA in 2001. He has been an Oracle ACE Director since 2014 and is a sought-after public speaker on Oracle technology, presenting often at Oracle OpenWorld, Oracle CODE, COLLABORATE, Kscope, Oracle Development Community tours, and Oracle User Group conferences around the world.

 

Jim has authored 100+ articles on Oracle Database administration, ML/analytics, and APEX since 2003 at databasejournal.com, IOUG SELECT, and ODTUG TechCeleration and has co-authored four books on Oracle database technology. Jim’s blog, Generally … It Depends (https://jimthewhyguy.com), contains his regular observations on all things Oracle and the state of the IT industry. Jim also co-hosts the Beyond Tech Skills podcast (https://www.beyondtechskills.com), which discusses everything about tech … except tech.

 

Presentation Slides: 8-3_From DBA to DSE_Becoming a Data Science Engineer.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_8-5

 

Oracle Enterprise Manager (OEM) brings your Oracle deployments together in a single management, monitoring, and automation dashboard. Oracle developed this solution, so it offers deep integration with many of its technologies. The ease of integration, coupled with the support of both on-premise and cloud-based Oracle databases, allows it to fit into many enterprise infrastructures. OEM can also monitor and manage non-Oracle databases, making it a cost-effective and central tool to manage IT environments with a mix of database platforms.

 

The single point of control is appealing for complex enterprise infrastructures, especially when they’re heavily invested in Oracle technologies. Out-of-the-box monitoring and reporting templates cover many common use cases and simplify the configuration of management automation for databases, applications, and more.

 

This presentation takes on a brief history of OEM and then does a deep dive into seven robust features organizations should consider implementing:

 

    Intelligent Incident Compression (Smart Alerting)

    Chef Job Support

    Always-ON Monitoring

    Notification Blackouts

    System Broadcast

    Export & Import Incident Rule Sets

    Metric Enhancements

 

Zane Warton is a Senior Oracle DBA for Datavail’s Oracle Practice and manages a team of six DBAs. He brings 20+ years of experience in IT and specializes in Oracle database administration from version 7.3.4 to 19c, and recently has added experience in AWS and Oracle Cloud Infrastructure. He brings value to Datavail’s customers with his expert ability to troubleshoot database issues and solution them. Zane has obtained a Master of Science degree in Information Systems, after his Bachelor's degree in Archaeology which had taught him that outside was hot, contained too many snakes, and that a life in IT might be more pleasant.

 

Presentation Slides: No Presentation Slides 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_9-1

 

Today’s business environment presents a myriad of challenges for organizations looking to secure identity, protect sensitive data, and reduce risk from fraud. Between a combination of dynamic (remote) access requirements and complex business processes, it is clear that modern security strategies must simultaneously focus on the application, transaction, and data levels to be effective. But in a landscape of disparate solutions, detective controls, and static governance – how can you evolve and modernize your security strategy? What should you truly be focused on?

 

Join Greg Wendt, Oracle security expert and executive director of Security Solutions at Appsian, as he breaks down today’s most pressing security challenges and provides best practices for organizations looking to ramp up their multi-layer security strategy – quickly and most effectively.

 

In this session, you will learn:

 

How to achieve a common control framework of data security & data privacy (for EBS and cross-application)

Best practices for integrating an EBS user authentication strategy into your enterprise-wide IAM strategy

How to identify and mitigate the most common responsibility conflicts that lead to SoD violations

How to implement and enforce strong controls for data loss prevention to prevent overexposure and exfiltration

How to implement security controls that help comply with IT security audits, SOX, GDPR, and other mandates

 

Mr. Wendt is one of the top ERP security experts with knowledge across multiple ERP platforms. During his 22-year career, he has been recognized as a leader in data security, application architecture and business operations.

 

Presentation Slides: No Presentation Slides 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_9-2

 

Oracle Cloud ERP and HCM are natural extensions of the widely used on premises ERP applications from Oracle: E-Business Suite and Peoplesoft. In this session, the depth and expertise that CherryRoad and Infosemantics' established across these and other legacy applications is applied and contrasted with best-of-breed SAAS applications. It discusses how to prepare your organization for this change, and how to to make the most of the paradigm shift to the Cloud applications, with Oracle in control of the backend.

 

Jim Haag - as General Manager, Jim is responsible for developing and delivering solutions that meet the needs of our clients allowing them to improve how they leverage technology and align with their organizational needs. He is responsible for overall client relationship management and leading our project teams in the delivery of custom solutions to ensure our clients success. Jim also contributes to CherryRoad’s proprietary knowledge base and thought leadership by identifying and commentating on how consumer trends and marketplace shifts affect business strategy and planning.

 

Jim joined CherryRoad Technologies in 1998 as a consultant, and since that time has held a number of positions within the operations side of the organization including Practice Manager, Practice Director, and Director of Contracts and Risk Management. He has successfully managed multiple projects in a variety of industries and has a proven track record of partnering with our clients to successfully deliver solutions that enhance both their operational efficiency and effectiveness. He earned a Bachelor of Science degree in Accounting from Montclair State University and is a certified PeopleSoft Consultant.

 

Jim states, “At CherryRoad we strive not only to meet our clients’ expectations, but to consistently exceed them over time. We take pride in creating long term partnerships with our clients and delivering value across multiple projects.  

                                                                                                                                                                                                                                    

Tom Heldt - At CherryRoad, our clients entrust us with the success of their IT solutions, whether we’re delivering on-premises ERP, cloud-based application management, business intelligence, process optimization, or change management consulting.     Throughout our 30-year history we’ve successfully partnered with hundreds of public sector and commercial clients to modernize, optimize and manage their back-office functions. Headquartered in Morris Plains, N.J. with offices across the U.S., we’ve earned a solid reputation for combining technology, organizational, functional, and vertical market expertise into practical solutions that deliver results – on-time and on-budget. For more information, visit www.cherryroad.com.At CherryRoad, our clients entrust us with the success of their IT solutions, whether we’re delivering on-premises ERP, cloud-based application management, business intelligence, process optimization, or change management consulting. Throughout our 30-year history we’ve successfully partnered with hundreds of public sector and commercial clients to modernize, optimize and manage their back-office functions. Headquartered in Morris Plains, N.J. with offices across the U.S., we’ve earned a solid reputation for combining technology, organizational, functional, and vertical market expertise into practical solutions that deliver results – on-time and on-budget. For more information, visit www.cherryroad.com.                                                                                                                     

 

Presentation Slides: 9-2_The Real Story - Lessons Learned Moving to Oracle Cloud ERP.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_9-3

 

In the brave new digitally-driven world, IT organizations can no longer focus on internal-only RDBMS databases as the central pillar of their infrastructure; data must be accessed externally as well, regardless of format or location, with utmost security. As we move into the future, the efficiency of Oracle in using InMemory, Machine Learning, Exadata, Documents, JSON, XML...etc. will be their main strength. Fortunately, Oracleís Converged Database strategy makes it simple to satisfy these demands.

 

Join ACE Directors Nitin Vengurlekar, Rich Niemiec and Jim Czuprynski as they explore the facets of Converged Database from the perspectives of CEO, CIO, and DBA, and what it means for your careerís future path.

 

Rich Niemiec is a world-renowned Oracle Expert. Rich is an Oracle Ace Director and was a co-founder and the CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions started in 1988. Rich has served as President of Rolta TUSC and Rolta EICT. TUSC was the Oracle Partner of the Year in 2002, 2004, 2007, 2008, 2010 (Rolta TUSC), & 2011, 2012 (Rolta). Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). Rich won IOUG’s Chris Wooldridge Award in 2012. Rich is one of six originally honored worldwide Oracle Certified Masters. In 2012, he authored the #1 Oracle bestseller "Oracle11g Release 2 Performance Tuning Tips & Techniques," an update of his previous 3 Oracle best sellers on Oracle8i, Oracle9i, and Oracle10g Performance Tuning. Rich was inducted into the Entrepreneurship Hall of Fame in 1998.

 

Jim Czuprynski has over forty years of professional experience in Information Technology, serving diverse roles at various Fortune 1000 companies before becoming an Oracle DBA in 2001. He has been an Oracle ACE Director since 2014 and is a sought-after public speaker on Oracle technology, presenting often at Oracle OpenWorld, Oracle CODE, COLLABORATE, Kscope, Oracle Development Community tours, and Oracle User Group conferences around the world.

 

Jim has authored 100+ articles on Oracle Database administration, ML/analytics, and APEX since 2003 at databasejournal.com, IOUG SELECT, and ODTUG TechCeleration and has co-authored four books on Oracle database technology. Jim’s blog, Generally … It Depends (https://jimthewhyguy.com), contains his regular observations on all things Oracle and the state of the IT industry. Jim also co-hosts the Beyond Tech Skills podcast (https://www.beyondtechskills.com), which discusses everything about tech … except tech.

 

Nitin Vengurlekar is the Chief Technology Strategist for Oracle Government and Education, with Thought Leadership, Sales Enablement, and Full stack implementation architect, as the primary responsibilities. Nitin is recognized as the premiere thought leader in the Oracle Community and is a well-known and highly recognized technologist in the areas of Storage, High Availability, and Cloud. Nitin has written many papers on storage, database tuning, and served as a contributor to Oracle documentation as well as Oracle education material.

 

For the recognition of Oracle Community leadership, Nitin earned Oracle ACE Director and VMware vExpert recognition. Nitin has presented at Oracle Open World consecutively from 2004-2019, and lead many other Oracle conferences (IOUG, AIOUG, RMOUG, etc). In a previous stint at Oracle (1995-2012), Nitin was key member of the Real Application Cluster (RAC) engineering group, RAC Product Management Team (the famous RacPack team), and original member of the Exadata Test Team. Nitin has written eight Oracle technology books, four of these books are considered to be the “bible” and premiere sources of information in its respective field.

 

Nitin sits on the curriculum board for the following colleges: Collin College - Computer Systems/Web & Mobile Applications Advisory Committee Dallas Community Colleges (DCCCD) - Cloud curriculum Advisory Board.

 

Presentation Slides: 9-3_Converged DB Is Oracles Best Kept Secret3.pdf

Presentation Recording: No Presentation Recording Due To Technical Difficulties

 

Session_9-4

 

Turning tables or procedures into RESTfull services with ORDS AutoREST is easy. And ORDS allows you to define your RESTful services, as well.

 

 But what is REST in the first place? What are HTTP-Methods and how do they work?

 How do I design an easy-to-use REST API, and how do I document it?

 

 This talk gives a comprehensive introduction to developing RESTful services for the database. This talk will cover the following topics:

 

  * REST and ORDS - what is it?

  * From scratch to your REST service in less than 100 seconds

  * The ORDS PL/SQL API.

  * Integration with SQL Developer - just a few clicks to the goal.

  * HTTP methods - which ones for what.

  * Parameter Mapping - in and out again.

  * Access Control Lists - annoying but useful.

  * Securing the service - basic-auth or token-based via OAUTH?

  * Documenting APIs with Swagger.

  * Generating and versioning service source codes with SQLcl.

 

 The talk will include extensive live demos. All sources will be made available for download.

 

Robert Marz is an Oracle ACE and Independent Consultant.

 

At customer sites, he works as a Senior Technical Architect with a database-centric view of the world.

 

Robert is Co-Founder and Co-Owner of Databee - The IT-Architects, a Germany based professional services company.

 

At DOAG (the German Oracle user group), he is in charge of the Cloud topics inside the database community. Robert is a member of ODTUG, IOUG, DOAG and RMOUG.

 

More than twenty-five years of experience in custom development and data warehouse projects makes him a specialist in Oracle database development and administration.

 

Additionally, he is skilled in the fields of automation, scripting languages, virtualization and cloud technologies.

 

Robert Marz publishes articles and papers in various publications and frequently speaks at German and international conferences.

 

Robert.Marz@databee.org

@RobbieDatabee

https://robbie.databee.org

 

Presentation Slides: 9-4_Deploy RESTful Services in Your Database.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_9-5

 

This presentation will touch on OCI basics with particular focus on the elements that go into architecting for performance. Architects have many concerns, not only must the businessís functional requirements be met, but there are other non-functional technical requirements as well, such as: scalability, reliability, performance, security Ö that cross the infrastructure stack (network, memory, compute, storage).

 

The presenter will guide you through the design decisions that go into establishing an OCI configuration that will meet the technical requirements. This will not be an OCI tutorial (as material on this is broadly available), but will summarize and highlight many of the excellent OCI capabilities.

 

Oracle ACE, Roger Cornejo has over 36 years’ experience with large/complex Oracle applications (versions 4.1.4 – 19c) in roles such as Developer, Tech Lead, Enterprise Architect, Database Architect and project manager. Roger has a strong background in DB performance analysis and tuning, and for the past 11 years, diving deep into AWR tuning data. As a thought leader, he has been sought out for his expertise in tuning (presenter at the past 11 East Coast Oracle Conferences, as well as INSYNC21, Oracle Open World, COLLABORATE, RMOUG, and Hotsos). Additionally, Roger authored a book on his recent work, Dynamic Oracle Performance Analytics: Using Normalized Metrics to Improve Database Speed, the book is available through Amazon and Apress: http://www.apress.com/9781484241363 https://www.linkedin.com/in/roger-cornejo-1805642/ @OracleDBTuning

 

Presentation Slides: 9-5_OCI-ArchitectingforPerformance.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_9-6

 

Oracle Cloud streamlines the creation of Assets through File Based Data Import (FBDI). This presentation will explain the extraction from legacy data sources, cleanup efforts, and the conversion needed to support Fixed Assets for an Oracle Cloud ERP implementation. We will draw on our experience handling this data for multiple industries and multiple clients -- including some of the world’s leading hospitals. The lessons we learned facing and overcoming obstacles during these implementations can be applied to all industries. The purpose of this presentation is to help make the process of Fixed Assets Oracle Cloud data conversion as smooth as possible.

The following topics will be covered:

 - Data issues/cleanup activities
 - Data enrichment
 - Configuration alignment
 - Related Modules/Dependencies

Additionally, we will use Fixed Assets as a springboard to discuss Oracle’s load process and ways to optimize your data conversion approach to minimize downtime and business disruptions for cutover. To gain confidence in your data, we will even show you how you can use Oracle BI publisher to extract data from Oracle’s backend tables to support validation and reconciliation.

 

Ishaan Khanna, an associate consultant at Premier International who has worked in mainly the Oracle Cloud space, focusing on the ETL process of multiple Oracle Cloud implementations. I am currently working as a project manager on a Oracle Cloud ETL project and have worked as a lead programmer on other Oracle Cloud implementations.                                                                                                                                         

 

Dennis Gray has spent close to a decade consulting enterprises and institutions as they navigate through IT transformation.  His data migration experience spans technologies from PeopleSoft and Oracle EBS to Oracle Cloud and industries from higher education to manufacturing.

 

Presentation Slides: 9-6_Lets Talk Oracle Cloud Fixed Assets_A Springboard for Understanding Data Enrichment, Data Migration, and Data Loads .pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_10-1

 

This session will cover Oracle RAC internals, which will help DBAs understand the underlying architecture in details and help them plan their environment. In this session, we will cover Oracle RAC Cache Fusion and some of the optimizations in the New Generation Oracle RAC that help scale the most demanding applications. We will discuss wait events and provide tips to reach AWR reports to quickly understand the root cause.

 

Anil Nair is the Product Manager for Oracle Real Application Clusters. Oracle RAC is a cluster database with a shared cache architecture that overcomes the limitations of traditional shared-nothing and shared-disk approaches to provide highly scalable and available database solutions for all your business applications.

 

Anil has been involved with Oracle RAC since inception. He has helped various customers with Oracle solutions specifically around Performance, availability, Scalability aspects for 20+ years.

 

Presentation Slides: 10-1_Oracle RAC 19c- Best Practices and Secret Internals.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_10-2

 

Migrating Oracle to Azure is the easiest because there are no database services available. You migrate the database to Azure IaaS. When going to AWS, there are two options - EC2 or RDS. Within RDS, the SE license is included or not, and EE. When it comes to OCI, the choices are even wider, and you have the option to bring your own license (BYOL). Let's discuss the various OCI database services and choose the right database service for your workload. Learn about the Oracle database on Virtual Machine, Bare Metal, Autonomous Database, Dedicated Exadata, and Cloud at your data center.

 

Biju Thomas, Oracle ACE Director, is the Global Oracle Practice Lead at Data Intensity. Biju has been developing and administering Oracle databases since 1993 and Oracle EBS since 2006. He is a frequent presenter at Oracle conferences. He has authored Oracle certification books published by Sybex. Biju blogs at http://www.bijoos.com/oraclenotes and you can follow him on Twitter (@biju_thomas) or Facebook (@oraclenotes). Check out his weekday Oracle Tidbits (#OraTidbit).

 

Presentation Slides: 10-2_IaaS, Oracle DBaaS, Autonomous, ExaCS, CloudCustomer How to Choose the Right Database Service on OCI.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_10-3

 

By now, everyone is aware that starting with Oracle Database 21c, non-containerized databases will no longer be supported. As customers upgrade to Oracle Database 19c, customers are adopting and embracing PDBs and learning to adapt to the new paradigm shift.

 

Come learn what it takes to effectively create, configure, manage, and monitor Oracle PDBs. Learn all the latest and greatest new features of Oracle PDBs from Oracle 12.2/18c/19c.

 

Charles Kim is an Oracle ACE Director, VMware vExpert, an Oracle Certified DBA, Certified Exadata Specialist, and a Certified Oracle Linux, Oracle Cloud,  and RAC Expert. Charles was selected in to the Oracle ACE Program on May 2008 and became an Oracle ACE Director as of December 2009. Charles has been an Oracle ACE Director every year since 2009. Charles became a VMware vExpert in the class of 2013.   Charles specializes in Cloud, Exadata, RAC, and Virtualization (VMware, KVM and Oracle VM) and co-authored ten books around the Oracle EcoSystem:

 

        Oracle Cloud Pocket Reference Guide ñ A Handbook on Oracle Cloud Infrastructure

        PDB Me to Oracle Cloud ñ A Lazy DBAís Guide to Mastering Multi-Tenant

        Exadata Expert Handbook

        Oracle Database 11g New Features for DBA and Developers

        Linux Recipes for Oracle DBAs

        Oracle Data Guard 11g Handbook

        Virtualizing Business Critical Oracle Databases: Database As A Service

        Oracle ASM 12c Pocket Reference Guide

        Virtualizing Hadoop

        Solaris and Linux Recipes for Oracle DBAs 

 

Charles is the Founder and CEO of Viscosity North America, a highly specialized niche consulting organization comprised of industry experts in Oracle Engineered Systems, RAC, Oracle Cloud, Virtualization and Performance Tuning.   Charles holds certifications in Oracle Databases, VMware, Red Hat & Oracle Linux, and Microsoft and has over 30 years of Oracle experience on mission and business critical databases. Charles presents regularly at local, regional, national and international Oracle conferences including IOUG Collaborate, VMware World, RMOUG, UKOUG, New Zealand/Australia Oracle User Group, and Oracle OpenWorld on topics of Oracle Cloud, RAC, Exadata, Database Consolidations, Private Database Cloud, ASM, Linux Best Practices, Data Guard Best Practices, Performance Tuning, VMware Virtualization Best Practices, and 7/24 High Availability Considerations.  His linkedin profile is: http://www.linkedin.com/in/chkim  His twitter tag is: @racdba

 

Presentation Slides: 10-3_The Rise of the PDB.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_10-4 and Session_11-3

 

In this session we will perform a deep dive into Oracle Audit Vault and Database Firewall (AVDF) version 20.4 and experience a live real-time demonstration of Oracle AVDF as it monitors both Oracle and non-Oracle database traffic to detect and block security threats via Database Firewall.

 

 We will also view how we can very easily create audit policies, configure alerts, detect both access as well as modification of sensitive data along with generating and viewing the extensive audit and compliance reports from the content-rich AVDF web console.

 

Oracle ACE Director and Oracle Certified Cloud and Database Master with over 25 years experience in the industry. Hosts a very popular web site Oracle DBA Tips and Techniques which has attracted over 13 million visitors.Regular speaker at various Oracle conferences held in Australia as well as around the world.

 

Presentation Slides: 10-4_11-3_Oracle Audit Vault and Database Firewall 20.4 - Live and in Action.pdf

Presentation Recording:

Part 1 - Session recordings are available now in our Members-Only section of this website.

Part 2 - Session recordings are available now in our Members-Only section of this website.


Session_10-5

 

Still havenít taken a look at Oracle Visual Builder? Join me for a tour of Oracleís JavaScript-based low-code development tool, Visual Builder.  Learn how to use Visual Builder to build and deploy web and mobile applications, or progressive web apps. Or, extend Oracle cloud applications, simply and quickly. And -- hereís the bonus -- manage the full development life cycle in an integrated, collaborative environment using Visual Builder Studio. Along the tour we will address such questions as;

 

-   Why a visual tool, why not just write code?

-   Why JavaScript? Do I have to be an expert?

-   What is the difference between Visual Builder and Visual Builder Studio? How are they integrated?

-   How does one get started? How hard is it build a real application? How hard is it to extend my cloud applications?

-   What investment - time, money, learning - is required to be productive?

-   Why use Visual Builder vs APEX or any other development tool?

-   Why use Visual Builder Studio -- can I skip that part?

-   Does using VB/VB Studio make a difference for one's Oracle cloud investment?

-   What are the next steps?

 

Attend and discover visual application development with Visual Builder and Visual Builder Studio.

 

Karen Cannell is President of TH Technology, a consulting firm providing Oracle technology services. A mechanical engineer by degree (one of them), she has analyzed, designed, developed, converted, upgraded, enhanced, and otherwise implemented legacy and commercial database applications for over 30 years, concentrating on Oracle technologies since 1994. She has worked with APEX since its beginnings and continues to leverage Oracle tools for clients in government, medical, and engineering industries. Karen is an ACE Director, ODTUG Vice President, frequent conference presenter and avid user group advocate. Karen can be reached at kcannell@thtechnology.com and @thtechnology on Twitter

 

Presentation Slides: 10-5_Meet Visual Builder, Oracle's Other Low Code Development Tool.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_11-1

 

With the latest release of Exadata X9, the Exadata architecture is being transformed to provide the world's most advanced data management platform for online transaction processing (OLTP), analytics, and converged workloads, using technologies such as persistent memory, remote direct memory access (RDMA), NVMe Flash, massively parallel processing, and deep database-centric software optimization at every level. Customers around the world have adopted Exadata and deployed their mission-critical and business-critical applications across on-premises, public cloud, and Cloud@Customer, enjoying unparalleled performance, availability, and scalability benefits. Come to this session led directly by Oracle Product Management to gain insights into Oracle's strategic vision into Exadata, along with best practices of Exadata deployment, lessons learned, and customer use-cases.

 

Ashish Ray is Vice President of Product Management within Oracle’s core database development organization. His product responsibilities include Autonomous Database, Exadata, Database Cloud Services, Zero Data Loss Recovery Appliance, and Oracle Database’s High Availability & Scalability solutions (Maximum Availability Architecture). Ashish has 25+ years of combined experience in software architecture design, software development and product management, focusing on the reliability, availability, and scalability issues of enterprise computing. Ashish has a BS and MS in Computer Science, and an MBA from Wharton Business School, University of Pennsylvania.

 

Presentation Slides: 11-1_Oracle Data Management Strategy With Exadata - Cloud, Cloud@Customer, On-Premises.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_11-2

 

Googleís Big Data Analytics solutions seamlessly unlock business insights with Google Cloud Platform's fully managed, proven, end-to-end data analytics products. Remove operational complexities of data analytics with a serverless approach and AI/ML capability to make important business decisions quickly and efficiently.  This session will provide an overview of Googleís Big Data Analytics solutions, such as BigQuery, Cloud DataFlow, Cloud DataProc, Cloud Pub/Sub, Cloud DataFusion, Cloud Composer, Data Catalog, Cloud Dataprep, AL/ML etc.

 

Daniel Liu is a Customer Engineer at Google for Public Sector State and Local Accounts and co-author of Oracle Database New Features - by Rampant TechPress.

 

A recognized database expert and a frequent speaker at various IT conferences, Daniel has published articles with DBAzine, Oracle Internals, Oracle Technology Network, and SELECT Journal. Daniel has received SELECT Editorial Award for Best Article in 2001,  he has been named Architect of the Week by the OTN in 2004, and has received Ken Jacobs Award in 2017. 

 

Prior to Joining Google, he worked as a Principal Solution Architect at Oracle Corporation as a trusted advisor helping state and local government developed and implemented compelling technical and functional strategies through complex sales cycles and delivering them to CXOs for Corporate and Public-Sector customers.

 

Presentation Slides: 11-2_Google Data Analytics Solutions Overview (Daniel Liu).pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_11-4

 

Oracle Operator Access Control (OpCtl) is the result of Oracle working closely with her largest and most security minded banks, defense contractors, and energy utilities to figure out how to deliver a cloud that customers can control and manage to meet nearly arbitrary security control requirements. If you are in the business of making sure systems are operated to strict governance standards, come learn about how to understand and apply the advanced preventive, detective, and responsive controls you get with OpCtl and Exadata Cloud@Customer.

 

Leader, architect, engineer, scientist, musician, athlete, parent, child, teacher, student, story-teller. My passions include developing and pushing products, people, and organizations beyond their limits to expand opportunities and drive growth. My formal job title is product manager for a database product, and my background includes security, networking, automation, data analysis, software development, electronics, lasers, optics, machine control, and manufacturing. I cherish opportunities to learn and grow through studying and experience, and I love to have quick chats to consider opportunities, technical, business, and otherwise. Presently, I'm focused on cybersecurity in cloud systems for financial services and mission-critical infrastructure for Oracle. Send me a note with your idea - we'll learn something together.

 

Presentation Slides: 11-4_Oracle Operator Access Control for ExaC_C_ Oracles Next Step at Cloud Security for Financial Services and Mission-critical.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_12-1

 

What do Freddy Krueger, Chucky, and bad DB design have in common? They all can keep you up at night!

 

Designing is one of the most crucial stages of the software development process and a good DB architecture is one of the keys to good quality systems. Unfortunately, bad decisions made at the database design stage can have a very negative impact on the performance and management of the system and in extreme cases itís a real horror to handle. These errors are enormously costly -- fixing is very time-consuming and often requires refactoring and redesigning a large part of the system. The good news is that with some planning and thinking, these real horror cases can be avoided and a good design can be a solid base for our software.

 

In this session, we will investigate some of these extreme cases and their impact on the system, and hopefully, just like most horror movies, weíll manage to beat the monsters.

 

Liron is an Oracle ACE Director and a senior Oracle DBA consultant, with more than 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

 

Monika Lewandowska:

 

Oracle Designer and Developer

 

- database design and development

- database optimization: plsql, sql

- Best Practices implementation, code quality audit

- database versioning

- implementation of unit tests in the software development process

 

Certificates

- OCA

- ITIL

 

how2ora-en.blogspot.com

 

Presentation Slides: 12-1_The Blair Witch (DB) Project.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_12-2

 

The cloud is changing many things. Even the decision to not (yet) adopt cloud is one to make explicitly. Now is a time for any organization to reconsider the IT landscape. For each system we should make a conscious ruling on its roadmap. The 6R model suggests six ways to move a system forward.

 

 This session uses the 6R model and applies it specifically to Oracle technology based systems: what are the options and considerations for Oracle Database, Oracle Fusion Middleware, custom applications, and other red components? What future should we consider and how do we choose? The paths chosen by several Oracle-heavy users is presented to illustrate these options and the decision making process. Oracle Cloud Infrastructure and Autonomous Database play a role, as do Azure IaaS and Azure Managed Database as well as on premises systems. Latency, recovery, scalability, licenses, automation, lock-in, skills, and resources all make their appearance.

 

Lucas Jellema is solution architect and CTO at AMIS and member of the Conclusion Architecture Board, The Netherlands. The running theme through most of his activities is transfer of knowledge and enthusiasm (and live demos). Lucas is JavaOne 2015 Rockstar, Oracle Groundbreaker Ambassador and ACE Director and a frequent speaker at conferences such as Oracle Code, Oracle OpenWorld, CodeOne (JavaOne), Devoxx and on Groundbreaker tours. He publishes techy stuff at Github, Medium, Slideshare, DZone, OTN, and the AMIS Technology Blog (https://technology.amis.nl). He is the author of two books with O’Reilly Press.

 

Presentation Slides: 12-2_6Reinventing Oracle Systems in a Cloudy World-LucasJellema.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_12-3

 

Ansible is one of the most powerful DevOps tools, In this session learn to automate the daily DBA tasks using Ansible such as patching, upgrading, etc., in this session you will learn about the basics of Ansible and how to use it to automate tasks and make your life easier.

 

Osama Mustafa is Founder of Gurus Solutions, Oracle ACE Director, Creator/Director of Jordan Amman Oracle User Group (the first group in Jordan related to Oracle technology), and author of the book Oracle Penetration Testing. Osama has been working on project and customer support in the EMEA region and providing database implementation solutions. His specialties are Fusion Middleware, in-memory database, TimesTen, Exalytics, and Exalogic machine. He is a frequent speaker in Oracle user groups around the world and one of the RAC Attack event organizers and Fusion Middleware Attack organizers. Osama has published articles in Oracle Magazine, OTech Magazine, and UKOUG's Oracle Scene Magazine, and he is a blogger and Certified in Oracle Database and Fusion Middleware. He shares his knowledge through conferences, webinars, white papers, slide share, and blog posts to the Oracle community. Simply put, he is Oracle-passionate.

 

Presentation Slides: 12-3_Automate Database Using Ansible.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_12-4

 

You’re taking an important step to protect your business. We are excited to offer you an educational session around the various licensing rules and tips across the key areas of compliance that customers face with Oracle programs: Contracts, Database & Oracle Middleware.

 

Having spent over 30 years in the Oracle ecosystem, Paul Buckley, aka Buckers, is a Subject Matter Expert (SME) on everything Oracle licensing. From contracts, Oracle Technology through Oracle Applications, on-premises or in the Cloud, Paul runs the Software License Solutions (SLS) teams for premier Oracle services provider, Data Intensity.

 

Presentation Slides: No Presentation Slides

Presentation Recording: No Presentation Recording Due to Technical Difficulties

 

Session_12-5

 

Oracle Analytics Cloud (OAC) is a managed service that includes self-service visualization, data preparation, and enterprise reporting. Although generally capable of meeting most customers' needs, it does have limitations when compared to Oracle Analytics Server (OAS), the version of the product installed and managed by customers.

 

In this session, we'll deliver OAS as a managed service using Container Engine for Kubernetes (OKE) in the Oracle Cloud. We'll consider use cases where a Kubernetes deployment improves upon the capabilities of OAC, including developer sandboxing, continuous delivery, and elastic scalability.

 

Stewart is Chief Customer Officer at Qualytics, and the Founder and former CEO of Red Pill Analytics. He is an internationally recognized writer, speaker, and podcast guest in the data and analytics community and holds numerous community advocacy titles including Snowflake Data Superhero, Oracle Groundbreaker Ambassador, and Oracle ACE Director.

 

Presentation Slides: 12-5_Deploy OAS as a Managed Service on Container Engine for Kubernetes - Qualytics.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_12-6

 

Are you looking for a HUB kind of model for Oracle GoldenGate (OGG)? If so, which replication architecture should be chosen? Classic/Traditional Architecture or Microservices Architecture (MA)?

 

Join this session to know more about this. OGG MA is mainly designed for the HUB model. This session explains about the new Microservices Architecture and the differences between the traditional and MA. The benefits of OGG MA over Traditional will be explained as well. How Microservices simplifies your OGG HUB will be explained, and also a demo will be shown. We will discuss on how to implement this OGG MA as HUB in cloud or on-premise or in Hybrid environments.

 

Veeratteshwaran Sridhar, with 12+ Years of experience in Oracle and other RDBMS technologies, specializes in Oracle GoldenGate and Oracle cloud. Veera has vast experience in cloud, database migrations and in architecting solutions for many heterogeneous replications. He is an Oracle Certified Professional and Oracle GoldenGate Certified Implementation Specialist. He is a regular speaker in SANGAM, OGYatra, AIOUG Tech Days and AIOUG Local Chapters. Veera is one of the co-founders of AIOUG Chennai Chapter. He currently leads the AIOUG Chennai and Bengaluru chapters. He actively contributes to the Oracle Community forums under the profile name "ORASCN". Veera was awarded "Outstanding Volunteer" by AIOUG for three consecutive years towards his contributions for the Oracle community in India. He also shares his knowledge and experiences through his blog "www.oracle-scn.com."

 

Presentation Slides: 12-6_Oracle GoldenGate Microservices - Centralized HUB.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_13-1

 

Discover the impact to your business with Release 22 innovations and new features. Take advantage of the latest JD Edwards EnterpriseOne has to offer by leveraging Oracle’s continued investment with on-going updates and innovation to the platform’s tools, features, and application enhancements.

 

Objectives:

 

    Explore system automation features

    Review user experience enhancements

    New digital transformation functionality

 

Allen is a proven leader with over 25 years of successful system implementation experience for both on-premises and cloud solutions. He is a widely recognized industry expert for Oracle software solutions, specifically JD Edwards EnterpriseOne. In addition, Allen is a published author having written four books on EnterpriseOne software implementations. As an active member of the Oracle community, Allen engages regularly with the Oracle product strategy team and is a frequent speaker at Enterprise Resource Planning (ERP) user group conferences.

 

Presentation Slides: No Presentation Slides 

Presentation Recording: No Presentation Recording Due To Technical Difficulties

 

Session_13-2

 

One of the most essential and frequently underutilized database features is that of the Oracle Database Scheduler. Oracle Database includes Oracle Scheduler, an enterprise job scheduler to help you simplify the scheduling of hundreds or even thousands of tasks. This session shows how this Scheduler compares with other scheduling systems, including the Oracle Enterprise Manager Cloud Control job system. First, this session briefly covers the basic features of the Scheduler that are largely self-evident. Then, it demonstrates how to use Oracle Schedule to create email notifications, create file watchers that are especially useful in a data warehouse environment, and create and manage remote databases and multiple destination jobs.

 

Oracle Professional DBA with 19 years' experience managing complex UNIX-based Oracle Databases. Experienced in a wide range of mission-critical technologies, specializing in database administration best practices for High Availability and Performance Tuning (Query, Database) and Oracle Troubleshooting. Possess hands-on experience with real-world Production environments and has risen from Oracle Developer to managing DBA.

 

Presentation Slides: 13-2_Oracle Scheduler - Technical Deep Dive (30 minute Quick Tip).pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_13-3

 

Zero Data Loss Recovery Appliance (ZDLRA) is an Engineered System and part of the Maximum Availability Architecture (MAA) family, too. But do you know that is the only product listed to be used in all MAA architectures, from Bronze to Platinum? And do you know why?

 

This session focuses on the MAA architecture references, and on an understanding of why Recovery Time Objective (RTO) and Recovery Point  Objective (RPO) concepts are so important. It explains why (and how) you, with a single ZDLRA, bring down RPO to zero for all of your databases. This session is not about ZDLRA features, but why you need to look at ZDLRA beyond just a fast backup perspective.

 

I am not an Oracle employee, so, do not expect a marketing presentation. I will show you how to integrate ZDLRA and why you need to consider it for your next MAA architecture design.

 

I am Senior Database Architect with experience with Oracle Database, working since 2010 with Exadata and since 2014 with ZDLRA to design mission-critical and high availability environments with MAA using RAC, Data Guard, HA, and/for multi-site protection. But also experience with fieldwork activities like resource manager, impact estimation, upgrade, patch deploy, and patch apply. Worked to design and implement the first ZDLRA in Brazil, and one of the first of replicated ZDLRA project of the world (2015). The same for Exadata V2 (2010) in Brazil. Oracle ACE, LUXOUG Board member, and speaker in several Oracle Conferences (OOW), and usergroups conferences as well.

 

Presentation Slides: 13-3_There Is No MAA Without ZDLRA.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_13-4

 

Are you in an environment that has more than ten databases with multiple environments and technologies? If not, youíre lucky.

 

However, this session can help you along as DBA of many and multiple databases and environments. This presentation will attempt to gap the usage of Oracleís free tool -- APEX -- with normal database operations to organize and gather information from your database and identify performance, backup, and utilization patterns. This wonít replace Oracleís OEM and AWR warehouse but act as a first step to understand where to look in the OEM or other 3rd party tools.

 

This APEX application can be used by DBAs or managers who want to understand the database resources that are currently used (total CPU, memory, etc.). Plus, it has multi-tier and department usage and can be set up by any level DBA.

 

Mike Gangler is a senior database specialist and architect. He’s also an Oracle ACE with expertise in database reliability and architecture and a strong background in operations, DevOps, consulting, and data analysis.

 

Presentation Slides: 13-4_Managing Database Applications With APEX.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.


Session_13-5

 

Database schemas and application code are tightly coupled but often maintained and deployed separately.

 

The open-source project Liquibase helps you manage schema changes by writing simple JSON or YAML documents. Liquibase makes it easy to deploy to different flavors of databases and roll changes back and forward.

 

Ansible is an open-source automation tool that enables you to define and run tasks on a set of remote targets. Like Liquibase change logs, Ansible playbooks are JSON or YAML documents.

 

Both tools together enable you to effectively version control your database schema changes and deploy them to multiple hosts simultaneously.

 

Agile and DevOps work hand in hand. This talk introduces Liquibase and Ansible and demonstrates how to use them together. This presentation includes live demos. All sources and examples will be available for download.

 

Robert Marz is an Oracle ACE and Independent Consultant.

 

At customer sites, he works as a Senior Technical Architect with a database-centric view of the world.

 

Robert is Co-Founder and Co-Owner of Databee - The IT-Architects, a Germany based professional services company.

 

At DOAG (the German Oracle user group), he is in charge of the Cloud topics inside the database community. Robert is a member of ODTUG, IOUG, DOAG and RMOUG.

 

More than twenty-five years of experience in custom development and data warehouse projects makes him a specialist in Oracle database development and administration.

 

Additionally, he is skilled in the fields of automation, scripting languages, virtualization and cloud technologies.

 

Robert Marz publishes articles and papers in various publications and frequently speaks at German and international conferences.

 

Robert.Marz@databee.org

@RobbieDatabee

https://robbie.databee.org

 

Presentation Slides: 13-5_Automatically Deploy Schema Changes With Ansible and Liquibase.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_13-6

 

Oracle Data Pump is widely used by DBAs to move tables, schemas, and even entire databases from one Oracle Database to snother. But, even if you are familiar with Data Pump, we will bet that there are some features that you might not be be using to their fullest potential.

 

This session will cover some of the lesser known, "unsung" features of data pump that will help you unlock the power of this versatile utility. Some of the features we will discuss and demonstrate are:

 

  - the TRACE parameter and its use in debugging issues.

  - the interactive command line interface.

  - the DBMS_DATAPUMP API.

  - important and helpful patches for Data Pump on Oracle Database 19c.

 

Whether you are a casual user or a power user of Data Pump, you're sure to learn something that will come in handy in your export or import scenarios.

 

Bill Beauregard is a Senior Principal Product Manager in the Oracle Upgrades, Migrations and Patching group. Bill is responsible for Oracle Database Utilities product management, and release management for Upgrades, Migrations and Patching. He presents at Oracle User Group events and works with Oracle customers in collaboration with Oracle Presales and Oracle Support. Find more information at https://www.oracle.com/database/technologies/upgrades.html.

 

Presentation Slides: 13-6_The Unsung, Perhaps Unexplored Features of Oracle Data Pump.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_14-1

 

Join Oracle Product Management in a session that will take you through the latest features of Database In-Memory. This session will provide a quick review of Database In-Memory, and then will focus on the new features introduced in Oracle Database 19c and 21c. Oracle Database In-Memory is targeted specifically at speeding up analytic queries by orders of magnitude over traditional row-based queries. However, it can be hard to appreciate all of the features that Database In-Memory uses to make this happen. This session will also cover how other Oracle Database features add to the performance of Database In-Memory.

 

Andy Rivenes is a Product Manager at Oracle for Database In-Memory. Prior to that Andy was a Product Manager for Heat Map, Automatic Data Optimization, SecureFiles and DBFS. Andy has spent a large part of his career managing Oracle databases and he now spends his time helping customers implement Database In-Memory as well as providing information about Database In-Memory through blogs, conferences, and customer visits. You can visit the Database In-Memory blog at https://blogs.oracle.com/in-memory or follow his tweets as @TheInMemoryGuy.

 

Presentation Slides: 14-1_New Features in Oracle Database In-Memory.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_14-2

 

Starting with 12c Release 1, Oracle introduced a completely new architecture concept for its database - the Container Database. With this new architecture, new challenges came up, but with the same breath a wide branch of new opportunities.

 

The presentation will address the capabilities to create fast and easy new (test) databases or clones for a running production database. Five different ways will be discussed:

 

 - Using Local and Remote Cloning

 - Using an Unplugged PDB (predefined master)

 - Using Refreshable PDBs as a master for new (test) databases

 - Using Data Guard for a limited number of PDBs and its Snapshot Standby capabilities

 - Snapshot Carousel

 

Another point on the agenda is the usage of the Snapshot features of ACFS and Direct NFS to speed up the creation process. At the end of the presentation, a comparison of the advantages and disadvantages of each technique will be presented.

 

Christian Gohmann is currently working as Principal Consultant and Instructor at Trivadis Germany GmbH in Dusseldorf, Germany. His main focus lies in helping customers in the areas of architecture planning, implementation, and migration - with a specialization on high availability solutions, like Data Guard, Oracle RAC.

 

Since 2006, Christian Gohmann is working with Oracle and the Oracle Database and was part of a huge amount of different projects for customers in the German-speaking areas.

 

Besides his consultancy activities, he is the main developer and the responsible person for TVD-Backup - a product distributed by Trivadis, which is responsible for the intelligent backup and recovery of an Oracle database.

 

In his spare time, he shares his knowledge on his blog https://www.christian-gohmann.de.

 

Presentation Slides: 14-2_ One PDB to go, please!.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_14-3

 

Dialogflow is a natural language understanding platform that makes it easy to design and integrate a conversational user interface into your mobile app, web application, device, bot, etc. Dialogflow can analyze multiple types of input from your customers, including text or audio inputs (like from a phone or voice recording). It can also respond to your customers either through text or with synthetic speech.

 

 In this workshop, you will learn to build a Google Assistant chatbot that submits help desk tickets. The hands-on lab will walk you through the following steps:

 -       Set up your lab and learn how to work with Dialogflow and your Google Cloud environment.

 -       Deploy a simple Dialogflow application.

 -       Deploy a simple cloud function within Google Cloud to connect with Dialogflow.

 -       Test your chatbot.

 

Daniel Liu is a Customer Engineer at Google for Public Sector State and Local Accounts and co-author of Oracle Database New Features - by Rampant TechPress.

 

A recognized database expert and a frequent speaker at various IT conferences, Daniel has published articles with DBAzine, Oracle Internals, Oracle Technology Network, and SELECT Journal. Daniel has received SELECT Editorial Award for Best Article in 2001,  he has been named Architect of the Week by the OTN in 2004, and has received Ken Jacobs Award in 2017. 

 

Prior to Joining Google, he worked as a Principal Solution Architect at Oracle Corporation as a trusted advisor helping state and local government developed and implemented compelling technical and functional strategies through complex sales cycles and delivering them to CXOs for Corporate and Public-Sector customers.

 

Presentation Slides: 14-3_Implementing an AI Chatbot With Dialogflow .pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_14-4

 

SAML 2.0 is the gold standard for authentication; it allows organizations to leverage enterprise identity providers like Active Directory and ADFS to authenticate, provision users, and adopt Single Sign-on in ERP. However, SAML is somewhat complex to implement.

 

To overcome these limitations, Appsian Security, an Oracle-certified partner, offers a simple SAML solution that natively integrates with Oracle EBS – as a plugin/extension with no alteration to existing EBS functionalities, no maintenance, or additional product licenses. As a result, EBS customers can leverage SAML benefits and seamlessly integrate across SSO solutions like Okta, Azure/ADFS, and more.

 

 

Mr. Wendt is one of the top ERP security experts with knowledge across multiple ERP platforms. During his 22-year career, he has been recognized as a leader in data security, application architecture and business operations.

 

Presentation Slides: No Presentation Slides 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_14-5

 

Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. Suddenly, seemingly secondary decisions made at very early stages of system development become make-or-break factors years later.

 

 This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective. Topics include repository-based solutions, code generators, abstract models, micro-SOA, etc. This presentation will also describe real-world examples of how to handle unexpected architectural shifts based on systems with life spans of more than 10 years.

 

Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006), PL/SQL Performance Tuning Tips & Techniques (Oracle Press, 2014), contributing author of Expert PL/SQL Practices (APress, 2011), and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal) and conference papers. Michael is an Oracle ACE, a frequent presenter at various Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award.

 

Presentation Slides: 14-5_Managing the Earthquake_Surviving Major Database Architecture Changes.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_14-6

 

Oracle Databases On-Prem to Cloud migrations -- OCI, AWS, & Azure -- is one better than the other? Is one easier than the other? Based on which cloud provider our company picks, we must go with the flow and set up Oracle on the provider of choice.

 

This presentation will explore ways to set up and migrate the Oracle database from on-prem to the cloud (OCI, AWS, & Azure). Cost, performance, and ease of setup and migration will be illustrated for all three providers. A special highlight will be on the performance of Oracle on the different providers. Some key features that we can leverage for each provider to ensure optimal performance will be illustrated. Common migration issues along with post-migration performance issues will be explained.

 

Manager Database Engineering and application support with over 20+ yrs of experience. Design, install, configure and deliver enterprise database solutions end to end. Expertise in Real Application Clustering, Oracle 7x--12c, SQL Server, My SQL, Postgres. Critical analysis and quick problem resolution is one of my key expertise which helps resolve issues in a timely fashion and optimize solutions for the company. Highly motivated, self starter.

 

Recent emphasis on all things cloud.

 

Certified Oracle Cloud Architect Professional. Masters in Cloud Computing Architecture from Univ of Maryland

 

Presentation Slides: 14-6_Cloud Migration -- Oracle on OCI, AWS, _ Azure - Migration and Performance.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_15-1


Database systems running on modern hardware are no longer constrained by I/O or memory shortage as both of these historic performance bottlenecks have been addressed by hardware technology advancements. The biggest constraint to system performance can now be found in a little-noticed space: the single thread CPU Speed. CPU speed is often overlooked when considering Cloud infrastructure providers, and it can be the difference between a successful "lift and shift" or a migration that moves the company backward from a user experience with system performance.

 

We will show a performance comparison of different cloud and on-premises systems, such as OCI, AWS, or Oracle Exadata, and demonstrate the differences running Oracle EBS SQL queries on them.

 

 Objectives:

 - Learn about the impact of single thread CPU speed on database query performance.

 - Learn how to audit database performance and gather the metrics that pinpoint the problems.

 - Introduce attendees to a public domain SQL library that can help to analyze Oracle EBS performance.

 

 Attendees will gain personal and professional growth by learning about performance monitoring, and will get access to a library of SQL scripts that can help their business users work more efficiently with EBS on a day-to-day basis.

 

Andy is an E-Business Suite specialist with two decades of experience working on EBS implementation projects across various industries. During his consulting career, he covered various functional and technical roles and soon discovered his passion for lean and efficient technical designs.

 

 

 As a specialist for performance tuning and database optimization, a big part of Andy’s job included writing SQLs for custom data extracts from the Oracle EBS. The lack of efficient and flexible reporting solutions inspired him to found Enginatics and to build the Blitz Report, the world's fastest reporting solution for Oracle E-Business Suite.

 

Andy now works as Managing Director of Enginatics and helps EBS clients to achieve maximum performance from their systems. 

  

Presentation Slides: 15-1_Running EBS on Cloud - Beware of This Overlooked Performance Metric.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_15-2

 

In this session learn what histograms are and how they can be useful to you. Topics covered for Oracle Database 11g histograms include frequency histograms and height-balanced histograms. Topics covered for Oracle Database 12c Histograms include challenges with Oracle Database 11g histograms, top frequency histograms, and hybrid histograms. The session also covers Oracle Database 18c/19c/21c histograms

 

Anuj is an Oracle ACE and frequent speaker to various Oracle conferences like Oracle Open World, collaborate, Great Lakes ,East Coast and local user groups. He is also a regular speaker at Northern Kentucky University (NKU). He is founder of Oracle 12c SIG (IOUG). He has over 20 years of experience as Oracle DBA He is Oracle certified Exadata implementation expert. He is Oracle certified professional (OCP) for Oracle 11g and 12c and Certified in Oracle and AWS Cloud.

 

Presentation Slides: 15-2_Histograms (In Oracle Database 11g to Oracle Database 21c) Could Be Your Friend.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_15-3

 

With the ever-increasing volume, velocity, and variety of data generated with enterprise applications, it's more important than ever for organizations to discover the critical hidden insights contained in their enterprise data and to leverage these insights in enterprise applications. Applying machine learning and advanced analytics with these enterprise data provides in-depth understanding of many essential aspects of business such as financials and supply chain forecasting, patterns in customer behavior, etc.

 

 This session will discuss a method of applying machine learning on enterprise data: in-database machine learning, which can train, evaluate, and deploy models natively on large data sets. We will discuss how the in-database machine learning method provides scalability, simplicity, and high performance. We will also discuss how Oracle in-database machine learning is provided in the Oracle Database kernel as well as in the Oracle Autonomous Database environment.

 

 In addition, we will discuss the process of machine learning: analyze and prepare the data set, build and evaluate, and apply the machine learning model. We also will discuss the Oracle machine learning features in Oracle 21c such as AutoML for In-Database Machine Learning and newly added in-database machine learning algorithms for anomaly detection, regression, and deep learning analysis.

 

Kai Yu is a Distinguished Engineer in Dell EMC Solutions Engineering and a member of Dell Technical Leadership Community. Kai has 26 years’ experience of architecting and implementing various IT solutions by specializing in Oracle RAC database, Oracle BI and Oracle EBS, Virtualization/Cloud. Kai has been a frequent speaker at various IT/Oracle conferences with over 190 presentations in more than 20 countries. He also authored 35 articles in technical journals such as IEEE Transactions on Big Data, IOUG Select and Dell Power Solutions and co-authored Apress book “Expert Oracle RAC12c”. Kai has taken some leadership positions in IOUG such as IOUG conference committee member, IOUG RAC SIG president and IOUG Cloud SIG co-founder and the current vice president. Kai has been an Oracle ACE Director since 2010 and was featured as Oracle ACE Spotlight by OTN. He also received the 2011 OAUG Innovator of Year award the 2012 Oracle Excellence Award: Technologist of the Year: Cloud Architect by Oracle Magazine. Kai has shared all his technical articles and conference presentations on his Oracle blog: https://kyuoracleblog.wordpress.com/

 

Presentation Slides: 15-3_Oracle In-Database Machine Learning With Enterprise Data and Enterprise Applications.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_15-4

 

Learn the subtle and not-so-subtle distinctions between APEX modals, popups, and inline dialogs: Which to use when, why to choose one over the other, and how to use them appropriately in your APEX applications.  We will cover modal and non-modal dialog pages, inline dialog, and inline popup region types; when to use a dialog page vs. an inline dialog or popup; and caveats and challenges to be aware of with each element type. Emphasis is on use of declarative APEX elements and documented JavaScript APIs whenever possible. Learn best practices for employing these various elements in your APEX pages, including specifics for launching from interactive grids. Attend and gain confidence in your use of modals, popups and dialogs in your APEX applications.

 

Karen Cannell is President of TH Technology, a consulting firm providing Oracle technology services. A mechanical engineer by degree (one of them), she has analyzed, designed, developed, converted, upgraded, enhanced, and otherwise implemented legacy and commercial database applications for over 30 years, concentrating on Oracle technologies since 1994. She has worked with APEX since its beginnings and continues to leverage Oracle tools for clients in government, medical, and engineering industries. Karen is an ACE Director, ODTUG Vice President, frequent conference presenter and avid user group advocate. Karen can be reached at kcannell@thtechnology.com and @thtechnology on Twitter

 

Presentation Slides: 15-4_Modals and Popups and Dialogs, Oh My! Which to Use When, How and Why.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_16-1

 

Oracle Autonomous Database (ADB) is user-friendly, fully autonomous, and delivers many benefits to your on-premises Oracle environment, but getting started can be a challenge for organizations.

 

 Oracle ADB handles tasks such as database provisioning, backups, patches, upgrades, workload tuning, failure detection and repair, data protection, and scaling. Everything happens automatically, so your database administrators and other database specialists can focus on other aspects of your business.

 

 Planning and executing a cloud migration to ADB involves many steps. A comprehensive Oracle database migration plan positions your project for a successful deployment, as youíve considered all important factors long before any data moves. If your organization is looking to migrate to Oracle Cloud Infrastructure (OCI) and move their instances to Oracle ADB, this presentation will be of interest. Topics covered:

 

         Oracle Autonomous Database overview & benefits.

         Important Oracle Cloud concepts to know for Oracle ADB.

         Developing your on-premises Oracle to Oracle ADB migration.

         How to migrate to Oracle ADB.

         Estimating Oracle ADB migration pricing.

         What your database administrators (DBAs) are responsible for after a migration to Oracle ADB.

 

Brandon Webb is an internationally ranked team player: determined to become a multi-talented No-SQL and Relational Database Administrator & Application Architect, through understanding data and the systems it moves through from the source systems to the key business leaders. A visionary, driven by business intelligence/analytics to improve businesses processes and increase productivity. An innovator and forward thinker always on the move! He has energy like none other

 

Presentation Slides: 16-1_Making the Move to Oracle Autonomous Database FINAL RMOUG.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_16-2

 

When a critical production database can't service to a majority of its users, we can call this a "crisis." These problems can show up in different forms like data corruptions, data loss arising from user fault, after change issues (upgrade, patch, migration, etc.), hardware problems, load issues, and more. It's crucial to follow the right direction for the solution when "downtime" starts ticking. While supporting big customer systems for almost 10 years in Oracle ACS, I experienced these "crisis" situations first hand, and I prepared this presentation for Oracle DBAs to get ready for these unwanted but possible cases. I will start with general Crisis Management rules and cover a range of scenarios like RMAN restore/recovery, Data Guard failovers, Flashback features, database upgrades/migrations with spot-on hints, and real-life lessons learned.

 

- Working for Oracle ACS, Mission Critical Support services (Database & Exadata) - Oracle ACE Alumni - Author of "Oracle Data Guard 11gR2 Administration" book, published by Packt - Contributed to "Oracle Database 12c Oracle RMAN Backup and Recovery" and "Oracle RMAN 11g Backup & Recovery" books, published by Oracle Press - Founding member of TROUG (Turkish Oracle User Group) - Presented at Oracle Open World and at User Group conferences across globe - Highly experienced on Oracle database administration, high availability & disaster recovery solutions, Exadata Database Machine, database performance tuning and security.

 

Presentation Slides: 16-2_Crisis Survival Guide of Oracle DBA.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_16-3

 

Have you ever found yourself staring at a list of patches and wondering what to do? What patch should I install? What are the risks? Is there anything I should do after the patch? This becomes even more stressful in a complex environment: how to install patches on RAC. What about standby databases?

 

This session will try to put things in order and help create a roadmap for patching databases. We will discuss the different types of patches (RU, RUR, DBBP, PSU, OJVM, One-off), installation types (RAC rolling patches, standby first patches), known issues and where to find them, and how to plan the patch installation in order to have as few surprises as possible.

 

"Liron is an Oracle ACE Director and a senior Oracle DBA consultant, with more than 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"

 

Presentation Slides: 16-3_Creating Order in the Database Patching Chaos.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_16-4

 

The death of Oracle Forms has been greatly exaggerated. Despite two decades of development, Forms is still the backbone of thousands of mission-critical applications worldwide. But where do our tried and true Forms stand while all systems are undergoing a user experience revolution or moving to the cloud? In this session, we will show how Oracle Forms is now a full member of Oracleís cloud, mobile, and even Chat ecosystem. We will review the 4 ways that you can extend your existing Forms investments to the cloud, including:

 

 1. “Lift-and-Shift” your Forms servers to Cloud Servers - OCI.

 2. Extending your applications using Oracleís rapid development tool Visual Builder Cloud Service (VBCS).

 3. Leveraging existing business logic through Chat interfaces using Digital Assistant cloud service.

 4. Doing DevOps using Developer Cloud Service.

 

The answer to how to bring your Forms into the next generation will be revealed during this session. Along with live demos and Q&A.

 

Mia Urman is an Oracle ACE Director and world-class expert in Oracle Forms, Oracle Mobile with over four years of experience presenting, supporting, training, and consulting Oracle products. In her seven years at Oracle, Mia was both a Senior Support Analyst and Product Manager of Oracle Developer Suite, JDeveloper, and IAS technologies. While providing consulting, architecture design, and project development services to customers, Mia became intimately familiar with some of the leading challenges facing Oracle Forms/ERP clients and co-founded AuraPlayer (formerly OraPlayer), a development house providing modernization solutions for Oracle Forms to mobile/cloud/web services. AuraPlayer creates web services from Oracle Forms business logic that can be exposed and run from mobile, cloud computing, or SOA systems. She currently serves as AuraPlayer's CEO.

 

Mia is a seasoned presenter on Oracle technologies and has presented at various conferences including Oracle OpenWorld, ODTUG Kscope, UKOUG, and IOUG Collaborate. She is also a former member of the ODTUG Board of Directors.

 

Presentation Slides: No Presentation Slides

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_17-1

 

As AWS became a viable cloud service provider with wide adoption, Amazon introduced back in 2015 the "AWS Well-Architected Framework" which provides architectural best practices across five pillars. Similarly, Oracle Cloud Infrastructure (OCI) introduced their own "OCI Best Practices Framework." This framework covers best practices for four "business goals" that include: security and compliance, reliability and resiliency, performance and cost optimization, and operational efficiency.

 

Learning about and adopting these recommended best practices help you design and operate cloud topologies that deliver maximum business value.

 

These best practices are the result of years of experience with thousands of cloud customers creating architectures that are meant to be secure, highly performant, resilient, and efficient. While not overly complex this framework can be intimidating for those newly embarking on their cloud journey; this presentation introduces the framework, walks through the business goals, and highlights some of the elements and strategies to give you a stronger idea of how this framework can benefit you.

 

Ahmed Aboulnaga is a Senior Principal at Maximus. Ahmed's professional focus is in technical management, architecture, and consulting within Oracle, Java, and cloud technologies, having implemented enterprise solutions for commercial, government, and global customers throughout his 20 year career. Ahmed is an Oracle ACE, has written two books on Oracle SOA, and currently helps organize IaaS and PaaS meetups for NATCAP-OUG and Quest. Prior to joining Maximus, Ahmed has worked for leading consulting firms that include Oracle, IBM, Booz Allen Hamilton, and CSC. Born in Washington DC, Ahmed holds a master's degree in Computer Science from George Mason University.

 

Presentation Slides: 17-1_Introducing the Oracle Cloud Infrastructure (OCI) Best Practices Framework.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_17-2

 

Enterprises are moving all applications to the cloud; the last to move to the cloud are applications with an Oracle database in the backend. Oracle databases must inevitably move to the cloud. To be successful, you must have cloud knowledge in addition to the DBA skills, and some DBA tasks are not relevant in the cloud. What skills do you need to be a successful Oracle DBA to support Oracle database in the cloud (OCI/AWS/Azure)? What certifications should you aim for? Where do you get the training?

 

Biju Thomas, Oracle ACE Director, is the Global Oracle Practice Lead at Data Intensity. Biju has been developing and administering Oracle databases since 1993 and Oracle EBS since 2006. He is a frequent presenter at Oracle conferences. He has authored Oracle certification books published by Sybex. Biju blogs at http://www.bijoos.com/oraclenotes and you can follow him on Twitter (@biju_thomas) or Facebook (@oraclenotes). Check out his weekday Oracle Tidbits (#OraTidbit).

 

Presentation Slides: 17-2_Take your Oracle DBA Career to the Cloud.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_17-3

 

This practical session covers performance, scalability and high availability features usable with the node-oracledb interface for Oracle Database.  Message queueing and data-driven notifications will also be discussed. Node.js and TypeScript users will see how these and other high availability features such as Application Continuity can be used to build resilient applications.

 

Christopher is a Senior Principal Product Manager working with the Oracle Database Data Access team primarily on APIs for scripting languages including Node.js, Python, Go, PHP and the ODPI-C library for Oracle Database driver writers. He has responsibilities for Oracle Call Interface (OCI) and related Oracle Database APIs; for Oracle Database clients such as Oracle Instant Client; and for general database adoption by developers. He co-released the popular book "The Underground PHP and Oracle Manual" and is the author of a number of technical articles. Christopher has presented at big and small conferences around the world including the O'Reilly Open Source Convention and Oracle OpenWorld. He tweets at @ghrd and blogs at https://blogs.oracle.com/opal/.

 

Presentation Slides: 17-3_Build High Performance Applications in Node.js for Oracle Database.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_17-4

 

Have you had that one SQL statement that you just couldn't figure out what the Oracle optimizer was thinking? In this session we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL, but we will cover how the optimizer frustrated you so. Using these tools along with Oracleís SQL Plan Management or Profiles you may be able to achieve your goals.

 

 Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.

 

 Learning Objectives:

 1.     What tools are available for deep diving into a SQL statement?

 2.     When would you use each of these tools, and how do you understand the output?

 3.     What are some of the ways to force the Optimizer to behave the way I want it to?

 4.     Reading Trace files.

 

Gary Gordhamer has spent much of his career focusing on enterprise application landscape and business process digitization. His technical experiences range from Oracle e-Business suite, middleware, database and related technologies for the past 27 years. His professional background covers many industries including healthcare, manufacturing, utilities, and government. He is an active member of the QUEST IOUG Database & Technology Community, serving on the advisory board. Gary is an Oracle ACE associate, and frequent presenter at Oracle OpenWorld and COLLABORATE.

 

Presentation Slides: 17-4_Deep Dive into SQL Tuning.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_17-5

 

Join Oracle Database Product Management to find out what's new and exciting in the latest version of the Oracle Database. Imagine being able to leverage the power of blockchain from within a standard database table, or to harness machine learning without requiring the expertise of a data scientist. We will look into how these features and many others can potentially help you and also explore their use with live demonstrations. 

 

In addition to hearing about the many innovations that are available today, we'll be covering the future direction of the database.

 

The session will include several live demonstrations.

 

Sean Stacey is a Director of Product Management in Oracle's Server Technologies organization. Sean joined Oracle in 1997, and during his time with Oracle has focused much of his time supporting Oracle's partner community with programs primarily around the adoption of the Oracle Database. Most recently Sean has been working with Oracle customers and partners to help them move to the Oracle Cloud.

 

Sean's expertise in the Oracle database is both theoretical as well as hands-on. He frequently provides technical advisory services and education to Oracle customers and partners to ensure they are getting the most benefits from their Oracle software investment. In addition to these program activities, he has authored several white papers and frequently presents sessions at Oracle user conferences.

 

Prior to joining Oracle, Sean was a software developer and then Oracle Database administrator in Australia, the United Kingdom as well as the United States. He currently resides in Raleigh, North Carolina.

 

Presentation Slides: 17-5_Oracle Database New Features and Product Roadmap.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_18-1

 

Terraform by HashiCorp is changing the way we build our infrastructure. This presentation will lead you through understanding, installing, and using Terraform to be able to build your IaC (Infrastructure as Code) and have an inhabitable area for your code to live freely and interact with available resources.

 

Brandon Webb is an internationally ranked team player: determined to become a multi-talented No-SQL and Relational Database Administrator & Application Architect, through understanding data and the systems it moves through from the source systems to the key business leaders. A visionary, driven by business intelligence/analytics to improve businesses processes and increase productivity. An innovator and forward thinker always on the move! He has energy like none other

 

Presentation Slides: 18-1_Terraform_Objects Will Become People.pdf 

Presentation Recordings: Session recordings are available now in our Members-Only section of this website.

 

Session_18-2

 

Ever wonder how your bank knows when to text you when a potentially fraudulent transaction appears on its radar? Itís simple if you know how to apply the right algorithms to financial transactions so that outliers become readily apparent. These techniques can be applied to just about any anomalous behavior, and property graph technology helps make outliers stand out dramatically.

 

 Through presentations and online demonstrations, this session will:

 - Show how to use appropriate ML algorithms already built into Oracle Database to uncover anomalous patterns.

 - Demonstrate Oracle Graph Studioís capabilities to identify and display outliers more clearly.

 - Introduce the basic concepts of PGQL (Property Graph Query Language) to look at tabular data in completely new ways.

 

Jim Czuprynski has over forty years of professional experience in Information Technology, serving diverse roles at various Fortune 1000 companies before becoming an Oracle DBA in 2001. He has been an Oracle ACE Director since 2014 and is a sought-after public speaker on Oracle technology, presenting often at Oracle OpenWorld, Oracle CODE, COLLABORATE, Kscope, Oracle Development Community tours, and Oracle User Group conferences around the world.

 

Jim has authored 100+ articles on Oracle Database administration, ML/analytics, and APEX since 2003 at databasejournal.com, IOUG SELECT, and ODTUG TechCeleration and has co-authored four books on Oracle database technology. Jim’s blog, Generally … It Depends (https://jimthewhyguy.com), contains his regular observations on all things Oracle and the state of the IT industry. Jim also co-hosts the Beyond Tech Skills podcast (https://www.beyondtechskills.com), which discusses everything about tech … except tech.

 

Presentation Slides: 18-2_Grafting Grifters_Identify and Display Patterns of Corruption With Oracle Graph Studio(021022-AGD22).pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_18-3

 

One of the key differentiators Gartner identified in the latest magic quadrant for data integration tools was their ability to support DataOps.

 

DataOps, put simply, is DevOps, or automation, for data integration projects. Typically, this includes automated (regression) testing, CI/CD, version control integration, and integration with automation servers like Jenkins. The goal is to support collaborative and agile working in data integration projects.

 

This presentation outlines what features we think a modern data integration tool should provide to support DataOps. We then go through how each of these features and see how they can be implemented in Oracle Data Integrator (ODI). Implementation could mean how to access the feature out of the box; how to configure ODI and other services to use the feature; or how to extend ODI using Groovy and the SDK to create the feature.

 

The audience will learn the value of DevOps to data integration projects and how to realize this using ODI.

 

Jon Mead is the founder and CEO of Rittman Mead Consulting, a globally renowned data and analytics service provider. Jon has more than 25 years of experience in the industry, with a background as a software engineer, and experience working as a consultant and contractor before setting up Rittman Mead he has witnessed the evolution of the business intelligence and data warehousing industry from its early days to what we know it as now.

 

Presentation Slides: 18-3_Augmenting Oracle Data Integrator for DataOps.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_18-4

 

Version 21c of the Oracle database is the version by which Oracle cuts off old heads and says goodbye to the classic architecture, also known as the non-CDB architecture. Now there are only container databases, and 21c brings with it some new features. New features include better integration into Oracle Cluster, improved isolation of pluggable databases, extended flashback and recovery opportunities.

 

The presentation provides an overview of the new features and shows the current migration methods you can use to migrate to the container database architecture.

 

 The presentation covers new features like:

 1. AutoUpgrade features like Non-CDB to PDB migration and Unplug-Plug-Upgrade.

 2. Pluggable Database Cluster Resources.

 3. PDB Point-in-Time Recovery or Flashback to Any Time in the Recent Past.

 4. Namespace Integration with Database.

 5. MAX_IDLE_BLOCKER_TIME Parameter.

 6. Expanded Syntax for PDB Application Synchronization.

 7. TimeZone Support.

 8. Minimum Password Length for PDBs.

 

Markus Flechtner is a Senior DBA with more than 25 years experience in the field of Oracle databases. He started as a developer (Oracle Forms, Oracle Reports, PL/SQL) in the 1990's. Later he spent some years at Oracle Support (Field Support). After some years as a database administrator at a credit agency with some High Availability databases (Oracle RAC, Oracle DataGuard) he joined Trivadis, a Swiss based consulting company, in 2008. Currently, he's a Principal Consultant at Trivadis in Duesseldorf (Germany).

 

He is specialized on Oracle Real Application Clusters Oracle Multitenant and database upgrade and migration projects. Since 2009 Markus is a teacher at Trivadis. He is a teacher for the following courses Oracle Grid Infrastructure and Real Application Clusters, Oracle Database New Features, Oracle Multitenant and PostgreSQL for Oracle DBAs. Due to this large number of trainings, he is widely known in the German Oracle community.

 

Additionally, to sharing his knowledge and his wide experience in course and in his blogs (markusdba.de and markusdba.net), he is a frequent speaker at national and international conferences like Oracle Open World, IOUG COLLABORATE, UKOUG Tech, nlOUG Tech Experience, and the DOAG annual conferences.

 

Markus is an active member of the database community of the German Oracle User Group (DOAG, Deutsche Oracle Anwendergruppe) and a delegate for the annual DOAG meeting. He is co-author of the (German) book ""Der Oracle DBA"" which was published in 2016. He contributed the chapters ""Multitenant"", ""Globalization Support"" and ""Database Upgrades"" to the book.

 

In 2020 he was nominated an ""Oracle ACE"".

 

Presentation Slides: 18-4_Container only-- New Features for Multitenant in Oracle 21c.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_18-5

 

This practical, demo-rich session highlights the popular and full-featured Python interface for Oracle Database, showing how to create database-backed applications. Learn techniques for efficient data loading and access. Learn best practices for database connection management and performance optimization.  See how features like Application Continuity improve the availability of applications.

 

Sharad Chandran is the Principal Product Manager for the Data Access Group at Oracle. He and his team work on building client-side interfaces and APIs for the Oracle DB in various languages like C/C++, Python, Node.js, etc. Sharad has developed various well-documented features such as pre-compile directives and external library interfaces for Oracle in his earlier capacity as a Senior Programmer. He has published multiple articles that explain how to interface Python frameworks with Oracle Database in his current role. Sharad blogs at http://blogs.oracle.com/opal. His Twitter handle is @SharadChan87.

 

Presentation Slides: 18-5_-Efficient-Data-Handling-Techniques-in-Python-for-Oracle-Database.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_19-1

 

Come test your board game knowledge and learn more about this $8 billion dollar industry!  We’ll have lots of fun with game trivia and you can WIN prizes and your very own Datavailopoly game!   Datavailopoly is a totally custom board game designed by DBAs for DBAs.  Don’t miss this! 

 

Presentation Slides: No Presentation Slides 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_19-2

 

During the night, Back-office systems have to process tons of records and calculate millions of values. Systems usually are very busy during the night. But is the night long enough to do such hard work? The end of day processes in the back-office systems can take several hours. Record holders are approaching even 24 hours!

 

 In this session, I will discuss a successful system re-engineering project that involved gathering information on the current system, analyzing requirements, and transforming them into the system of tomorrow. I will walk through the main process I went through: the requirements, design, and PL/SQL code, as well as the changes that allowed us to shorten the processing time. Not only did we improve a single process, but the entire system processing time was reduced from several hours to several minutes.

 

 Come to this session and find out what were the key factors to achieving success!

 

Oracle Designer and Developer

 

- database design and development

- database optimization: plsql, sql

- Best Practices implementation, code quality audit

- database versioning

- implementation of unit tests in the software development process

 

Certificates

- OCA

- ITIL

 

how2ora-en.blogspot.com

  

Presentation Slides: 19-2_Backoffice System Re-engineering -- Key Success Factors - Case Study.pdf 

Presentation Recording: No Presentation Recording Due to Technical Difficulties

 

Session_19-3

 

When your organization is moving to cloud, the infrastructure layer transitions from running dedicated servers at limited scale to a dynamic environment, where you can easily adjust to growing demand by spinning up thousands of servers and scaling them down when not in use.

 

The future of DevOps is infrastructure as code. Infrastructure as code supports the growth of infrastructure and provisioning requests. It treats infrastructure as software: code that can be re-used, tested, automated and version controlled. HashiCorp Terraform adopts infrastructure as code throughout its tool to prevent configuration drift, manage immutable infrastructure and much more!

 

Osama Mustafa is Founder of Gurus Solutions, Oracle ACE Director, Creator/Director of Jordan Amman Oracle User Group (the first group in Jordan related to Oracle technology), and author of the book Oracle Penetration Testing. Osama has been working on project and customer support in the EMEA region and providing database implementation solutions. His specialties are Fusion Middleware, in-memory database, TimesTen, Exalytics, and Exalogic machine. He is a frequent speaker in Oracle user groups around the world and one of the RAC Attack event organizers and Fusion Middleware Attack organizers. Osama has published articles in Oracle Magazine, OTech Magazine, and UKOUG's Oracle Scene Magazine, and he is a blogger and Certified in Oracle Database and Fusion Middleware. He shares his knowledge through conferences, webinars, white papers, slide share, and blog posts to the Oracle community. Simply put, he is Oracle-passionate.

 

Presentation Slides:19-3_Best Practices of Infrastructure as Code with Terraform.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_19-4

 

Terraform is an open-source infrastructure as code software tool created by HashiCorp, released in 2014, that has gained strength in the automation environment. So do you know Terraform or Ansible? In an ever changing IT world , if you are a DBA and don't know these technologies, you are falling behind.

 

In this session you will understand the benefits of what Terraform and Ansible are, how they can work together, and how these toys can help you garner the power of your Hybrid Cloud.

 

Currently I am an Oracle ACE; Speaker at Oracle Open World, Oracle Developers Day, OTN Tour Latin America and APAC region and IOUG Collaborate ; Prior Co-President of ORAMEX (Mexico Oracle User Group), Web Events Chair for IOUG Cloud Computing Special Interest Group (SIG) ; At the moment I am Cloud Architect at Eclipsys.

 

Formerly I worked for Oracle as a Cloud Solution Architect in which it involved in many challenging projects including, Exadata, ODA and EM 12c implementation, as well as upgrade projects specialising in backup strategy and high availability solutions.

 

In my free time I like to say that I’m Movie Fanatic, Music Lover and bringing the best from México (Mexihtli) to the rest of the world and in the process photographing it. 

 

Presentation Slides: 19-4_DevOPS for DBAs_Your Automation Power Toys.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_20-1

 

Oracle database upgrades can seem like a daunting task if you are like most DBAs who only upgrade every few years. What if you have a stand-alone (non-Oracle RAC) database and want to switch from a non-container database to a container/pluggable configuration? I know this sounds like a lot more work, adding to an already stressful situation. However, please know it only requires a few extra steps and results in greatly improved resource utilization.

 

This presentation provides step-by-step instructions for upgrading from Oracle 12.2 to 19c and converting from a non-container to a container/pluggable configuration. Iíll even throw in the steps for upgrading an OEM repository to this configuration at no extra charge

 

Executive Director AEM Corporation Speaking Engagements: Oracle East Coast User Conference, Oracle Fed Forum, Adjunct Instructor at George Mason University.

 

Over 20 years of professional IT experience with extensive focus on Oracle Database Administration. Experience implementing complex Oracle technologies such as Exadata, Advanced Replication, Dataguard, GoldenGate, Oracle RAC, WebLogic, and Oracle RAT.

 

Certifications:

Oracle Cloud Infrastructure Architect Associate

Oracle Exadata Implementation Specialist

Oracle Real Application Clusters and Grid Infrastructure Administration

Oracle Certified Professional

Certified Information Security Manager (CISM)

Project Management Professional

 

Presentation Slides: 20-1_Upgrade from Oracle 12.2 to 19c With Container Pluggable.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_20-2

 

Let's face it, query tuning is key to peak performance in any database. However, if you are an Oracle expert suddenly tasked with tuning SQL Server queries, that task can become daunting. Lots of developers and DBAs constantly struggle to pinpoint the root cause of performance issues and spend way too much time in trying to fix them. In this presentation, I will share my tried and true best practices for tuning SQL Server statements and other issues. By utilizing Wait Time Analysis, reviewing SQL Server execution plans, and giving tips on which operations to look out for, you will be able to quickly tune queries that are affecting performance. In addition, we'Ìll explore SQL diagramming techniques to find the best execution plan, and several case studies will be used to demonstrate these best practices.

 

Janis Griffin has over 30 years of Oracle DBA experience including design, development, and implementation of many critical database applications. Before coming to Quest, Janis held DBA positions primarily in the Telecom / Network Industries, working with both real-time network routing databases and OLTP business to business applications. As an Oracle ACE, Janis has mentored other DBAs and Developers on best practices in database performance tuning. As a highly successful liaison between management and technical staff, Janis has proven to be an effective collaborator implementing cutting-edge Oracle solutions.

 

 

Presentation Slides: 20-2_Can an old Oracle expert tune queries in SQL Server.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_20-3

 

Shell scripting to the rescue: Cloud CLI solutions, like oci-cli or aws-cli are strong yet easy ways to automate simple repeatable tasks covering cloud native resources as itís a direct, human-readable doorway to your cloud platform.

 

Join this session to have a prime experience on how to combine shell scripts with OCI CLI or any Cloud CLI tool to launch a compute instance up to deploying a static website in 6 different operating systems.

 

The emergence of Cloud oriented roles in the job market makes it the perfect occasion to benefit from the use cases/samples I made available in GitHub to get you started in your IaC journey into the Cloud.

 

"Kosseila has more than 13 years of IT experience including 10 years in Oracle and three in SQL Server technologies.  His technical background spans numerous industries ranging from Telecommunications to Healthcare, including banking sector.

 

He is an Oracle ACE, Certified Professional 11g, Oracle RAC and Data Guard Certified Expert which positioned him as a High Availability MAA specialist. Furthermore, his SQL Server experience allows him to broaden his expertise on Commercial relational Databases (Oracle / Microsoft products).

 

Among his recent additions are experiences/skills related to the CLOUD including Devops,OCI,AWS,Azure(terraform ,ansible in the cloud) and virtual platforms as vagrant, OVM, virtualbox ,and OLVM.

 

Curious by nature and eager to explore new techniques, he is also involved in the community through blogging and a few open source contributions.   

 

twitter : @brokedba Blog: https://brokedba.blogspot.com/"

 

Presentation Slides: 20-3_Script Your Way Into the Cloud Using Cloud CLI (OCI-Azure-AWS) and Interactive Shell Scripts.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_20-4

 

The proliferation of cloud applications through the modern enterprise has affected a fundamental shift in the kinds of data organizations are sifting through:

 

  - Not all data are relational.

  - Not all data are corporate.

  - The cost of storing data long-term is now negligible.

 

This shift has caused a new entry in the extract, transform and load category: the Streaming ETL platform.

 

In this session, I'll dispel misconceptions around what ìStreaming ETL'' means, and explain why event streaming and event-driven architectures compel us to rethink old approaches. Using Apache Kafka, the Confluent Platform, and ksqlDB, I'll dissect the concept of events, how they relate to tables and streams, and how to disentangle sources and targets in a data pipeline.

 

Stewart is Chief Customer Officer at Qualytics, and the Founder and former CEO of Red Pill Analytics. He is an internationally recognized writer, speaker, and podcast guest in the data and analytics community and holds numerous community advocacy titles including Snowflake Data Superhero, Oracle Groundbreaker Ambassador, and Oracle ACE Director.

 

Presentation Slides: 20-4_Streaming ETL, and the Disentangling Power of Events - Qualytics.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_21-1

 

Back in 2019, Microsoft and Oracle announced a partnership enabling customers to migrate and run mission-critical enterprise workloads across Microsoft Azure and Oracle Cloud.

 

This extremely low-latency, private connection can distribute workload, and it opens a world of possibilities including deploying applications using the best of Oracle Cloud and Microsoft Azure. Scenarios such as running Oracle E-Business Suite in Azure with its databases operating in Oracle Cloud are now entirely possible.

 

Highlights on the current offerings, support and licensing models, details on performance, and a list of pitfalls are covered in this presentation. Join this presentation to learn more about what the Oracle and Microsoft Cloud partnership is all about, how it works, and what this means for cloud interoperability.

 

Ahmed Aboulnaga is a Senior Principal at Maximus. Ahmed's professional focus is in technical management, architecture, and consulting within Oracle, Java, and cloud technologies, having implemented enterprise solutions for commercial, government, and global customers throughout his 20 year career. Ahmed is an Oracle ACE, has written two books on Oracle SOA, and currently helps organize IaaS and PaaS meetups for NATCAP-OUG and Quest. Prior to joining Maximus, Ahmed has worked for leading consulting firms that include Oracle, IBM, Booz Allen Hamilton, and CSC. Born in Washington DC, Ahmed holds a master's degree in Computer Science from George Mason University.

 

Presentation Slides: 21-1_Everything You Need to Know About the Microsoft Azure and Oracle Cloud Interconnect.v6.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_21-2

 

This presentation will look at 12c to 21c new features that should be investigated for use which include Multitenant, In-Memory, Oracle 19c Automatic Indexing, and many more. I will discuss the 12c to 21c Journey for these new features with examples and sample code. Attendees can expect brief introduction of all the new features with deep dives into Multitenant, In-Memory, and Automatic Indexing.

 

Anuj is an Oracle ACE and frequent speaker to various Oracle conferences like Oracle Open World, collaborate, Great Lakes ,East Coast and local user groups. He is also a regular speaker at Northern Kentucky University (NKU). He is founder of Oracle 12c SIG (IOUG). He has over 20 years of experience as Oracle DBA He is Oracle certified Exadata implementation expert. He is Oracle certified professional (OCP) for Oracle 11g and 12c and Certified in Oracle and AWS Cloud.

 

Presentation Slides: 21-2_Database 12c to 21c Journey of Key Feature Sets.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_21-3

 

This session discusses how the compression features, included with Oracle Database, can reduce your database storage footprint (typically by 50% or more) and help improve database performance.

 

Gregg Christman is a Senior Manager in Core Database Product Management at Oracle responsible for Advanced Compression, Hybrid Columnar Compression and Information Lifecycle Management. Gregg has been with Oracle for 14 years, having previously held the position of Director of Competitive Intelligence for Database and Data Warehousing.

 

Presentation Slides:21-3_Tips and Tricks with the Compression Features Included with Oracle Database.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_21-4

 

Security is an evergreen topic - no matter how, when, and where. I am here to share my in-depth technical experience of implementing Oracle Transparent Data Encryption (TDE) in the latest versions of databases. Please join me to hear the entire lifecycle of this successful implementation including but not limited to customer expectation, project timeliness, license planning, major roadblocks, and the final outcome.

 

Heema is a seasoned IT professional having worked worldwide - India, Japan, Malaysia, Singapore, Switzerland, and USA. She holds an Oracle Ace status and loves to be part of the community group. She is currently working as "Manager, Infrastructure and Cloud Solutions" with Computer Technology Resources, Inc and oversees a team of Infrastructure and Cloud Experts performing complex upgrades and migrations to various cloud flavors including but not limited to OCI, AWS, Google.

 

Presentation Slides:21-4_Get Your Database Vaccinated_Oracle Transparent Data Encryption with Almost Zero Downtime_v1.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_21-5

 

Efficient applications require the best performance from all components used to present the application. If you are using cloud services, tuning of some components is out of your control. Still, regardless of your use of cloud, your job as an application developer is to ensure that your database code runs as efficiently as possible. It is so much easier to create highly performant code in the first place than to have to fix the code later when you find that it isn't performing well in production.

 

 A small set of PL/SQL coding techniques that help performance have been developed over the years, but those who are relatively new to the language may not have been exposed to them. Those who have experience with PL/SQL may appreciate a review of the performance techniques they have been using.

 

This presentation explains to both of these audiences the basic techniques for creating the most efficient PL/SQL code, for example, caching local variables, iteration handling, reducing context switching, datatype selection, and various methods for cursor handling. Sample code will illustrate the principles.

 

Peter Koletzke is an Oracle ACE Director who has worked for over 37 years in the IT industry and has presented at various Oracle technology conferences around the world over 380 times. Additionally, he has won over a dozen user group awards from ODTUG, NYOUG, UTOUG, and ECO/SEOUC. Peter is also an Oracle Certified Master, UTOUG board member, past board member of IOUG and NYOUG, and co-author of eight books – with Duncan Mills, Avrom Roy-Faderman, and Dr. Paul Dorsey and published by Oracle Press (McGraw-Hill Professional) -- about Oracle JDeveloper/ADF, Oracle Forms and Reports, and Oracle Designer.

 

Presentation Slides: 21-5_PLSQL 101_5_ Basic Tips for Highly-Performant Code.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_21-6 and Session_22-3

 

OKV 21.1 introduced secrets management as an additional offering, based on OKVs RESTful services as well as Java and C SDKs. This presentation will introduce secrets management in OKV with practical examples, that extend into tips and tricks about JSON and how to interact with OKV in a secure fashion. The examples demonstrate development of a scalable solution to provide password management for automated maintenance scripts, private key management for public key authentication, and other valuable use cases.

 

Seasoned DBsec Product Manager, eager to share the latest and greatest new features of Oracle Key Vault, the only supported on-prem key management solution for TDE-enabled databases.

 

OKV makes heavy use of JSON for key and secrets management and I would like to share what I learned with the community.

 

Presentation Slides: 21-6_22-3_V22-Practical Use Cases for Secrets Management in Oracle Key Vault .pdf

Presentation Recordings: No Presentation Recording Due To Technical Difficulties

 

Session_22-1

 

Hospital supply chains are very complex and clinically impactful supply chain disruptions are unfortunately not uncommon. Mismanagement of complexities can result in situations in which employees are unable to carry out their mission as caregivers. On top of these disturbances, Covid-19 has drastically disrupted the medical supply chain. The best way to handle supply chain management (SCM) disruptions and optimize day-to-day supply chain efficiency is with an upgraded SCM system.

 

Oracle Cloud offers a Clinically Integrated Supply Chain Solution that provides a patient-centric supply chain specifically designed to handle the complexity of hospital SCM utilizing IoT, AI, and blockchain. It automatically generates recommendations to optimize scheduling and reduce costs while offering end to end supply chain visibility that provides real-time inventory levels and warnings of potential delays. Cost efficiency is maximized by expanding supplier selection and uses data analytics for cost analysis and management to suggest cost reduction strategies. Additionally, statistical models are used to predict demand and generate purchase requisitions that will align supply and demand. Oracle Cloudís Clinically Integrated Supply Chain Solution goes beyond basic supply chain optimization to provide solutions designed especially for clinical settings.

 

Audrey Vicino serves as Associate Consultant at Premier International, a technology consulting firm based in Chicago that helps enterprises solve complex data problems. Audrey has specialized in data migrations to Oracle Cloud for the last 2 years, with a focus on Supply Chain transformation in healthcare. Her latest presentation was delivered to the North Central Oracle Users Group (NCOATUG) in October 2020, where she addressed the impact COVID-19 has had on ERP implementations in healthcare and the continuing importance of technology investments in the face of a pandemic. Audrey Vicino is currently the leading developer for SCM data conversions with one of the nation’s largest hospital systems.

 

Presentation Slides: 22-1_Covid-19 Can't Stop Our Hospital ERP Implementation.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_22-2

 

The MySQL InnoDB storage engine needs a primary key to work best and how that key is designed impacts how data is retrieved. The lack of a proper primary key can greatly slow things down. Secondary indexes 'piggy back' on the primary key which means a bad primary key hurts more. Plus for every insert, update, or delete, the index and the data table must be update, which can become too much overhead.

 

Histograms are designed for data that does not churn, and they do not have the overhead of an index.  But it may not fit your data.

 

This session will cover how to properly build indexes and histograms for faster queries.

 

Dave Stokes is a MySQL Community Manager for Oracle. Previously, he was the MySQL Certification Manager for MySQL AB and SUN. He has worked for companies ranging alphabetically from the American Heart Association to Xerox and performed work ranging from anti-submarine warfare to web developer. On Twitter he is @Stoker, and his blog is at http://elephantdolphin.blogspot.ie/.

 

Presentation Slides: 22-2_MySQL Indexes Versus Histograms-Stokes.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_22-4

 

Tired of grinding away to try to come up with a database tuning action plan? This presentation details how to get to database tuning actions more quickly by aggregating findings and recommendations across multiple Advisor runs. The author details his custom tools (simple SQL statements) that expose many undocumented features of the Advisor framework. In the DBA or developerís hands, these tools can massively scale-up your ability to action tuning opportunities exposed by the various Advisors.  The excellent findings and recommendations that come out of the various Advisors such as the SQL Tuning Advisor, the Automated Database Diagnostics Monitor (ADDM), the Segment Tuning Advisor, and the SQL Access Advisor will be of particular focus in this presentation.

 

Oracle ACE, Roger Cornejo has over 36 years’ experience with large/complex Oracle applications (versions 4.1.4 – 19c) in roles such as Developer, Tech Lead, Enterprise Architect, Database Architect and project manager. Roger has a strong background in DB performance analysis and tuning, and for the past 11 years, diving deep into AWR tuning data. As a thought leader, he has been sought out for his expertise in tuning (presenter at the past 11 East Coast Oracle Conferences, as well as INSYNC21, Oracle Open World, COLLABORATE, RMOUG, and Hotsos). Additionally, Roger authored a book on his recent work, Dynamic Oracle Performance Analytics: Using Normalized Metrics to Improve Database Speed, the book is available through Amazon and Apress: http://www.apress.com/9781484241363 https://www.linkedin.com/in/roger-cornejo-1805642/ @OracleDBTuning

 

Presentation Slides: 22-4_PerformanceTuningUsingtheAdvisorFramework.pdf 

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_22-5

 

Ansible is an IaC tool that can accelerate infrastructure deployment

and simplifies configuration management. Ansible is an open source community project designed to help organizations automate provisioning, configuration management, and application deployment. It not only helps in automating on premise components, but also helps in deploying and managing cloud components.

 

Participants will start learning with the fundamentals of Ansible, including architecture and use cases. Later on, they'll get the direction for setting up Ansible on laptops and using it with help of Docker containers. In addition, the usefulness of Ansible in setting up Oracle cloud components will be discussed. In the end, best practices of using Ansible will be discussed.

 

Sumeet Kabra has 15+ years of experience with Oracle Database and Oracle E-Business Suite.

He is currently Cloud Architect for Oracle Cloud Infrastructure and has been working for more than fourteen years with Oracle Corporation.

 

Prior to Oracle, Sumeet worked as an analyst in Birlasoft Inc. for one year. He received best performer of the year twice and was an Oracle Pacesetter Award winner for three years.

 

He is Oracle Cloud Certified Professional Architect .

 

Presentation Slides:22-5_Automate OnPremise and Cloud Infrastructure - The Ansible Way_skabra.pdf

Presentation Recording: Session recordings are available now in our Members-Only section of this website.

 

Session_23-1

 

Join us for this open questions and answers session with Oracle Database Product Managers Markus Michalewicz and Gerald Venzl. During this session, we invite you to take the opportunity to bring forward your questions and get them answered live. Even if you do not have any questions, you might learn about one or the other thing you may have not even thought about yet. The session will be interactive and fun while also being informative and should be a definite "have to attend" for everyone!

 

Markus Michalewicz has been with Oracle for 20 years in various positions. He is currently a Vice President with Oracle America and manages the Oracle Database High Availability (HA), Scalability, Maximum Availability Architecture (MAA) and Cloud Migration product management (PM) team, which is part of Oracle Database development. Using database technologies such as Oracle Real Application Clusters (RAC), Application Continuity (AC), and Oracle Data Guard, including the Active Data Guard option, his team has helped to ensure 24*7 availability of critical, high-throughput OLTP and DWH database systems around the world and revolutionized the way Oracle’s customers get to experience the Oracle Database on-premises as well as when moving into the cloud using Zero Downtime Migration (ZDM). Applying real-world experience and customer feedback, his team has been instrumental in designing Oracle’s Database Cloud offerings, including Oracle Autonomous Database, following and defining Oracle's industry-leading Maximum Availability Architecture (MAA) best practices.


Gerald Venzl is a Distinguished Product Manager for Oracle. During his career, Gerald has worked as a Developer, DBA, Performance Tuner, Software Architect, Consultant and Enterprise Architect prior to his current role, while still being active as a developer in his free time and on open source projects. This allowed Gerald to live several different lives in the IT sector, providing him with a solid understanding of the concerns in these individual areas while gaining a holistic view overall. In his current role Gerald is responsible for improving the developer experience of the Oracle Database and the Oracle Cloud. Besides that, Gerald focuses on advocating how to build systems that provide flexibility yet still meet the needs of the users. He is also a member of the ISO SQL Standard committee.  

 

Presentation Slides: No Presentation Slides

Presentation Recording: Session recordings are available now in our Members-Only section of this website.


 

 


 

Rocky Mountain Oracle Users Group (RMOUG)
 a 501(c)(3) non-profit corporation in Colorado

Privacy Policy

Powered by Wild Apricot Membership Software