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

Top 10 Features & Services for Oracle DBA on Oracle Cloud, Plus Challenges.

The SIG session is planned to be interactive. If you are an Oracle Cloud Infrastructure (OCI) user with Oracle Database on IaaS, DBCS, ExaCS, or Autonomous DB, we want to hear from you about what you like and the challenges you face. If you are not running your database on OCI yet, come to this session to understand the benefits and discuss your concerns.

Presented at INSYNC 21

Session ID: 100130

Oracle has a history of delivering data management solutions of choice for managing customers’ operational and analytical workloads on-premises and in the cloud. Jenny Tsai-Smith, Vice President of Database Product Management, shares Oracle's strategy for continuing to deliver truly unique and innovative products and services to meet and exceed customers' requirements.

Presented at INSYNC 21

Session ID: 101870

Databases running on the cloud are not exactly the same as on-premise databases. They have different deployment models and network architectures, the protocols for accessing them are strictly controlled, their configuration is locked down, and some administration commands are blocked. This raises a question on how to effectively monitor an Oracle Database cloud ecosystem. Join this session to learn practical examples of how to diagnose and resolve application problems using various tools that help DBAs with day-to-day tasks and master cloud database management.