Presented at INSYNC 21

Session ID: 100450

When using Oracle you will find more than enough solutions for High Availability and Data Security. If you have never been confronted with this topic before, you might ask yourself what solutions are there anyway and which one is right for my problem. Without delving too deeply into technical details such as setup and operation, a few of the most common solutions

(Standby Database with Standard Edition via Scripting, Dbvisit, Refreshable PDB, Oracle Data Guard, Oracle Failover Cluster, Oracle RAC One Node and Oracle RAC) will be touched upon briefly and compared with each other. The comparison of the different solutions provides a decision-making for your environment.

Presented at INSYNC 21

Session ID: 101510

In Oracle Database 19c, Oracle Database Standard Edition no longer supports Real Application Clusters (RAC). However, Oracle introduced a new feature: SEHA (Standard Edition High Availability). This is not RAC by any means, but it provides a high availability solution that is easy to implement and manage.. This session will explain what SEHA is, the differences between RAC and SEHA, and will dive into how SEHA behaves in different scenarios.

Presented at INSYNC 21

Session ID: 100480

Cloud bill could be an unwelcome surprise at the end of the month if you didn't keep eyes on the resources and cost. We have some native tools and reports embedded into the cloud management layer, but it might not be sufficient if you want to analyze and predict the cost. One way is to use the Oracle cloud-free tier to create a data pipeline with Apex frontend for the custom billing and usage reporting interface. I will share my experience and challenges working with Oracle cloud API and usage reports and creating my Apex billing application.

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

Infrastructure as Code (IaC) is the future of cloud based architectures. This talk aims to empower learners to embrace IaC solutions. Leveraging Terraform and the OCI Resource Manager, attendees will deploy OCI infrastructure including VCNs, subnets, VMs and an autonomous database using a few lines of code. The opensource visual designer tool okit will also be introduced and shared with the audience.

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

After the events of 2020 – a once-in-a-century pandemic, an unprecedented economic downturn, social upheaval, and several hotly-contested political races - it’s easy to become discontented with your IT career path, and maybe even consider a different line of work. But the truth is that the future of IT is so incredibly bright and its horizons so tremendously broadened that the exact opposite is true: You’d better get your sunglasses ready, and you might even want to buy a few more pairs.

Presented at INSYNC 21

Session ID: 101380

Oracle Machine Learning’s new AutoML UI makes ML easier than ever before.  OML’s AutoML automates many of the time-intensive and repetitive aspects of a data scientist’s job including algorithm selection, feature selection, and hyperparameter tuning.  AutoML UI enables “citizen data scientists” to leverage AutoML in ADW with a simple, intuitive, easy to use UI.   Using AutoML UI, data scientists and citizen data scientists can focus on the important phases of ML: Defining the problem, assembling the “right data”, disseminating the model’s insights and predictions, and deploying the model enterprise-wide.  Come see the new AutoML UI and learn how easy it is to get started.