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

JSON data is becoming increasingly prevalent in many enterprises today. As a result the world of data management now includes the need for storing JSON documents in a fast, reliable and secure way. What better place to store and manage this data then in the Oracle Database? ...and best of all it's totally free!

This session covers the different approaches to loading, storing, retrieving and managing JSON in the Oracle Database including the new native JSON datatype introduced in Database 21c.

The session will include live demonstrations.

Presented at Quest Experience Week (QXW) – Database & Technology Day

This presentation will look at which 19c new features that should be investigated for use. This presentation will also have a few 21c new features such as AutoML. This presentation will also look at which 18c new features that should be in use (such as Snapshot Carousel, PDB Switchover, In-Memory External Tables, Merge Partition Online, Advances in the Approximate Query, Polymorphic Tables, Standby Nologging, and Password-less Schema Creation – & others). Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples, where possible, to show the basic functionality of the new features. Some features are too new to show examples but only explain. We will also look at the autonomous database and Oracle’s focus on the future of security.