Presented at INSYNC 21

Session ID: 100980

The Latest Persistent Memory such as Intel Optane Persistent Memory (PMEM) combines near-DRAM performance with the data persistence of storage. It can be configured in memory mode or application direct mode.  When the memory mode is used, PMEMs can be considered as volatile and can be used as main memory and DRAM is treated as a write-back cache. PMEMs can also be configured in application direct mode to store database files and redo logs. This presentation will discuss the use cases of PMEM:1)  In memory mode use PMEMs for Oracle In Memory store ;2) in Application direct  mode to store the database files, namely persistent Memory Database in  Oracle 21c. We will discuss the significant performance benefits that can be achieved from either of these two modes. We will discuss the Persistent Memory Database feature that includes directly mapped buffer cache and Persistent Memory Filestore (PMEM Filestore) in Oracle 21c. We will also discuss how PMEMs are used in Oracle Exadata X8M.

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 INSYNC 21

Session ID: 101690

Learn about what's new in Oracle Database 21c for Database development.  Oracle Database 21c is packed with innovative new features from Blockchain Tables and Native JSON support, but have you heard about any of  the SQL and PLSQL innovations?   Attend this session to learn more about what your missing.

Presented at INSYNC 21

Session ID: 101700

Learn how Intel Optane Persistent Memory works with Oracle Database 21c.  See how to configure your Oracle database for faster writes with a PMem filestore.

Understand the difference between PMem App Direct Mode and Memory Mode.  Compare Oracle 21c with DRAM + SSD vs PMem vs TimesTen Cache for OCI and JDBC workloads.

Presented at INSYNC 21

Session ID: 101720

The death of Oracle Forms has been greatly exaggerated. Despite 2 decades of development, Forms is still the backbone of thousands of mission-critical applications worldwide. But where do our tried and true Forms stand while all systems are undergoing a user experience revolution or moving to the cloud? In this session, we will show how Oracle Forms is now a full member of Oracle’s cloud, mobile, and even Chat ecosystem. We will review the 4 ways that you can extend your existing Forms investments to the cloud, including:

-“Lift-and-Shift” your Forms servers to Cloud Servers - OCI
-Extending your applications using Oracle’s rapid development tool Visual Builder Cloud Service (VBCS)
-Leveraging existing business logic through Chat interfaces using Digital Assistant cloud service
-Doing DevOps using Developer Cloud Service.

The answer to how to bring your Forms into the next generation will be revealed during this session. Along with live demos and Q&A.

Presented at INSYNC 21

Session ID: 101010

Infrastructure as code is the process of managing and provisioning computer data centers through machine-readable definition files, rather than physical hardware configuration or interactive configuration tools (by Wikipedia). On this vibrant session you would learn the differences between “configuration orchestration” and “configuration management” tools, and how emergent technologies such as Vagrant, Terraform, and Ansible fit and can be used to define, manage and provision a datacentre infrastructure or even build and maintain portable virtual environments.

The future is here, let's take advantage of it today!

Presented at INSYNC 21

Session ID: 100970

Many Machine Learning tasks need to access a lot of data set, which in many cases are stored in a database such as Oracle Database.  It makes a more scalable solution to do the machine learning task in the database, which is called in-database machine learning.  Oracle Autonomous Data Warehouse (ADW)  comes a library of Oracle machine learning algorithms and a set of building tools such as SQL notebooks  for machine learning.  This allows Data scientists to run Machine Learning projects in Oracle Database without moving data. This session will examine Oracle Machine Learning as part of Oracle database  as well as ADW . We will discuss process of machine learning:  analyze and prepare data set;  build and evaluate and apply machine learning model. We also will discuss the  Oracle machine learning features in Oracle 21c such as  AutoML for In-Database Machine Learning and newly added in-database machine learning algorithms for anomaly detection, regression, and deep learning analysis.

Presented at INSYNC 21

Session ID: 100930

This presentation aims to help you use the Active Session History (ASH) repository to investigate performance problems.  Oracle have produced many presentations that explain how ASH works, so this presentation provides only a very brief overview of how ASH works. 

Presented at INSYNC 21

Session ID: 100910

This talk is for database and information security professionals.

The database holds the crown jewels of the organization; however, the infosec security teams have little understanding of working of the database and database developers, designers, and DBAs have little understanding of security concepts. I get it, we get pressure from the top and the users to deliver a system with little time or budget to apply to database security. In this talk, we are going to take the 10,000 meter view of the database and look at the attack surface, attack vectors, and how to mitigate those attacks. At the end of the presentation, developers, designers, and DBAs will have action items they can take back to their shop and start improving security.

Presented at INSYNC 21

Session ID: 100890

Understanding how Oracle Database data and index compression works, what has changed in the latest versions and discussing compression best practices can help you in getting the best results with Oracle Compression. Join Oracle Product Management to gain insights on compression topics that include: when compression occurs during bulk loads and DML inserts/updates, when to use Index Key (prefix) Compression versus Advanced Index Compression, how to track compression using AWR’s as well as recent Advanced Row Compression and Hybrid Columnar Compression enhancements with Oracle Database. This session is the perfect opportunity to get all your compression questions answered by Product Management.