Presented at INSYNC 21

Session ID: 100740

We are in the midst of a digital disruption. Data-driven organizations are using analytics to add value and generate innovative business ideas using vast amounts of data.  Operating as a “citizen data scientist”/“data entrepreneur,” the thoughtful tech person is finding creative new ways to enable companies across the globe to leverage ever-expanding digital repositories.  From a data analysis perspective, SQL (a language firmly rooted in relational algebra) is an invaluable tool. It is ubiquitous, and while other languages have attempted to supplant it, SQL remains the language of choice. This is because it is a highly performant set-processing language with capabilities that can be used to produce results far beyond what many realize.  Broadly speaking, SQL provides a capability to subset/aggregate/pivot/analyze data, make inferences, and answer questions. A skillful use of this language will enable you to propel your organization forward in this digital era.

Presented at INSYNC 21

Session ID: 100270

In 2020 An internal Oracle team along with several value-add Partners, assembled to develop a Patient Screening, Scheduling, and Testing System.  This system was built in rapid development mode to deal with the much needed Covid19 testing.  The Coalition executed Mockups, POCs, and deployment at unprecedented speed, and due to the short time frame and urgent need, critical decisions on platform stack components, data governance, and long term supportability were quickly made. This session will review how the Coalition addressed the design, governance, and security requirements necessary to implement this system. As part of this discussion, we describe the thought process for final stack design, how the CDC Covid19 guidelines impacted our solution, explain the overall configuration, cost savings and outline the deployment experience.  Key areas of discussion will include Autonomous Database features, Data Catalog, Data Safe, and other Oracle Cloud Infrastructure Services.

Presented at INSYNC 21

Session ID: 100120

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.

Presented at INSYNC 21

Session ID: 100520

With 19c we get the tiny little command line tool that will allow us to update our databases "hands free".  We can do all the prechecks, fix 99% of pre update issues and then do the update and finally the post update all without our manual little fingers on the keyboard, well almost no little fingers on the keyboard.  Wait there is more, it is not all for just Database 19c we can use this on prior versions like 18.5 and new as well as 12c Release 2 (12.2 + DBJAN2019RU and newer)

Presented at INSYNC 21

Session ID: 101610

A task can be done in a very short way and in a very long way. Which one will you choose? Knowledge is Power! This session gives lots of interesting knowledge about an allegedly boring topic - Constraints. And this knowledge will give you the power to optimize and make better decisions.

The behavior of adding columns and constraints to big tables in Oracle may vary significantly, in two aspects - duration and availability - based on the way we perform these operations. In addition, different constraints may have different impact, based on their syntax, types, states, locking, etc.

Attend this session to understand what happens exactly under the hood when we issue a simple ALTER TABLE statement, and how to utilize this knowledge for achieving better performance or higher availability.

Presented at INSYNC 21

Session ID: 101360

What do you need to build a fully automated Oracle DBaaS stack? Hardware, Software and a heterogenous 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. What we have learned when setting up DevOps tools like Ansible and git. 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.

Presented at INSYNC 21

Session ID: 100750

Many developers/DBA’s are challenged by the limitations of the standard AWR tools.  Develop insight and command skill in the right application of the AWR toolset – or risk being drowned in the sea of performance metrics.  To handle the many varied cases where it is necessary to go beyond the standard toolset, the Oracle DB tuner must be able to creatively query the historic performance metrics and quickly discern root causes and provide solutions. 

Get a jump start by experiencing the presenter's process and tools, along with some case studies of real-life performance nightmares that were converted into success stories.  Learn where to look in the AWR data to solve the difficult performance problems.  See the solutions and learn how to apply a results-producing strategy for digging deep in the AWR repository to power past your own specific performance issues.  Additionally, the author will share his various scripts and SQL queries used to make the most effective use of AWR.

Presented at INSYNC 21

Session ID: 100080

With the increase in demand for application to be online 24x7x365, several tasks like upgrades and migrations are becoming a challenge. While keeping in mind that clients want a fool proof migration /upgrade we are also having to ensure we ask for no downtime. This is challenging enough to start with without adding the size of the database in question to be several terabytes. What are some methods that can guarantee a no downtime migration of 100T database? We will explore some options to successfully migrate large databases with zero downtime. Detailing the methods and illustration of the requirements to help audience understand options available to reproduce the migrations in their client space.

Presented at INSYNC 21

Session ID: 101460

This presentation will look at 12c to 21c new features that should be investigated for use which include Multitenant, IN-Memory and 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 dive into Multitenant, IN-Memory and Automatic Indexing.

Presented at INSYNC 21

Session ID: 101100

Multi-factor authentication (MFA) or 2-factor authentication (2FA) for database connections is frequently inquired about, but rarely implemented.  Yet is surprisingly easy to implement in the Oracle Database.

This session covers how to implement MFA/2FA for your Oracle Databases via common MFA platforms including Cisco Duo.  Including specifics of how to get started and test in your own DBA lab environment.