Presented at INSYNC 21

Session ID: 101980

Abstract: Oracle Data Safe now helps secure databases on-premises and in the Oracle cloud. Data Safe helps you identify unnecessary security risks, detect configuration drift, find and monitor your riskiest users, assess the type and amount of sensitive data within your database, and remove risk from non-production databases. In this workshop, you’ll practice the main features in Oracle Data Safe, including Activity Auditing, Security Assessment, User Assessment, Data Discovery, and Data Masking.

Presented at INSYNC 21

Session ID: 100100

Oracle Machine Learning comes free in every Autonomous Database. Oracle Machine Learning Notebooks provide easy to understand, reuse and repurpose ML methodologies that apply OML’s 30+ machine learning algorithms for in-database, parallelized implementations of classification, regression, clustering, anomaly detection, text mining, associations machine learning functions that can be used to tackle a wide variety of data-driven problems and to build “predictive” applications. This session will step through five (5) OML notebooks that can serve as the core of many data science projects:  classification, attribute importance, time-series forecasting, text mining and anomaly detection.

Presented at INSYNC 21

Session ID: 100310

This session will introduce Oracle RAC in the context of Developers attempting to use Oracle Database. The session will cover tips and tricks to ensure that developers can benefit from features like session failover, load balancing with minimal effort.

Presented at INSYNC 21

Session ID: 101290

Nobody complains that the database is too fast.  But speeding up queries is often seen as a 'dark art' and a mysterious process.  You add an index but then things go slower. This workshop explains how indexes and histograms really work, how to use them efficient, and how to really speed up your MySQL queries.

Presented at INSYNC 21

Session ID: 100440

It seemed so simple—migrate a relatively small legacy database from DB2 to Oracle Autonomous Data Warehouse. Nobody knew the dark secrets this database was hiding before the SOW was signed and the project was underway, but by then it was too late! Follow along as a well-planned project grows from unassuming and ordinary into a monster, devouring everything in its path and tossing aside timelines! A twisting tale, full of wrong turns and peril, heroes and villains, challenge, failure, ultimately ending with... Wait, you didn't think I'd give away the ending, did you?

This session is not a reference or a how-to. It's more of a what-not-to-do, reflecting and laughing (in hindsight) at a series of unfortunate circumstances and mistakes. It's a set of lessons in resilience and determination. It's about overcoming technical obstacles and human objections, and leveraging the tools and features in OCI so they all lived... Well, let's not spoil things!

Presented at INSYNC 21

Session ID: 100680

We will look under the hood of a famous monolith: How does the Oracle Database really work? The RDBMS has to keep many promises to ensure consistent transactional operations. Most of them are found in the acronym "ACID".

We will hear explanations to terms like A in Archivelog or Alert Log or ASM, H as in High Availability, M like Multitenant, R like Redo Log, S as in spfile, T like Tablespace, and U like Undo.

Presented at INSYNC 21

Session ID: 100170

Oracle Database 12 Release 2 is packed with enhancements for DBAs and Developers.  Come listen to all the pertinent new features in Oracle 12.2/18c/19c that will change how you perform maintenance and tune the database.  This session is not the traditional Oracle 12.2/18c/19c database features.

Presented at INSYNC 21

Session ID: 100560

Enabling and sustaining the highest possible performance along with continued application availability is a major goal for all mission-critical applications in order to meet the demanding business SLA’s. Harnessing key features in the latest vSphere release 7.0 U1 including Persistent memory, Para Virtualized RDMA, 1GB Huge Pages, vNVME Controllers, Improved Distributed Resource Scheduler (DRS), Assignable Hardware, Refactored vMotion, etc helps achieve those stringent business goals. This session discusses accelerating Oracle Enterprise IO-intensive workloads with vSphere 7.0 new features enhancing high availability, faster data loading, etc, and share key considerations and lessons learned.

Presented at INSYNC 21

Session ID: 100350

Attend the first-ever Oracle Maximum Availability Architecture (MAA) Special Interest Group (SIG) meeting at Quest INSYNC 2021! The need to deliver increasing levels of availability continues to accelerate as enterprises reengineer their solutions. Given this fact, we will provide an update on the former Oracle RAC SIG along with an overview of the goals and objectives of the MAA SIG. Join this session to meet the new board and to learn about upcoming webinars as well as other activities going forward. The current Oracle Liaisons Anil and Markus will answer questions and receive feedback around topics such as Oracle MAA, HA and Scalability. Looking forward to virtually meeting you in our inaugural MAA SIG session!

Presented at INSYNC 21

Session ID: 100320 

Oracle Autonomous Database and its Oracle Machine Learning Environment

Based on Oracle Cloud Infrastructure (OCI), Oracle Autonomous Database cloud service is optimized for several workloads options: Autonomous Data Warehouse (ADW), Autonomous Transaction Processing (ATP), and Oracle Autonomous JSON Database.

This discussion will cover the Oracle Autonomous Database cloud service, its components, its provisioning process, and its free trial tier and always free offering. This session will also discuss the Oracle Machine Learning service that comes with Oracle Autonomous Database and how database professionals can take advantage of this environment to start learning Oracle machine learning.