Presented at INSYNC 21

Session ID: 101110

These days supporting business means always handling varied and shifting priorities. But, if you expect your Oracle databases to handle these changes and perform consistently at high levels, you need to have a maintenance process. The first part of that is an assessment: How are my databases performing, and are there any problems? It sounds simple, but for most modern complex database environments, a proper assessment requires a variety of tools and a lot of experience interpreting the results.

Presented at INSYNC 21

Session ID: 100470

Moving to the cloud is not easy. It requires effort and skills and, in most cases, downtime. How can you minimize all three requirements and move your database with minimal downtime running just one command from the command-line? We will discuss the benefits and challenges of different migration methods and where the Oracle Zero Downtime Migration tool can save time and effort. The discussion will be based on real migration cases and on-hands experience of moving a large database environment to the new home.

Presented at INSYNC 21

Session ID: 101560

Oracle Database 21c has been released and is the latest innovation release of the Oracle Database.  A number of new security features are included with this release and should be adopted when creating new databases or upgrading existing databases. Learn about the new security features and changes in security for this database release. Key new security features are blockchain table, gradual database password rollover, mandatory case-sensitive passwords, and Unified Auditing enhancements.

Presented at INSYNC 21

Session ID: 101990

This workshop starts with a napkin design of data structures we would like to use for a proof-of-concept. Using Quick SQL you will quickly define the data structures and utilize various table and column directives to better define the tables and also create some dummy data. You will then be creating an application based on the new tables. Lastly, you will be updating some of the generated components to improve the initial app.

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.